Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
534
questions
0
votes
3answers
29 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
24 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
23 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 ...
0
votes
2answers
40 views
How to connect a column from a Excel table with a attribute table?
Is it possible to connect a Excel table or column from an Excel table with a attribute table in QGIS?
0
votes
1answer
24 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
55 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
29 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
64 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
37 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
23 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 &...
1
vote
2answers
38 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
45 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
18 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
63 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
57 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 ...
1
vote
1answer
61 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 ...
1
vote
1answer
58 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
21 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
43 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
47 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
166 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
12 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
49 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
23 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
50 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 ...
2
votes
0answers
39 views
Column headers ignored when importing .xlsx file to postgres via QGIS DB Manager
I'm importing Excel (.xlsx) files to postgres using the QGIS DB Manager "Import Layer/File..." tool. I've already successfully uploaded very similar Excel files without issue, but for one file in ...
1
vote
1answer
22 views
How to export ArcMap model parameters to an Excel file?
I have a model where the user inserts different model parameters like "Name", "Elevation", "Threshold A", "Threshold B" and so on. Based on this, features get selected, saved to .xls files where they ...
1
vote
1answer
137 views
Import xls / xlsx / ods: field names are not in first row (just QGIS!)
I need to import a xls / xlsx / ods into QGIS. But while the first row (field names) of my XLSX in LibreOffice shows up on the first place as it should, QGIS shows the first row on place 452! As you ...
0
votes
0answers
27 views
Table not aligning with layer objects
I am new to GIS.
I am using Mapinfo V17.0.2
I am creating a cemetery plot. I have created many rows of polygons to shape the desired areas for burials.
My table looks a little like this;
ID | Lot | ...
1
vote
1answer
71 views
Polygons dissapear when upload as CSV
I'm working with QGIS 3.8 and I'm facing an error that I don't know how to fix.
I have download shapefile of all the countries in the world. When I display it on QGIS it has no problem at all:
I ...
0
votes
0answers
135 views
ArcGIS Pro Microsoft Access Database Engine driver not found even though its installed
I'm simply trying to add an excel file via "Add Data" to a map but receive the following error, "Required Microsoft driver is not installed". I went ahead and followed the directions via this link
...
2
votes
1answer
56 views
Export virtual fields in attribute table to Excel using QGIS
I am using QGIS.
I am trying to export my attribute table to Excel but I want the virtual fields also to be exported with their function. For example I have a field that sums up two other fields and ...
3
votes
2answers
61 views
Exporting selection to Excel file using ArcMap
I selected a list of facilities that intersect a polygon using ArcMap, and I want to export them to Excel.
Is there a way to do this without having to export the selection to a shapefile first?
0
votes
1answer
65 views
Plotting points using a list of lat & long coordinates
I have been given a list of latitude and longitude coordinates in a .csv file and asked to plot them on a map. There are multiple other columns of data about each point included in the excel file.
I'...
0
votes
1answer
51 views
Display XY coordinates (with different lengths) in ArcGIS does not work
I have a list of Excel lat long coordinates in a spreadsheet that I want to import as points in ArcMap by displaying the XY Data.
lat lon
5235746 486124
5236799 487447
5238042 489453
...
0
votes
0answers
62 views
Export a very large attribute table (1,5 M rows) into Excel spreadsheet QGIS
I have a very large shapefile containing rainfall data for South Africa. Each point is a single rainfall that lasted for 1 hour. I have 1,5 million points. For further analysis, I need to export it ...
0
votes
1answer
32 views
Summarizing individual data in table using ArcGIS Pro
I am attempting to summarize a a bunch of individual rows in a table I added into ArcGIS Pro, and I'm wondering if there is any type of tool or work flow I could use to do so?
This is kind of a ...
0
votes
0answers
41 views
Converting string fields to double using ArcGIS Pro
I have an Excel table converted to GIS type table. And there is few columns (text string), which I need to make double in order to join it with other table. There's blank fields, but there's nothing I ...
0
votes
1answer
34 views
Attribute table empty on a layer filled with data
I have inserted some data from an .xls file and marked it on a map in ArcMap on a layer named "Kafichi"
However when I right click on the layer and click on "Open Attribute Table" it gives me an ...
1
vote
1answer
65 views
Using raster file and Excel data for analysis QGIS
I'm using the population density raster from SEDAC (person/square km), I've clipped it to my area of interest (Vietnam) as shown in the picture below:
In addition to this, I have a vector layer of ...
2
votes
3answers
106 views
Importing Excel of multiple sheets into QGIS
I have an excel document of multiple separate sheets.
I can import them one at a time by saving the individual sheets as CSV’s but is there away to bring the entire document into QGIS?
The ...
0
votes
0answers
49 views
Connect coordinates only according to specifications in an Excel list
I have an Excel list with coordinates of shops and their names. I want to connect certain coordinates with the help of a second list.
The second list contains in the first row and column the names of ...
-1
votes
2answers
92 views
Excel XY to (Multi) Polygons
I'm struggling with visualizing a Excel dataset. I have a Excel data table containing a colum with XY coordinates of (multi)polygons, see the screenshot below. Now, I know that it is possible to ...
0
votes
0answers
40 views
Scatterplotting of LST and NDVI
I have created two Raster files (LST and NDVI) I want to determine the slope and intercept of the dry edges and wet edges of the scatter plots of the two datasets to calculate soil moisture, but I don'...
0
votes
0answers
12 views
Symbolizing layer with graduated colors by a field in Excel File
I have a field in Excel file called percentage, I want the governorates colored by the percentage value, so the more value is the more red become darker in the governorate.
So how can I do it in ...
0
votes
0answers
41 views
Can't display XY data in MXD on ArcGIS Desktop- onEnable error
When using Display XY data function on imported excel into MXD I get this error:
and if I click on "ok" then I get this message:
and the MXD get stuck and I must shut down the ArcGIS program. I know ...
1
vote
1answer
93 views
Excel to Table Conversion on multiple Excel files in folder using ArcPy gives ERROR 000814
I am trying to convert all of xls files (including single sheet) a folder into dbf tables in a gdb.
Here is my code:
import arcpy, os, xlrd
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:...
1
vote
2answers
103 views
Mapping RBG color to coordinate possible?
I work with geologists who are trying to figure out how to use Qgis to batch apply colour values to coordinates so that we can visually see differences or patterns.
From the attached photo of soil ...
