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

learn more… | top users | synonyms (1)

1
vote
2answers
40 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
34 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) ...
-1
votes
0answers
27 views

Sending data via email …file is too large to send [closed]

How can I export 400,000 plus records from a point feature class to excel and send it in an email? Someone told me to save it as a .txt file and it could open in Excel. I tried sending it in an email ...
2
votes
5answers
118 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
55 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
95 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
49 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
60 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
19 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
10 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
50 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
47 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
37 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
32 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
50 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
75 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
49 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
31 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
54 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
88 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
58 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
63 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
79 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
75 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
58 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
171 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
40 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
29 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
119 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
113 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
233 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
289 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
86 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
130 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
525 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
225 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
433 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
144 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
68 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
185 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
62 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
46 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
99 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
124 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 ...