Geographic Information Systems

Questions tagged [excel]

Ask Question

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

482 questions
Newest
Active
Bounties
0
Unanswered
Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

Populating excel sheet with numerical output of Get Count using ModelBuilder?

Working on ArcGIS desktop 10.7 (very much still learning). I'm trying to create a model that will count objects from several layers based on the setting of a specific category, then from that ...
0
votes
0answers
37 views

Adding Polygon to shapefile of particular area from Excel?

I have Excel data in which polygon number is given, in correspondence to that there is particular Area given. I have 5000 to these entries. Now in the shape file, we have to edit every polygon and add ...
1
vote
0answers
19 views

Write Excel From ArcGIS Pro, Async

I am having trouble writing to an excel file from ArcGIS Pro Sdk add-in that I created, I have a basic understanding of multithread, I am using task but the main thread does not wait for the excel to ...
1
vote
1answer
22 views

Add Field disabled on Excel file in ArcMap?

I am a new user to ArcGIS Desktop 10.7. I imported data table from Excel 97-2003 format in the Table of Content. Then with XY recognition the layer was created with the defined coordinate system. The ...
2
votes
1answer
44 views

Converting Lat Long CSV file to meters using ArcGIS Desktop?

I have a large file in a CSV or excel format and want to convert the Lat longs into Northings and Eastings in order to then put them into ArcGIS Desktop and convert those Northings and Eastings into a ...
1
vote
1answer
43 views

Update shapefile with values from Excel cell in QGIS [closed]

I have an Excel table with unique Id values. 1 2 3 4 What I want to achieve is when editing a point shapefile with the same Id field every time a new point is created the Id field is filled by the ...
2
votes
1answer
77 views

Iterating over column from CSV using pandas? [closed]

The problem that I am experiencing is as following: I have a csv with the following columns: 'time' (with date and time), 'id', 'lat', and 'long'. The data shows movements and id represents a mobile ...
0
votes
0answers
36 views

Retaining co-ordinate values with 6 significant figures when converting shapefile into Excel spreadsheet?

Using ArcGIS-desktop, I converted a shapefile, into an Excel table through the conversion tool Table to Excel, however my co-ordinates previously were specific to the 1x10-6 (i.e. 9.078627) but in the ...
1
vote
0answers
32 views

QGIS 3.6 - Updating layers from changing excel spreadsheet

I am building/editing a table and utilising Excel as the vehicle. When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers. Handling Excel spreadsheet ...
0
votes
0answers
9 views

Extract data table with extended description from Google MyMaps

I would like to extract data table from Google MyMaps and make it usable i.e in Excel. The issue is straightforward at first glance. I know, that I must download the map in .kml and convert it, as per ...
1
vote
1answer
42 views

Importing long text from Excel using ArcGIS Desktop always shows up as BLOB?

