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

learn more… | top users | synonyms (1)

0
votes
1answer
17 views

How to upload to an Attribute table

I have digitized a polygon using Arcmap 10.1. I want to upload fields from an excel table into the attribute table of the polygon layer. How do I do this ?
0
votes
1answer
40 views

Converting Excel Sheet to Shapefile without XY Coordinates?

I am currently trying to build a model that will join two excel tables (without xy coordinates) to one shapefile, which will save some time on a very long process that I have to repeatedly do each day ...
-2
votes
2answers
89 views

How to populate my table with data in excel format?

I have 160000 rows of data in Excel and I want to put them in my table in PostgreSQL. How can I import X,Y coordinates from my excel file to my table in postgresql?
0
votes
0answers
42 views

When displaying XY data from Excel, attribute table empties

I have a massive Excelsheet with XY data and various other information. I followed the instructions on this site here http://support.esri.com/en/knowledgebase/techarticles/detail/27589 to display the ...
1
vote
2answers
101 views

Creating species distribution map?

I have to create some species distribution maps, but I have very little experience with ArcGIS unfortunately. I have two different kinds of excel sheets: 1) A version with many thousand X and Y ...
1
vote
2answers
78 views

Errors using arcpy.CalculateField_management

EDIT: What I forgot to mention when I first had this question is that I was trying to do these calculations on a layer which had joins, BUT where the join was on data that was added from an Excel ...
1
vote
2answers
44 views

Representation of precipitation data

I have an excel sheet of precipitation data of each month of some districts. I have also the shapefiles of these districts. How can I represent this data in these shapefiles.
2
votes
1answer
55 views

QGIS 2.6 How to create a shapefile from an excel file?

I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shape-File). I have managed to convert it as CSV file and load it into QGIS (displays data fine) ...
2
votes
5answers
167 views

How to export attribute table with start and end coordinates of lines to Excel?

I am working in QGIS. I have a georeferenced line layer and I want to export the attribute table and the coordinates of start and end points of my lines to Excel. Can I do this with QGIS?
1
vote
1answer
59 views

How to connect Excel file with QGIS?

I am working with QGIS and I want to connect with Excel. I have exported attribute tables to Excel. Now I want to connect Excel with QGIS in the way that if I change a line dimension, it will be ...
1
vote
2answers
121 views

How to export attribute table to Excel from QGIS?

I have seen all the questions for this question, and I try all the answer like copy paste, csv (in fact this I don't know where to find) but none of all is not the right answer. Can anyone help me?
0
votes
0answers
50 views

Getting coordinates from random directions

This is an odd question, but was wanting to know if there was a way to get coordinates from random directions. I have about 2000 directions in a spreadsheet column. There is name and a few other ...
0
votes
2answers
86 views

can't join excel(2013) to ARCGIS 10.2.2

When trying to join Excel datafile to shapefile in ARC GIS 10.2.2 I keep getting the following message: "Failed to connect to database. An underlying database error occurred. Class not registerd." ...
0
votes
0answers
39 views

Fusion Tables - create line features from excel import

I am importing an xlsx document which has start xy and end xy for lines in to a fusion table for mapping. Creating the point features is easy. The documentation says that I need to create a kml for ...
1
vote
0answers
11 views

Transparency and Excel Objects not exporting properly!

As of this week, all of my maps that have transparency in a data frame or an excel object or both are not exporting properly. A few other folks in my office are experiencing the same thing (making me ...
1
vote
0answers
65 views

Updating attribute table from an Excel file using Python

I am kinda new to Python, please excuse for such a trivial questions. There is a shapefile (let's call it Materials.shp). I have an attribute table with different fields (for example, windows, doors, ...
0
votes
1answer
52 views

Importing Excel file to ArcMap

https://www.dropbox.com/s/disaisc1wrv1mbi/Form470_2015-02-11-13-10-13.xls?dl=0 I downloaded that from the USAC (people that manage USF, E-Rate, etc.) web site. I've tried many combinations of ...
0
votes
0answers
45 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
57 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
52 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 ...
1
vote
0answers
28 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
81 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
75 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
33 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
64 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
93 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
81 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
79 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
87 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
84 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 ...
2
votes
0answers
64 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
8 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
194 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
44 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
32 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
138 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
135 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
280 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
375 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
43 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
98 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
136 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
673 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
29 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
355 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
552 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
150 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
72 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 ...