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
0answers
15 views

How to refresh or update a vrt layer in Qgis?

When using the QGIS SpreadSheet Layers plugin, how do I update the SQLite query without closing and reopening QGIS? I cannot see a "watch file" equivalent. The plugin creates and uses a *.vrt file ...
1
vote
1answer
29 views

How to view/display fields with high character lengths in ArcMap?

I am trying to import an Excel spreadsheet with a field that has more than 255 characters. Do I have to convert the Excel table to a file geodatabase table first in order to view this field in ...
0
votes
0answers
56 views

Display the content of a sheet of an excel file by mapbasic [closed]

Normally, I can open .xls file by File menu>Open and specify the file name I want to open and check "Use Row Above Selected Range For Column Titles". But now I would like to create a dialog via ...
0
votes
1answer
47 views

Create multiple pizza slice type shape from excel

I am trying to make pizza type shape with various radious of each slice. Number of slices depend on number of years and radius of each slice depends on number of population. All I know the center ...
0
votes
0answers
18 views

How to load data from a CSV file into ArcGIS Pro?

I'm very new to GIS mapping and I have some polygons loaded into ArcGIS Pro. I need to associate some data that is currently stored in Excel with each polygon e.g. population density, average rent. I ...
1
vote
1answer
20 views

Creating a new layer from a spreadsheet and an existing shape file in QGIS

I have a map of US zip codes and a spreadsheet that associates data with specific zip codes. I want to show the zip codes where the most data exists using a gradient, but I am not even sure how to get ...
1
vote
0answers
31 views

Qgis delimited text layer from an excel file converted to .csv

I'm trying to add a delimited text layer using coordinates. The file has been created in excel and then converted to a csv file in the saving. When I put it into Qgis it doesn't recognise the ...
1
vote
2answers
102 views

Creating tool in Python toolbox to export field list to Excel?

I am creating my first tool in a Python Toolbox (*.pyt) to export a list of fieldnames to Excel. I have the following bits of code: import arcpy class Toolbox(object): def __init__(self): ...
2
votes
1answer
29 views

Assigning Arrow Symbology on Point-to-Point Connections

I have an excel file containing points of departure and arrival places and their lat/long. I have lat/long for both arrival and departure cities in spreadsheet. I have created seperate point feature ...
1
vote
2answers
44 views

Can't link excel data to ArcGis 10.2

I want to make a shapefile from an excel spreadsheet, after clicking on Add Data button and leading to the folder containing the excel file, it doesn't show any excel spreadsheet and the drop down ...
0
votes
1answer
35 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
25 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
42 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
80 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
50 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
52 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
35 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
59 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
68 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
46 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
74 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
41 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
22 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
244 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
40 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
107 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
116 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
72 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
131 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
44 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
54 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
62 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
55 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
90 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
64 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
113 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
73 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
87 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
72 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
264 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
102 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
125 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
140 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
59 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
112 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 ...
-1
votes
2answers
203 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
161 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
239 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 ...