ArcGIS Desktop 10.6.1 I am trying to load long text (>255 characters) into my GIS data. The destination field (let's call it "Field Alpha") is a string field with a length of 2000 characters, in a ...
2
votes
2answers
48 views

Opening different XLS spreadsheets as table with ArcPy?

I am trying to write a Python script that uses a xls file with different spreadsheets as input to build features and domains in a geodatabase. This is the data in Sheet1: and this the data in ...
1
vote
2answers
79 views

DBMS error when importing XLSX into ArcGIS PRO

I am working with an XLSX, and consistently receiving either a "underlying DBMS error", or associated with the file. I have worked through all the suggestions and limitations from ESRI to the best ...
1
vote
2answers
48 views

Decimals are in wrong place in latitude and longitude in Excel

Somebody gave me an Excel table and the latitude and longitude had the wrong place for decimals. Is there a workaround to fix the problem? I am pretty much stuck trying to figure it out. Here is the ...
0
votes
1answer
24 views

Viewing File Geodatabase table in Excel with link not export?

I have a situation where I need to create a regular report from information in a file GDB (10.6) attribute table. I would like to avoid exporting the info to CSV each time I run the report, then ...
1
vote
1answer
31 views

Copying first record from series of feature classes into separate file using ArcPy? [closed]

I have 1000 files from which I need to copy the first record and insert into a new feature class. Additionally, is there a way to do this without copying the Field headers as well? The end result ...
0
votes
1answer
16 views

Blank Excel fields creating problem in Creating TableView using ArcPy? [closed]

I was about to take input from an excel and using conversion tool in arcpy I have to convert the excel to table in a gdb. But when I used this Excel to table tool, I found that there are columns named ...
0
votes
0answers
19 views

Pasting Column into QGIS from Excel? [duplicate]

This should be incredibly simple, but I cannot figure it out. Is there any way to paste a column from excel into an existing column in a QGIS attribute table?
1
vote
0answers
23 views

Interpolating sea level data using ArcGIS Desktop?

I have monthly sea level data obtained from PSMSL in the form of excel sheet for the region Chennai. I want to interpolate the data in ArcGIS Desktop. The shapefile of the region has Polygons and I ...
0
votes
0answers
113 views

Editing and saving CSV file to use in plugin for QGIS?

For using in a plugin (PS Time Series Viewer), I want to edit a CSV file in the way plugin wants. Somehow I think there's a problem with the CSV file. I would like to tell you all my steps because I ...
2
votes
2answers
41 views

Automatically (re)classify data from layer using QGIS?

Is it possible to automatically (re)classify the data of a layer? (properties-symbology-delete all-classify) Because now I have to do this manually each time my data source changes.
3
votes
0answers
107 views

Automatically update and reclassify project layer from Excel data

I have a project in Qgis that gets its data from a locally stored excel file (linked). Is there a way to automatically update the linked data? What is happening now is that when I change some rows in ...
0
votes
0answers
28 views

Feature layer (AGOL) export to Excel failure?

When I try to export data from an AGOL feature layer into an xlsx i receive the following error. "Excel cannot open the file, file format or extension is not valid" When selecting to export you don'...
0
votes
0answers
30 views

Multiplying individual raster layers by corresponding values in Excel file?

I have two groups of items I want to multiply, using the Times tool. I have a geodatabase full of density raster layers. I also have an excel sheet. This excel sheet has a column listing the names ...
0
votes
1answer
50 views

Using ModelBuilder to Create Python Script for xls to csv Conversion?

I am currently trying to create a python script within ModelBuilder to convert an xls file to csv. I created one already using the "Table to CSV" tool which was successful. However, I tried to add ...
4
votes
1answer
155 views

ArcGIS Desktop not recognizing updates to xlsx?

I load an xlsx file into ArcGIS Dektop 10.6.1, and realize I didn't have headers in my xlsx so I need to go back and add those. I close everything since ArcGIS locks xlsx files down and won't allow ...
1
vote
1answer
72 views

Making relationship class between feature class and Excel table with ArcGIS Desktop?

I have a feature class of parcels and an Excel table of other information related to those parcels. Goal: would like edits from an Excel table to get passed onto feature class. Problem: for a true ...
0
votes
0answers
34 views

Finding address with coordinates? [duplicate]

I have an excel spreadsheet that contains a column with the name of some businesses and the next column with the geographical coordinates of these businesses. Is there a way to automatically find the ...
0
votes
0answers
159 views

Warning Could not add the specified data object to the map

When I try to add data (Excel spreadsheet) from the Catalog I get the warning message noted above. Previously I have been able to add data from Excel files.
0
votes
0answers
29 views

Importing Excel file into ArcGIS

I am importing Excel sheets into ArcGIS for map-making purposes. I have one column that is not recognized. I cannot figure out what is wrong with it, I have deleted it and remade it, checked the ...
1
vote
0answers
39 views

Empty error when running Table to Excel tool [closed]

The Table to Excel tool in the Conversion toolbox does not work for some reason. When I open it, it shows a red cross in the top left corner. When I try to run it an error pops up that says nothing. I'...
0
votes
0answers
29 views

How to collate data and access collated list - Survey 123

https://communityhub.esriuk.com/geoxchange/2017/11/17/how-to-work-with-other-in-survey123 The above link is the resource I used to collate my data. I did nearly exactly what the webpage above ...
1
vote
0answers
48 views

QGIS automation field from Excel

I present the following situation. 1 - Draw polygon shape in QGIS 3.4 / geopackage, only with two columns ID and NUM_SETOR, using the google maps image as reference. 2 - Excel table where I combine ...
2
votes
0answers
28 views

Copying Table of Contents from QGIS into Excel?

Is there a way to copy and paste the contents of the Table of Contents in QGIS into an Excel spreadsheet? For example, I have many layers (groups of vector shapefiles which are underneath various '...
0
votes
0answers
227 views

Creating geodatabase table from pandas data frame?

I have a .xlsm file which I use to update an existing point feature class, with the information from a certain sheet. The data from the sheet has to be projected in GIS using Route events, and later, ...
1
vote
0answers
32 views

QGIS hyperlink to specific row/column excel

Is there a way to set a hyperlink to a specific sheet/row/column in an excel document? I am able to link to an excel file on the server and open it from QGIS, but would like to open the document to a ...
0
votes
1answer
67 views

Formulation of CRS (EPSG2438 to EPSG4326) conversion in Excel

I have about 14000 points with coordinates EPSG2438 and want to convert the coordinates into WGS84 (EPSG4326). I want to know that is there a way to make Excel formula to convert these coordinates. In ...
0
votes
1answer
59 views

Zeros disapearing in front of numbers when exporting from attribute table

I have a large set of points in ArcMap desktop. In the attribute table I have a column called ID, where each point have an individual number. Some of these numbers starts with a double-zero, which is ...
1
vote
0answers
36 views

Interpolate and export the following points

I have two crossections of the same position. I am looking for a way to interpolate the blue points from the attached image. I need the xyz values of the interpolated points, how can I do this? I ...
5
votes
4answers
163 views

Converting Excel into shapefile (keeping encoding and data type)

I am trying to create a "perfect" shapefile from the Excel data. "Perfect" means that it should match several factors: proper encoding and original data type. Excel file basically contains ...
1
vote
0answers
125 views

Filter on joined tables in QGIS

QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs. I would like to filter the shapefile while using a joined field from the Excel table. When I ...
1
vote
1answer
40 views

Using ArcPy with Windows Task Scheduler script cannot read Excel file?

I have an arcpy Python script that downloads an Excel spreadsheet and then copies one of the sheets from the document to a table in a geodatabase. I need this script to run automatically every night, ...
3
votes
2answers
98 views

FME geometry conversion from string?

I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the ...
1
vote
1answer
91 views

Excel to GDB field mapping and importing Excel data in geodatabase?

I've got one Excel file which consists of data. I need to export that data to a gdb table. There are challenges. The gdb schema does not match with the Excel schema (I mean column names are different ...
0
votes
3answers
86 views

Filtering attributes in a shapefile using a common ID from an Excel file

I am using QGIS 2.18.11 and I have a shape layer with lines and polylines I need to review; but not all of them, only certain ones. The ones I need to review are marked in a specific field (rev = 0 or ...
3
votes
1answer
44 views

Separating list with coordinates in two different coordinate systems using ArcMap?

I have an excel list with approximately 10.000 poles which I want to export to a Point layer to view in ArcMap. However, the coordinates are a mix between SWEREF99 and RT90 and I am not sure how to ...
0
votes
1answer
282 views

Exporting into Excel file from PyQGIS?

The following code allows me to save a text file with .xls extension in Python. When I open it, I receive the following warning: The file you are trying to open, is in a different format than ...
1
vote
1answer
28 views

Assigning value to building type using ArcMap? [duplicate]

I have a building dataset that shows areas of different building types ie. educational, medical, and residential. How do I assign each type of building a numerical value so if I have 7 buildings ...
1
vote
0answers
56 views

Exporting several maps with excel sheet using Arcpy

I try to export 20 maps with this python code in ArcGIS 10.3.1 for Desktop. Each map has excel sheet (not attribute table) in the layout view. The excel sheet file located in G:\Users\test\Downloads ...
0
votes
1answer
275 views

Error message while trying to load spreadsheet: Failed to connect to database. Class not registered

I am trying to load an Excel spreadsheet into ArcMap 10.6 in Windows 10. But it will not load and this is the error message:

1 2 3 4 5 … 10