Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

learn more… | top users | synonyms (2)

0
votes
0answers
4 views

xlwt try and except to handle datatype mismatch

This is somewhat of a continuation of a previous post where I should have stated that I'm still a newby to python and programming in general. I'm using xlrd and xlwt to read an excel table created ...
0
votes
2answers
26 views

CSV won't import correctly into Arcmap 10.3

I have a spread sheet with coordinates that once I bring in to Arcmap, the attributes disappear. The points are on the map, and when you Identify each point, the data shows up, but when the attribute ...
0
votes
0answers
26 views

How can I determine an appropriate query based on a join?

I am having trouble coming up with a query that will show the 12 states total population percentage in ArcMap 10.4. I created the spreadsheet below and I have already joined my excel to the states ...
1
vote
2answers
35 views

How can I display my Excel file in Arcmap 10.4?

I am currently working on a project. I have created an excel spreadsheet: So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
0
votes
1answer
31 views

ArcGIS: Add XY Data isn't plotting in the correct location.

I've done this correctly so many times, I don't understand what's wrong. The x and y columns I'm plotting are in decimal degrees. Latitude is X and Longitude is Y. I am plotting to Nad 1983 datum, ...
4
votes
0answers
50 views

Using one to many join to *.xlsx in ArcGIS Desktop?

I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file. The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the ...
1
vote
1answer
38 views

arcpy.TableToExcel_conversion works on layer but not if layer is variable

I'd like to loop through a bunch of mxds, on every layers, and from them I'm trying to export excel files. If I use a layer in arcpy.TableToExcel_conversion it works, but as I set a layer as a ...
1
vote
1answer
14 views

Does NetCDF4excel provide packed or unpacked values?

I'm using the NetCDF4excel tool to work on files from the ERA Interim database. I'm wondering whether I should adjust the values of the variables produced by the tool using each variable's ...
1
vote
1answer
107 views

Is *.xls MS Excel default format in ArcMap?

Is it always necessary that whenever we want to show our data kept in Excel spreadsheets in ArcMap, that it must be in .xls? Is .xls a default format for ArcMap?
2
votes
1answer
52 views

How to get gridded data in Excel into ArcGIS?

