Excel is a spreadsheet application. It features calculation, graphing tools, pivot tables.

learn more… | top users | synonyms (1)

0
votes
0answers
18 views

Is it possible to insert Excel table with filter in ArcMap layout view?

Please see the image (https://apps.health.ny.gov/statistics/environmental/public_health_tracking/tracker/mapaction.map?activeTool=showIndicator&indicator=asthma). There are "Map display" and ...
0
votes
0answers
9 views

Can I put a button that automatically inputs GPS coordinates into a google form? (or other spreadsheet populator)

I am currently creating a Google Form and part of the questionnaire requires the user's current GPS location. Is it possible for a button to be able to do this and automatically populate the field? Or ...
1
vote
0answers
36 views

Maintaining same number of digits in Excel file when converting to table in ArcGIS for Desktop?

I have two fields containing lat and long values which are precise up to 8 digits. When I use the excel to table tool, Arc removes the last two digits in both fields leaving me with lat and long ...
0
votes
1answer
11 views

My exported data does not align in the correct projection? [on hold]

I have excel tables the data is from a website that I need to add and update to my SDE database. The header of the excel tables have Work Order number, date, zip, department and address. The problem ...
1
vote
0answers
26 views

How to match UTM squares between Excel and Shapefile?

I have an excel file with locations displayed in UTM 10kmx10km squares. I also have a shapefile with those same UTM squares and their coordinates, however I cannot seem to figure how to project the ...
0
votes
0answers
61 views

Add grid reference from excel to arcmap 10.1

I am trying to upload an excel sheet for my grid reference to arcmap 10.1 but arccatalog/arcmap can't find the file. The excel version is 2007 and I have the driver installed. Does anyone know why ...
2
votes
1answer
28 views

How to import gdb file data into an Excel sheet

How can I extract the data from a gdb file into an Excel worksheet? Is this possible at all?
1
vote
0answers
26 views

Pivot Table not displaying in ArcGIS?

When I performed my pivot table in MS Excel and then made a chart of it and I am trying to copy and paste it to ArcGIS and it is not displaying at all... Is there a work around to do this ?
2
votes
1answer
45 views

Create a dynamic excel sheet linked to a shapefile's attributes

I am trying to create an excel sheet that is updated automatically when the features of a shapefile are updated. I know the shapefile's .dbf file is updated but I need the excel sheet to be formatted ...
1
vote
1answer
86 views

Qgis corrupted excel file, possibility to repair?

I had an excel file with several data which I imported into Qgis as a layer. For some reasons I had to change the data type of one coloum so I created a new one and imported data from the first ...
0
votes
1answer
44 views

ArcGIS 10.2 Changing 'null' to 'zero' in attribute table? [duplicate]

I have a table (Excel, csv) with county names and three additional column headings. I would like to ensure that everything under the three additional headings have a zero rather than a 'null' value. ...
1
vote
1answer
51 views

header row in excel is not header row when imported into ArcMap

I am importing an Excel table with X/Y coordinates to plot on a map (point data). The original Excel table has a header row as its top row..The row is 'frozen' in Excel. When I import the table and ...
3
votes
2answers
72 views

Import Google Maps locations to ArcMap

I have a problem with importing a list of coordinates to ArcMap. I have a shape file of regions of Chile and I would like to add a list of locations with coordinates I got from Google Maps. The shape ...
2
votes
1answer
58 views

How to format an excel table using python

I am trying to come up with a way to export an attribute table as a formatted excel table in ArcMap 10.2. I am aware that there is a "table to excel tool" in the conversion toolbox, but I am not sure ...
1
vote
0answers
55 views

Attributes in Excel and FME

I have a excel and a shapefile.I want to check whether the attributes present in the excel matches the one in the shapefile using FME
0
votes
0answers
6 views

add points when joining two datasets together in ArcGIS

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
0
votes
0answers
19 views

Cannot display x,y data [duplicate]

I have trouble to display x,y data in UTM coordinates from xls file. It just shows on table of content and do not appear on working screen in Arcmap 10.1. When I check the map scale it different with ...
5
votes
1answer
131 views

Symbolizing using RGB values from Excel in ArcGIS for Desktop?

I have an excel file with 2 attribute columns, 1-feature info 2-Number of color (RGB) that the current feature should be symbolize. This file file can be joined with the layer using the "feature info" ...
1
vote
1answer
38 views

How to remove spaces in only the top row in excel?

I want to clean up some data that's having trouble importing into Arc. I want to know a way to clear spaces in only the top row in excel. Sometimes there is one hidden before or after the row name ...
1
vote
2answers
26 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
0
votes
0answers
6 views

Adding photos to CartoDB data points [duplicate]

Is there an easy way to display photos, along with the other info that can be displayed, when data points are clicked on in CartoDB?
2
votes
1answer
97 views

How can I display multiple multi-attribute labels for polygons

I am using ArcGIS for Desktop 10.2. I trying to import and display project data for various regions. Each project is tied to a location and I want to display Project Type, Funding Source, and a dollar ...
3
votes
1answer
78 views

Excel sheet in Layout View

We frequently have to update excel sheets that contain reports as number, images, and pie charts and import it in our data view in ArcMap (sometimes 13 times a day). We do it by copying the row/column ...
1
vote
3answers
165 views

latitude and longitude coordinates into postal code with town names

Here is my problem. I have a csv file, with latitude and longitude coordinates. I would need to know the name of the French towns and the relevant postal codes that match these coordinates. My ...
1
vote
3answers
172 views

Excel (*.xls) imported into File Geodatabase is missing records?

Long time reader first time poster :D Err I am having a few issues with a join to a File GDB from xls I imported as a table to the the FGDB. The problem being records that are in the original ...
1
vote
0answers
40 views

Excel Table Objects get invisible and lose data after re-opening map

I had a case when I had to Insert many Excel tables in the Map Layout and it worked perfectly, exported perfectly, etc. But when I saved it, closed the map and came back to it later ALL Excel tables ...
3
votes
1answer
76 views

Does ArcGIS Pro join to excel worksheets like ArcMap does?

I love the idea of ArcGIS Pro, especially for non-GIS analysts to get one-off maps done easily and quickly. The big question is: Does ArcGIS Pro join to excel worksheets like ArcMap does?
1
vote
3answers
100 views

Export selected fields in ArcGIS to Excel using Python

I'm am creating a script that will allow a user to add XY coordinates to a point layer, then export (along with any addition user selected fields) to Excel. I am getting stuck on the iteration of the ...
2
votes
5answers
361 views

Unable to export data to ShapeFile in ArcGIS

I've imported an Excel sheet into my ArcGIS project but am unable to convert this to a ShapeFile. When I try, via export data, I get an error message saying either 'output name is not valid', whatever ...
1
vote
0answers
28 views

Anysite - Export Spreadsheet of Multiple Demographic Points

I have a point file of every single intersection in my city. I'd like to be able to run demographics on EVERY SINGLE POINT and have the demographic data for intersection go into a single master ...
1
vote
2answers
110 views

Creating Shapefile from Excel Data

I have an Excel file with three columns, IncidentID, Latitude, and Longitude. Each row in the file corresponds to an incident and the location of the incident in units of decimal degrees. I also ...
2
votes
0answers
264 views

How to calculate grid convergence (True North to Grid North)?

I would like to know how to calculate the grid convergence angle between True North and Grid North for UTM maps. I am using ArcGIS 10.0 (ArcView licence) and have used the Calculate Grid ...
3
votes
2answers
136 views

How to map tabular data based on city/province name?

I am very new to GIS and ArcGIS so would appreciate any advice/help. I have an Excel file containing data on cities (only names) and provinces (of those cities) for 158 countries around the world. ...
1
vote
1answer
61 views

ArcGIS 10.2 arcpy — how to import/install win32com?

win32com used to be included with arcpy 9.x but no longer. I used to use it to manipulate excel occasionally. I downloaded and let win32com install itself and then tried to follow some online ...
3
votes
3answers
176 views

Can a shapefile, or other file, be made from Excel without coordinates

I have two Excel spreadsheets I'd like to make into shapefiles, or some equivalent. I have access to ArcGIS at work and want to try using GRASS as well. I have seen the help on doing so, but only if I ...
1
vote
1answer
38 views

Error 001156. increasing the length of text limit [duplicate]

I'm fairly new to ArcGIS for Desktop and i want to import my excel table to my personal gdb but i end up getting an error code:001156 and my import fails. I soon found out that it was the lengthy ...
0
votes
1answer
43 views

Data refusing to line up with basemap after re-setting source for data

I've only been using GIS for a couple of months so this is probably just a really n00b problem but I cannot for the life of me fix it. The other day I managed, with a lot of finagling, to create a ...
2
votes
0answers
83 views

Calculating Distances between coordinates

I have perused through the other questions that are very similar to mine but am still having some trouble. I have 75 coordinates in WGS84 that I brought in from an Excel table. They are now on my ...
0
votes
2answers
98 views

How to update Geodatabase point file table from Excel data using FME

I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data ...
0
votes
1answer
50 views

Table to dBase tool failure when converting .xls files

Whenever I load my Excel 2010 worksheets into ArcMap 10 Table to dBASE tool, it fails, returning the error: "Failed to Copy Rows" The Copy Rows tool works just fine for me on a single document. There ...
0
votes
0answers
103 views

Arcpy Table To Table Conversion Error

I am running a script that uses an excel spreadsheet to define and output maps, kinda like my own data driven pages set up. The only input into the tool is the path of the spreadsheet. When I run ...
1
vote
0answers
76 views

Adding information from excel into ArcGIS [closed]

I am working in ArcGIS and have a excel sheet with data pertaining to properties. I want to add this data to a map in ArcGIS of which i have property boundaries as a shapefile? I have a common folio ...
4
votes
1answer
295 views

Draw lines between two points in QGIS

I have an excel (Fig) which has both X & Y in projected coordinates (WGS84/UTM). Is it possible to draw lines between the X & Y in QGIS ? I've tried to create points based on X,From_y and ...
1
vote
1answer
53 views

One to Many relation in ArcGIS for Desktop?

I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building. The attribute table for the building has these columns: id,label,number. I ...
1
vote
1answer
86 views

Is there a way to have a choropleth map in Excel reading data from a sheet?

Is it possible to have a solution similar to ESRI maps for office in which I want basically a geojson file or any file for that matters to render a choropleth map based on data in a sheet? Tried ...
0
votes
0answers
74 views

calculating decimal degrees from coordinates found in an excel table

What is the exact syntax to use when calculating decimal degrees in the field calculator? I know the general formula {i.e. Degree + (minute/60) + (second/3600)} but how do I put this into the gis? I ...
2
votes
1answer
33 views

Atributing fields in arcmap and excel

How do I populate a field in ArcMap (and Excel) with only a specific part of another field's attributes? For example: I want to populate the LATDEG field with only the degree part of a latitudinal ...
1
vote
2answers
97 views

Cannot convert dms to dd in Excel 2007 using VBA code

I am trying to convert the data in an Excel sheet from dms (degree-minute-second) to dd (decimal degree) format using the vba script available here. Here is sample data: 53° 0' 39.31" 6° 44' ...
2
votes
1answer
61 views

Table to Excel Arcpy Error

I am trying to export a point shapefile to an Excel sheet using the arcpy.TableToExcel_conversion(FinalClipOutput, ExcelOut, "", "") The "FinalClipOutput" is the result of a clip that happens ...
2
votes
1answer
85 views

Can I batch import attribute tables into existing excel spreadsheets

I am using arcGIS 10.2 and I need to import the attribute tables of 100 layers into existing excel spreadsheets which will make graphs based on the values in the attribute tables. Doing this ...