Geographic Information Systems

Questions tagged [excel]

Ask Question

Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

541 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
0answers
22 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
68 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
46 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 ...
0
votes
0answers
27 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
39 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
28 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
37 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
53 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
38 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
33 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
44 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
44 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
64 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
32 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
71 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
54 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
34 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
80 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
60 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
19 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
65 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
63 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
86 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
62 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
72 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
48 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
608 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
17 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
51 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
52 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
49 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
166 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
29 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
72 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
198 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
61 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
79 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
66 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
53 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
72 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
39 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
46 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
41 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
77 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 ...

1
2 3 4 5
…
11