Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
554
questions
1
vote
1answer
23 views
Forcing FME to read a date column in Excel as a text-encoded attribute
I am reading an Excel spreadsheet which has a column containing date values using FME.
The problem is that all date value are encoded as normal text in Excel, except a few cells which are encoded as ...
0
votes
0answers
12 views
How to use a Value of an iterator row selection as a SQL request in ModelBuilder
I am trying to put as an input a XLS file with rows, each row represent the reference of an object.
I would like to iterate each row, and for each reference, collect all the data from my geodatabase.
...
4
votes
1answer
72 views
Making a join permanent using QGIS 3.16 with a shapefile and Excel spreadsheet
I have a point layer representing sites where data was collected. The data was edited and stored in an Excel spreadsheet (CSV). I needed the data to be joined to the sample sites. I followed the steps ...
0
votes
0answers
14 views
Joining Excel with hyperlinks from Excel to ArcGIS Pro or ArcMap
I was trying join a Excel spreadsheet with hyperlinks to the ArcMap and ArcGIS Pro based on the same field. The hyperlink text went through the join, however, the actual hyperlink did not go through.
0
votes
1answer
34 views
Having more than 10 letter on header while exporting SHP to Excel using ModelBuilder ArcGIS
When I export a shapefile to Excel from ArcGIS using ModelBuilder the header maximum length is 10. I would like to know how can I have more.
0
votes
0answers
14 views
Using ArcGIS Online feature service attribute table dynamically in Excel
I've been trying to find a solution for a while now that will allow me to view a feature service in Excel without having to export. I'm aware of the ESRI Office add-in, however, this is only to upload/...
0
votes
0answers
43 views
Speeding up my Python code for reading from Excel, performing geospatial analysis and writing to Excel files
I have written a Python snippet that reads lat and long stored in an Excel file. Converts them to a point which is then used to perform multiple geospatial analysis including buffer, intersection, and ...
0
votes
1answer
23 views
Access MDB connection file result does not have an object ID in ArcGIS 10.8
I have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to ...
0
votes
0answers
25 views
Importing points within a series of non-geolocated pdf maps and Excel data
I have a series of maps that have been drawn on by hand (points and areas) that have been given to me as PDFs, along with a series of interview PDFs explaining what those points and areas are (there ...
3
votes
0answers
31 views
Create link for open specific object in the project map in QGIS
I am working to link Excel and QGIS. Is it pssible to create a link that can be put in Excel and when cklicked open the map/project zoomed to the specific object?
Greets
0
votes
0answers
18 views
Reading geometry that starts with “0xB508000…” and may be WKB
Someone has given me an Excel file that seems to have been exported from ArcGIS. All columns are fine, except for the geom field. Every row in that field starts with 0xB508000... and some number of ...
0
votes
1answer
33 views
Converting excel integer date format to datetime using QGIS
How to convert Microsoft Excel date format to datetime format using QGIS?
In example: 43089 in MS Excel is 2017-12-20.
0
votes
0answers
52 views
How to transform X and Y coordinate on a delimited text imported layer
I added excel sheets into my project using the deliminted tab and used the X and Y columns that are in a mercator coordinate system, I am using QGIS 3.14. These layers are not showing up in my project ...
0
votes
0answers
23 views
Adding data information into the layers
As total newbie of QGIS, I am slowly progressing into using properly QGIS but I lack of knowledge of the software.
I am missing the knowledge to edit .shp files in the goal of adding or changing data.
...
0
votes
0answers
56 views
Excel Sync Plugin in QGIS
I am trying to sync excel file with shapefile, I tried excel sync plugin but couldn't implement successfully. Could anyone tell how to use this plugin to sync shapefile with excel file.
0
votes
0answers
27 views
Mapping points from Excel sheet with listed addresses using ArcGIS Pro
After I add the Excel sheet into ArcGIS Pro, how do I go about placing each address onto the map?
I may want to start off mapping the data just in California. This is from the National Register of ...
6
votes
2answers
89 views
Exporting layers to different sheets of an Excel file
I have two memory layers that I would like to write their attribute tables to the same Excel file but in different sheets. So far, I've managed to write the attribute tables to separate files using ...
1
vote
0answers
54 views
Combining Microsoft Excel and QGIS in an elegant way
I've been working with an Microsoft Excel Spreadsheet where the rows are different investments and the columns are different variables/criteria (a column could for example be the year of the ...
1
vote
0answers
156 views
Survey123 Connect geolocate from a text field using online survey
From the web survey, is it possible to put a point on the map from typing in your address? As it stands, when I type my address a drop down from the search bar in the map appears. But, the map doesn't ...
0
votes
1answer
53 views
QGIS: relation to Excel exported files (updates)
Layers exported from QGIS as Excel format are the topic here.
I see when I edit this files in Excel(exported from QGIS) are simultaneously edited in equivalent file (non-spatial table) which was ...
1
vote
0answers
63 views
Create PostgreSQL ODBC Excel table
I want to allow a non-GIS user edit a CSV file which is hosted on QGIS Cloud on a PostGIS database. My method is to load the table from the QGIS Cloud database into Excel via ODBC.
Here are my steps ...
0
votes
0answers
46 views
How to solve Error 000840 from arcpy.JoinField_management?
As part of a larger Python script, I am attempting for my last step to join an Excel file to a spatial layer. I was able to perform this step just fine in ArcGIS Pro Model Builder, but when I attempt ...
2
votes
0answers
56 views
Copy/pasting from QGIS to Excel
I want to copy and paste (or export) data from a query (or attribute table) into excel.
I've tried copying and pasting direct from a query results (in DB Manager) or loaded the query result as a layer,...
0
votes
3answers
86 views
Changing Excel point coordinates in different coordinate system to points in ArcGIS Desktop
I have coordinates in a format e.g. 22°42'39.065”E, 49°4'59.864”N. I tried to add the points using "XY Table to Point" but when I add my Excel file as input, it doesn't recognize the fields ...
1
vote
0answers
25 views
Adding spreadsheet information to KML
I have a KML from Indy Neighborhoods ArcGIS. I have the results of a factor analysis based on neighborhood traits from savi.org. From this, I did a clustering. I would like to combine the contents of ...
1
vote
0answers
53 views
AGOL “Update Data” from Excel import numeric columns with some NULL rows?
I need to append some new features into an ArcGIS Online hosted feature layer. The data has been supplied to me in an Excel file (including X/Y columns). I was intending to import it as-is using the ...
1
vote
2answers
62 views
Connecting column from Excel table with attribute table in QGIS
Is it possible to connect an Excel table or column from an Excel table with an attribute table in QGIS?
0
votes
1answer
103 views
Survey123 not exporting Headers/Labels/Text
I have been having this issue all day and I have tried every work around I can think of.
I am creating a form for technicians to use in the field to avoid using a field notebook.
For this site, we ...
1
vote
0answers
111 views
Why Table to Excel tool does not work properly in ArcGIS Pro? [closed]
I have been using a Python/ArcPy code use to generate many Excel files (.xlsx) from shapefiles. After the last Pro update end users start complaining that they get message when they try to open those ...
1
vote
2answers
34 views
Converting xls into csv in QGIS with correct column definitions and exporting the data into postgis
I'm using QGIS 3.10.2 A Coruna.
After reading this tutorial (https://ieqgis.wordpress.com/2015/02/08/importing-csv-files-into-postgresql-using-the-db-manager-in-qgis/) I thought I had finally found a ...
2
votes
1answer
91 views
QGIS crashing when exporting data into Excel Spreadsheet with PyQGIS
I am extracting raster data using GDAL from a map that has different shades of red depending on the temperature. When I run the code within QGIS only the beginning and end of the code shows up. This ...
0
votes
2answers
327 views
Importing DBF files into Microsoft Excel [closed]
I'm working through the book "GIS Tutorial 1" and it wants me to open up a DBF file in Microsoft Excel. But when I try to open it, I'm running into some issues. First thing that seems weird ...
0
votes
0answers
50 views
Adding multiple Excel files and display XY data using ModelBuilder
I would like to use ModelBuilder to add multiple Excel files and display the XY data as a shapefile and eventually convert the point data to raster. I am using ArcGIS Desktop 10.4. I have tried the &...
3
votes
2answers
132 views
Select JSON records as an Excel table
I have an internal map service that serves up GIS records via JSON objects.
For the purpose of this question, instead of using my internal/private
data, we can use the JSON data on ESRI's public ...
3
votes
1answer
70 views
Force ArcMap to release unused Excel file
This is not a scripting issue or even a lock file issue.
I have an Excel file with one sheet.
I drag that one sheet into the ToC of ArcMap.
I look at the table.
I remove the sheet from the project.
...
1
vote
0answers
21 views
List of features and layers based on edit date in ArcMap
I regularly update our GIS data using ArcMap to improve its accuracy, and due to our schema this involves editing multiple features across multiple layers.
Is there a way to extract a list of the ...
1
vote
2answers
79 views
Extracting point coordinates from QGIS into Excel using Python [closed]
I was formerly working on ArcGIS but now I'm working on QGIS 2.14.7 and Python 3.8 so I'm a bit confused with the QGIS script.
I have to extract coordinate of point layer (CRS:Lambert 93 and WGS84) ...
4
votes
0answers
71 views
Filtering in QGIS similar to dropdown in Excel
I have a large amount of point data that has so far been managed in an Excel list. In the future, these should be shown in QGIS.
To convince colleagues of this, I am looking for a way to make ...
0
votes
1answer
146 views
What address locator to use for geocoding addresses in Excel?
I've been struggling to geocode the following addresses from an Excel table both in ArcMap and ArcPro:
As you can imagine, I'm trying to geocode the addresses in the "StreetAddress" field.
...
0
votes
0answers
10 views
Gap Minder data in ArcGIS Pro
I am trying to use data from GapMinder. I have downloaded the Excel spreadsheet data for CO2 emissions and for global GDP. I have uploaded the file to my folder connection in ArcGIS Pro, and dragged ...
2
votes
1answer
72 views
How to automate flooded area calculation and make report using PyQgis?
I have 3 shapefiles with me. They are a flooded layer, District layer and Village layer. To estimate flooding village wise, I have to do intersecting the features and get the layer. Then I calculate ...
0
votes
2answers
23 views
Need to assemble a matrix from several ASCII GRD files
I am totally new to GIS software.
I would like to consolidate 205 ASCII GRDs files (the file format of Golden Software's "Surfer") into a single big GRD file or just a big matrix of (about 2400 rows ...
1
vote
1answer
116 views
My dataset lists state and county FIPS codes separately. How should I combine?
I can't do a simple "concatenate" because the codes don't have leading zeroes. Are there any available APIs that I can use to geocode this data given the format? Or do I have to manipulate them so ...
0
votes
1answer
52 views
Export only selected and reordered columns to Excel
I am using QGIS 3.12. I want to export my attribute table to an exciting EXCEL table but I want to arrange the columns in a different order and also to select which columns to export and which not. Is ...
1
vote
1answer
2k views
Google API Geocoding in MS Excel for free
I am seeking a solution enabling me to do address geocoding in Excel using the Google Maps Geocode API.
Basically, the task is possible via Google Sheets, like has been discussed at
How to Geocode a ...
0
votes
1answer
25 views
Copy data attribute into QGIS layer (not external link)
I need to copy data from an external file .xls to a layer.
I have to share a project with only shape file (no .xls).
Now the layer has normal data attribute with join
I do not understand that ...
0
votes
0answers
47 views
Importing Line Shapefiles in Excel 3D Maps?
I have managed to use the 3D Maps feature from Excel to visualise points at certain Lat Long coordinates from a data range.
I have successfully managed to import complexe polygons via shape files.
...
2
votes
2answers
58 views
Adding to attribute tables
I have a question about adding data to attribute tables. I uploaded an Excel file into ArcMap (File -> Add data -> Add XY data). I chose the table from Excel that had the orientation data's latitude, ...
2
votes
1answer
24 views
Statistical method to quantify the accuracy of point clusters
I have coordinates of about 13 points from different pictures in UTM. Per point I can have 2, 3, 4 or 5 coordinates of these points from 2, 3, 4 or 5 pictures. I would like to quantify the quality of ...
1
vote
0answers
53 views
Converting QGIS expression into Excel function
In QGIS I use this expression to build a "ID" from fields:
rpad(concat("abt", coalesce("u_abt",'X'),"beeinh"),5,'0') || '-Z01'
I need to translate this expression into a Excel or Calc function. How ...