I am very new to using ArcGIS. Right now I have an Excel sheet with data in it where each cell represents a grid from a model output and contains a value (eg. amount of precipitation in that grid cell ...
2
votes
1answer
72 views

Importing XY coordinates to ArcMap?

I am very new to GIS. I have a dataset in Excel containing XY coordinates of points. These coordinates are said to be in WSG84, but have different decimal places lengths. Longest of them have 9 ...
1
vote
2answers
17 views

Geoserver - Layer creation via data import

We have about 400 sites (materialized by coordinates in the spreadsheet file to be imported) and several fields of information attached to these sites (coordinates, site ID, name, comments, category, ...
0
votes
0answers
6 views

Export excel with map embedded

In arcgis office you have a functionality to add a map to an excel. Now, i want to give an option to export an excel from my application(javascript, .net, or anything else) to allow the user to ...
2
votes
2answers
47 views

Output shapefile has no records after joining shapefile with table and exporting result?

I have successfully joined a .xls Excel spreadsheet to a shapefile. The join is successful (the number of remaining records seems accurate), although it takes a really long time (like 20 minutes). For ...
1
vote
2answers
58 views

ArcPy: Excel to Table Conversion and Join Management

I am trying to join an Excel table to a shapefile in ArcPy. My first step is to convert the Excel sheet to a table, but I am receiving an error: #Convert xlsx to table: import os import xlrd import ...
0
votes
0answers
34 views

Updating attribute table by CSV in ArcGIS for Desktop?

I have a File Geodatabase in ArcGis that contains shapefiles and tables. The tables must be updated using CSV or Excel files. The structure of the existing tables and the update csv will be exactly ...
2
votes
1answer
83 views

Creating shapefile from polygon points for CartoDB?

I have an Excel file that contains polygon coordinates for different areas. The spreadsheet has three columns: latitude, longitude and area name. Each coordinate makes of a part of the boundary of a ...
2
votes
1answer
48 views

QGIS Attribute update using excel

I am looking to update the Attribute table for a Layer in QGIS using a join. However I am not looking to ADD attributes to the table (thereby adding extra columns) rather I would like to "Update" ...
0
votes
0answers
21 views

What controls the insertion box for excel charts in ArcMap

I saw a related post here about inserting an excel chart to a layout in ArcMap and read the article. I still have a question about what controls the size of the insertion box in ArcMap. I'm trying to ...
2
votes
1answer
26 views

Beginner CartoDB Question- turning a simple Excel file into a map

I have Field 6 in my Excel sheet as a column of Zip Codes. How do I get them to show up on the map? My map continues to be blank. Thanks!
1
vote
1answer
52 views

Excel to Table Conversion Tool not working

When I input the table in the dialog box, I get this rather long error: ERROR updateParameters Execution Error: Runtime error Traceback (most recent call last): File "c:\program files ...
0
votes
1answer
19 views

How to remove XML tags within a field of attribute table?

I have this dataset I got it from Wikimapia ,containing bunch of fields . One of fields named "PopupInfo" contains xml tags : and looks like this when in editing mode : I want to remove these ...
3
votes
1answer
24 views

Generate new coordinates with distance + azimuth

I currently have the following Excel data for a list of animals: Lambert 93 coordinates of the observer Azimuth of the animal Distance between the observer and the animal I would like to get the ...
1
vote
0answers
26 views

Radiometric calibration NDVI values in Excel

I´m doing NDVI analysis, but i forgot to do Radiometric calibrations in QGIS. So the NDVI values in my excel table are in DNs. Can I do this calibration directly in excel?
5
votes
7answers
263 views

How to join data from excel to an attribute table in QGIS without creating duplicates

I have an attribute table with two empty fields in QGIS. I want to import an excel database to fill my empty fields in QGIS. My excel file matches the columns in my QGIS attribute table. I am ...
0
votes
1answer
54 views

Exporting attribute table with 100,000+ features into Excel file using ArcGIS Explorer?

I need to export the underlying data contained in these GIS files (http://wildfire.cr.usgs.gov/firehistory/data.html) into a .txt or .ascii file. I am using ArcGIS explorer so I do not have the ...
2
votes
0answers
27 views

QGIS imports two excel double vectors: one as double, the other as QString! Why?

I work in QGIS 2.8.3 and import an excel file (xlsx version 2013) containing 5 vectors: string, string, double, int, double. All vectors have a heading. However, QGIS tells me that the last double ...
0
votes
0answers
12 views

Way to update and style multiple features within KML

I am trying to find a quicker, automated process that will enable me to update multiple line features within a KML. The geometries are initally created and styled from QGIS. Currently, I run through ...
2
votes
0answers
32 views

Extract Mean Raster Value from multiple raster files into Excel

I have a series of non-orthorectified raster files containing NDVI information. I would like to extract the mean value from each raster so I can see a summary of each raster image name and the ...
1
vote
0answers
12 views

trying to activate GeoRover LocusTracker toolbar; another way to import to shape file?

In ArcGIS I'm trying to activate the GeoRover LocusTracker toolbar but it won't come off its grayed out status. Might anyone know how to make it active? If anyone knows of another way to import an ...
2
votes
1answer
27 views

Using ArcGIS ModelBuilder in to Select By Attributes?

I have a file showing for each disaster, which provinces were affected. The number of provinces affected varies and their names or associated code varies as well. Example, if a flood in 2000 ...
3
votes
2answers
28 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
67 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
1answer
53 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
43 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
70 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
29 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
72 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
45 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
67 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
59 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
139 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
43 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
92 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
73 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
102 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
45 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
25 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
33 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
30 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 ...