Excel is a spreadsheet application with native *.xls and *.xlsx formats. It features calculation, graphing tools, pivot tables.

learn more… | top users | synonyms (2)

1
vote
2answers
44 views

Plotting points using coordinates from excel [duplicate]

I have an excel spreadsheet with co-ordinates (eg. S31 07 35.3). I would like to use these co-ordinates in arcmap (version 10.2) to plot points based on these coordinates. How do I go about doing this ...
0
votes
1answer
45 views

Using the mouse to select records in ArcPy

I am running ArcGIS 10.1 Basic license with Python 2.7.2. I have a two spatial files: the first listing vessel positions and the second activity on board. I also have a collection of reports in ...
0
votes
0answers
20 views

Replacing text in AutocadMAP File using excel data

I have an autocad drawing with so many light fixtures with all different names.Now we have to change all those names, i already have an excel sheet containing two columns with first one containing ...
2
votes
2answers
30 views

How would one format an Excel sheet so numeric fields are set to numeric field types when importing to ArcGIS 10.2?

I have a large Excel spreadsheet that contains lots of numeric data that I would like to import to ArcGIS 10.2 as a table using the Excel To Table (Conversion) tool. The frustrating thing is that ...
0
votes
2answers
65 views

Converting *.xlsx to shapefile in ArcGIS for Desktop?

I'm trying to import an xlsx file into ArcGIS (10.2.1, everything is fully licensed and activated), and convert it to a shapefile for further analysis. The xlsx file is ~180mb, and contains just ...
-1
votes
0answers
30 views

export all the values in different layers [closed]

I have got a pixel (x,y). There are 100 layers. How can I export all the values in different layers for that particular pixel to excel?
0
votes
1answer
35 views

QGIS - Geocoding addresses to coordinates

I've got an Excel file which includes known locations with their exact address (street, house number, city, state). This Excel file does not have a geographical column. Also, I have a .shp file inside ...
2
votes
1answer
43 views

Excel worksheet for Coordinate transformation between EPSG:31467 and EPSG:25832?

for offline use I have been asked to provide a coordinate transformation worksheet in excel that converts between EPSG:31467 and EPSG:25832 and also WGS84. Has anyone any experience with something ...
2
votes
2answers
79 views

Procedure putting online a graveyard in a GIS

I would appreciate some advice. I’m not an expert in GIS but recently I studied a bit, came on different sites. Among others QGIS, MangoMap, ArcGIS, … etc A group of 6 small towns in Belgium wants to ...
2
votes
1answer
43 views

Uploading fields from Excel into ArcMap 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
65 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
97 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
48 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
116 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 ...
2
votes
1answer
90 views

Using ArcPy to Read from Excel Spreadsheet to Python Dictionary

How would I go about creating a script that reads a specified excel spreadsheet and places the values in a dictionary? I have read about the xlrd library and how the library in such endeavors to read ...
1
vote
2answers
84 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
45 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
65 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
177 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
61 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
155 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
51 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
114 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
46 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
67 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
53 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
50 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
92 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
59 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
30 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
86 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
105 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
35 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
69 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
108 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
85 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
101 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
87 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
224 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
45 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
34 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
173 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
167 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
325 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 ...