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

learn more… | top users | synonyms (2)

0
votes
1answer
36 views

Degrees Minutes Seconds to Decimal degrees for Iceland coordinates - Normal formulas come out wrong

I want to put a file with Coordinates in Minutes seconds to decimal degrees. Ive tried to use formulas such as should work in excel both modules and this formula: =-H2-I2/60-J2/3600 and 65,26583333. ...
0
votes
1answer
34 views

Converting to Date Format in Arcgis

i have ab Excel table which it's fields are (year,month,day,hour,AM/Pm), how to convert those Fields into a Date format table in Arcgis and then creating a time frame Visualization.
0
votes
0answers
23 views

Predefined reports using ModelBuilder? [on hold]

I am new in ArcGIS and I am trying to use ModelBuilder. I want to generate predefined reports using some existing features. Some of the features are related. So i want to use only one field from ...
3
votes
2answers
81 views

How to preserve formulas in XLS cells when working in QGIS?

Opening layers directly from XLS spreadsheets is a very useful (if not well documented) feature of QGIS, but I can't seem to be able to properly import cells where the contents of the cell is the ...
1
vote
2answers
55 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
48 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
22 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
36 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
76 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 ...
0
votes
1answer
44 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
48 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
82 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
46 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
69 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
104 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
124 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
93 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
91 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
46 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
71 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
185 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
63 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
175 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
133 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
50 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
69 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
54 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
53 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 ...
1
vote
0answers
105 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
62 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
113 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
37 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
72 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
118 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
89 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
107 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
91 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
246 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?