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

learn more… | top users | synonyms (1)

1
vote
1answer
38 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
56 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
50 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
45 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
4 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
97 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
35 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
23 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
5 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
79 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
59 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
89 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
95 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
35 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
59 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
60 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
236 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
26 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
57 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
121 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
129 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
44 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
155 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
19 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
39 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
71 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
78 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
43 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
76 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
73 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 ...
3
votes
1answer
198 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
44 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
71 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
66 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
76 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
57 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 ...
1
vote
1answer
76 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 ...
1
vote
2answers
79 views

Changing field type of Excel attribute table for a Join

I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field ...
-1
votes
2answers
58 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
1
vote
0answers
67 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
0
votes
1answer
31 views

GDAL: Update spreadsheet from polygons in a shapefile

I am a beginner with GIS data, and have been looking for an answer but have not yet found it. I have a spreadsheet with lat/long points. I also have a shapefile with several numbered polygons over a ...
2
votes
0answers
58 views

Editing the QGIS Attribute Table

Is there a way to edit the name, type and length given to each column on the attribute table once the information has been imported from Excel?
2
votes
1answer
74 views

Randomly choosing one from multiple fields in Field Calculator of ArcGIS for Desktop?

Using the Field Calculator in ArcGIS for Desktop, I want to randomly choose one field from a list of 10 fields (strings). The Excel equivalent, which is working, is: =INDEX(A2:J2;rnd()*10+1). How ...
-2
votes
1answer
313 views

Creating a python script to import an excel spreadsheet, create shapefile and do some analysis [closed]

I am trying to write a script that does the following. Imports an xls file containing x, y, and other columns with data. I want to make this into a point shape file. I want to take that point ...
1
vote
2answers
46 views

Spherical law of cosine what does the 'a' represent?

I want to use the spherical law of cosine formula, θ = atan2( sin Δλ ⋅ cos φ2 , cos φ1 ⋅ sin φ2 − sin φ1 ⋅ cos φ2 ⋅ cos Δλ ), to calculate distances between coordinates, but, I cannot for the life ...
1
vote
0answers
39 views

Segmenting road from Excel spreadsheet based on specified distance? [closed]

I have created a model that turns an excel spreadsheet containing coordinates into a Kml/Kmz file of a road that is segmented based on the X_from,X_to,Y_from,Y_to Columns, and the image below ...
0
votes
0answers
50 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...
1
vote
1answer
54 views

How to count the number of entries a user has selected in a multivalue field of a tool dialogue using Python and ArcGIS 10.2.1

I am currently creating a script that will read data in one (to many) Excel spreadsheet(s) and would like to know how to get a count of the number of spreadsheets entered by the user. The script will ...