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

learn more… | top users | synonyms (2)

3
votes
2answers
23 views

How can I link the cells in the excel files to a pixel on my map?

I produced an excel file with the historical solar radiation of Australia (the file has 679 rows and 839 column and the filled cells have the shape of Australia). How can I link the cells in the excel ...
1
vote
1answer
36 views

Conversion of .csv file to MapInfo generates very large .dat file

I am converting an .xls file (500kb) to a .csv (150KB) then using this to generate a MapInfo .tab file format using both QGis and ArcGIS. I can use an intermediate file ie. mif/mid format which gives ...
1
vote
0answers
30 views

Export to .dbf changes my data in ArcMap 10.2.2

I have an excel table with parcel ID's (PINs). The PINs are in "number" format in excel. Iimported this excel table into ArcMap with the goal of joining them with the county parcel shapefile. I ...
0
votes
0answers
35 views

How to create a shapefile from Excel file including coordinates of points and distances between them in ArcGIS?

I wanted to use network analyst in ArcGIS and I have coordinates of points in the network. However, I could not find a shapefile including road information between these points so far (length of links ...
1
vote
2answers
35 views

XyTools QGIS plugin for attribute export

I want to export an attribute table to Excel. I see XyTools is used for that (is there another plugin?). Since I installed QGIS from OSGeo4W, I have the required library. However, when I tell XyTools ...
0
votes
0answers
28 views

Using Definition Query to pull out monthly ridership data?

I have a database of bus stop ridership for Jan-Nov of 2015. There is an existing data set information pertaining to bus stops. I previously linked individual tabs (for each month) to the bus stop ...
2
votes
1answer
36 views

Extracting NDVI using QGIS from multiple images to Excel?

I created 25 images in QGIS. Each image has different information about the NDVI of the area. How can I extract mean, max, and min information about the NDVI from each image and put it in Excel?
3
votes
2answers
35 views

Adding Excel file with degrees to map with CRS in QGIS?

How can I add a layer with X,Y in degrees (from an excelfile) to a map with CRS? I am using QGIS 2.8.2
1
vote
1answer
49 views

Bearing to X,Y, Z

I’m working on a small project where I’m testing the ability of a laser to accurately measure the angle of a wire. My control for the experiment gives me X,Y,Z coordinates for a point on the wire and ...
1
vote
1answer
50 views

Can arcpy.MakeXYEventLayer() cope with *xls files in script?

I am trying to create a point FeatureClass from an Excel-File using a standalone python-script. I am applying the method "arcpy.MakeXYEventLayer()" which works fine using *.xlsx files. However, I am ...
0
votes
3answers
79 views

Arcgis table and Excel sheet dynamic linking [closed]

How i can link an ArcGIS table with Excel sheet, so the table updated automatically when i update the excel sheet? Also, can i have sub-table in ArcGIS?
0
votes
0answers
31 views

What data type is excel in Arcgis Add Script wizard?

When creating tool from a python script in ArcGIS, data type has to be chosen in Add Script wizard and one of my parameters is Excel and another one specific sheet whereas there can be more sheets in ...
3
votes
1answer
76 views

Adding a drop-down in ArcMap

I am the sole GIS manager for an organization of approximately 200 individuals that perform engineering assessments and collect other data to prepare for and respond to natural disasters. Most do not ...
3
votes
1answer
49 views

Sort Excel table sheets with FME

I have 4 feature types and writing to a single xls file using FME. Each feature type has its own worksheet. How can I sort the worksheets with FME before creating the xls-file? I use FME 2012 SP3
0
votes
2answers
41 views

Displaying X, Y coordinates on ArcGIS not working

I am trying to geocode some coordinates I have from my Excel sheet onto ArcGIS but everytime I do so, it doesn't show up on the screen. When I right click on the sheet layer to see where it went, it ...
0
votes
0answers
39 views

Linked Excel file with Coordinates to Shapefile QGIS

There may not be an answer to this as I have yet to find anything from my searches but here goes. I have an excel file which is continually updated my multiple users. Within the excel file each row ...
2
votes
0answers
18 views

Is there any map API that allows you to pull an address range from a polygon?

I've seen a lot of answers saying you can't draw polygons and get the exact addresses of all of the places contained; thankfully, I don't need so much info. I'm looking for a way to get a vague ...
1
vote
1answer
29 views

QGIS doesn't recognize numeric cell content (xls)

I want to join Excel data (numeric) to a Shapefile in QGIS. Although the cells are defined as numbers in Excel, QGIS recognizes them as string. I tried also csv, csv (windows), txt, xls, xlsx, none of ...
1
vote
1answer
25 views

How to use European Environment Agency Land Cover Data in ArcGIS for Desktop?

I am new to ArcGIS for Desktop and I have downloaded some land cover data from the European Environment Agency. the data comes in 3 separate files, A tiff file, which is the data source for the ...
1
vote
1answer
50 views

Exporting from Excel to ArcMap?

I am having some problems exporting from Excel to Arc. Exporting directly from .xlsx to Arc columns such as Name and latitude disappears all together Exporting from .xlsx to CSV, then erasing ...
0
votes
1answer
52 views

Point feature class from xy coordinates cannot be related to project in ArcGIS

Once created the point feature class from XY coordinates I imported from an excel table (e.g. X: -4,415622; Y: 36,733385 using ArcCatalog), I am able to zoom to the layer, but I am not able to relate ...
3
votes
2answers
186 views

Export attribute table to Excel readable format

I want to save some attribute tables in a file format that Excel can read. Currently I'm using the tool Table to dBASE in Modelbuilder, but when I open the files in Excel it shows some errors in ...
1
vote
1answer
45 views

Create regular grid in QGIS from coordinates in excel file

I have received an excel file that contains data on grid cells of 500X500m. The geographical information looks like this: 13843145006371500. The first four digits is the code for the municipality and ...
0
votes
1answer
61 views

Creating shapefile from a table based on “county name” field, while there are multiple counties

I have ArcGIS 10.1. I am trying to make a shapefile out of an excel sheet that has county level data. I can't join this data based on the 'county' field to a county shapefile because I have multiple ...
2
votes
1answer
45 views

Calculate field using data from excel table

I need to interpolate data that I have in a excel file using data from an attribute table of a point feature. I want to create a new field on the attribute table with the result of that interpolation. ...
1
vote
0answers
38 views

QGIS Copy Attribute Table To Excel - where does the new lines come from?

I have an attribute table with 3100 lines. I selected the whole table and pressed the button 'copy selected rows to clipboard', afterwards I pasted them into an excel-table. Now I have 27 lines ...
0
votes
0answers
23 views

Excel to Table tool not receiving correct input in ArcGIS ModelBuilder?

I have created a model that merges several shapefiles and then exports the table to excel. However, the second time I run the model it says that the input to the 'excel to table' tool is not ...
0
votes
0answers
79 views

Excel to GIS format using FME changes column names at each run?

I have excel sheet having months field with year. I have to re-arrange to specific format. I have been able to do by just joining writer and reader columns names but my problem is the column name ...
0
votes
0answers
33 views

Load gml strings from an excel file

I have some gml strings in an excel file (example: gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="xx" srsDimension="xx" gml:pos xx /gml:pos /gml:Point). I want to load these in ArcMap, but ...
0
votes
2answers
21 views

Editing imported attributes in ArcGIS for Desktop?

I have finally completed my first ArcGIS-task, creating a shapefile containing poligons which mark designated spaces as well as installed facilities. The more than 450 facilities have a whole lot of ...
6
votes
1answer
232 views

Descrambling scrambled coordinates?

I've got a data set that comes with coordinates, however they seem to have gotten scrambled somewhere along the way of data-collection, data-entering and data-export. For some of the places the actual ...
5
votes
2answers
300 views

Way to find minimum value from a group of values - QGIS?

I'm wondering if there is a way to find the minimum value of a group within QGIS? Basically I need to find the minimum distance of each unique value in a table of about 5000 records. I can do the ...
1
vote
0answers
55 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
59 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
1answer
63 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 ...
1
vote
1answer
27 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
79 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
173 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
48 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
57 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
73 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
59 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
48 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
212 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
103 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
85 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
50 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
69 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 ...
1
vote
1answer
131 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
159 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. ...