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
30 views

Excel data to a Raster Map

I am trying to create a radiometric map, I have x, y , z coordinates and a value in excel. I want to create a raster map based on this data. How do I go about doing this. I am using ArcGIS 10 with ...
1
vote
1answer
16 views

How to read non-spatial data using PyQgis?

I'm generating maps with QGis. What I do is generate a bunch of non-spatial data on a set of cities (using VBA), and still using VBA, generate a python code that will automaticaly output general map ...
1
vote
0answers
40 views

Repeated GPS coordinates in data are creating stacked points on map in QGIS

I have 30+ events of data collection for each GPS location (previous person on project has simply added new rows for each data collection period). When I import the excel file (via CSV format), each ...
0
votes
1answer
55 views

ArcGIS ModelBuilder Iterate Tables and XY Event Layer?

I'm running into an issue that was not addressed in a previous question, but linked to a similar issue (ArcGIS modelbuilder: Iterate through Excel sheets?). I'm using ModelBuilder to import .xlsx ...
0
votes
1answer
43 views

Data Import Not Geocoding Everyone from Excel File

I'm new to this, so please go lightly if I'm asking something obvious. I imported an Excel file with 9,159 entries and I'm mystified as to why 841 are cartodb_georef_status false and another 36 null. ...
1
vote
1answer
46 views

Layout misshapen when export to PDF in Arc GIS 10

I want to include an Excel table in my ArcMap Layout which is working fine as long as I won't print to PDF. If I export the map to PDF the table looks like this: There are a lot of weird characters ...
1
vote
1answer
28 views

Joining Excel file with CityGML file using FME?

I want to join a excel file with a CityGML file with FME. i want to join the excel file with the geometry of the CityGML file. all attributes should join this file which settings should i choose ...
0
votes
1answer
58 views

Data copied from Excel to ArcMap layout view not exporting?

I prefer to use excel to make legends as I find it quicker than using ArcMap. Occasionally in some projects when I copy these in they appear fine in ArcMap, but some aspects don't export. ArcMap ...
0
votes
0answers
58 views

Using ArcPy.TableToExcel_conversion in Script Tool removes automatically added data

I'm using ArcGIS for Desktop 10.3.0.4322. I have a peculiar occurrence that I don't quite fully understand. I have a Python Script Tool that does a number of different things, to include using the ...
2
votes
1answer
30 views

How to export from ArcMap to tab-delimited text file, while preserving formatting and values?

I'm working with a complicated fGDB featureclass which contains hundreds of fields, in a variety of text and numerical formats. This is proving difficult to export into tab-delimited text file format. ...
0
votes
2answers
62 views

Copy column from Excel to attribute table

Is there any way to copy a column from excel to an attribute table's column in ArcGIS?
1
vote
1answer
39 views

What value to place for data which has no lat/long value?

i'm trying to create a shapefile from an excel spreadsheet. the spreadsheet contains some data such as "unknown record" for which no lat/long can be obtained while the rest of the data is related to ...
0
votes
0answers
17 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
0answers
48 views

How can I show a trip on a map, color-coded by how long the trip actually took?

I have a series of origin and destination addresses in a spreadsheet, with start times and arrival times for each. I'd like to plot them on a map, with a line between each origin and destination, ...
2
votes
4answers
174 views

How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?

(I've edited this question to reflect some of the answers/insights from below...) Original(ish) Question: I'm wondering if someone can share a bit of insight (or actual code) on how exactly to export ...
1
vote
1answer
33 views

With Modelbuilder, how to iterate field value so final output table is empty if input is empty?

I have created a model which will output two Excel tables (the green circles at the end) per state. I am using "Iterate Field Values" to go through each state to create the tables. While this gives me ...
0
votes
2answers
94 views

Troubleshooting ERROR 000814: Invalid file type from arcpy.TableToExcel()?

I wrote the script below to iterate through a file geodatabase's feature classes and convert them to an excel table. However, it returns the error ExecuteError: Failed to execute. Parameters are not ...
-1
votes
1answer
21 views

Converting start/end easting/northings to a single point for visualisation

I have eastings and northings for the start and end of 5m sections of the UK railway network. I want to convert these points to a central point between the start and end so I can visualise the ...
1
vote
1answer
109 views

Excel XLSX data with coordinates displayed as points

I am preparing a course for QGIS newbies, which includes handling Excel spreadsheet data in QGIS. It's so easy: Just drag an XLS, XSLX or CSV from Windows Explorer to QGIS! For data with no ...
0
votes
1answer
65 views

ArcGIS Select by Attribute SQL syntax problem

I have a list of aprox 150 unique road names in Excel. I copy and paste (as text option) that list into Word (2013 version). I then "replace" all the end paragraphs (^p) with quotes and commas (','). ...
3
votes
4answers
117 views

Python Script create spreadsheet with exception

In the following Python Script, I would like to create a spreadsheet (Excel would be fine) with the Exception results instead of just printing "There was an error--->..." to be able to keep track of ...
1
vote
1answer
40 views

Updating cells in Excel using FME SQLExecutor

In version 2013 FME reads and writes Excel worksheets with XLS_ADO. I have several working 2013-workbenches, which update individual cells in Excel worksheets using this SQLExecutor and this format ...
1
vote
0answers
51 views

Setting encode type in Excel Reader of FME?

I have downloaded trial version of FME 2015 and I try to read an Excel file which included multiple sheets with filtered columns and pivot tables. I want to read this file in FME and write the data ...
0
votes
1answer
58 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
50 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.
3
votes
2answers
89 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 ...
0
votes
1answer
55 views

ArcGIS saving blank file while using ArcPy to join shapefile and Excel table?

I'm working on a project that utilizes ArcPy to join a shapefile and a excel file. This join takes information from the excel file and creates a map that highlights certain areas different shades of a ...
1
vote
2answers
97 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
67 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
66 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
61 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
209 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
90 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
101 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
3answers
135 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
55 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
108 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
181 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
124 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
212 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
276 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
151 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
51 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
165 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
275 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
100 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
2k 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
54 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
523 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
79 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 ...