Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
3
votes
2answers
774 views

Mapping tabular data based on city/province name?

I am very new to GIS and ArcGIS. I have an Excel file containing data on cities (only names) and provinces (of those cities) for 158 countries around the world. The data also contains some economic (...
1
vote
1answer
262 views

ArcGIS 10.2 arcpy — how to import/install win32com?

win32com used to be included with arcpy 9.x but no longer. I used to use it to manipulate excel occasionally. I downloaded and let win32com install itself and then tried to follow some online ...
3
votes
3answers
1k views

Can a shapefile, or other file, be made from Excel without coordinates

I have two Excel spreadsheets I'd like to make into shapefiles, or some equivalent. I have access to ArcGIS at work and want to try using GRASS as well. I have seen the help on doing so, but only if I ...
-1
votes
1answer
2k views

Error 001156. increasing the length of text limit [duplicate]

I'm fairly new to ArcGIS for Desktop and i want to import my excel table to my personal gdb but i end up getting an error code:001156 and my import fails. I soon found out that it was the lengthy ...
1
vote
1answer
3k views

Data refusing to line up with basemap after re-setting source for data

I've only been using GIS for a couple of months so this is probably just a really basic/novice problem but I cannot for the life of me fix it. The other day I managed, with a lot of finagling, to ...
4
votes
2answers
2k views

Calculating Distances between coordinates

I have 75 coordinates in WGS84 that I brought in from an Excel table. They are now on my imagery basemap spanning across about a half mile on either side of a dirt road in Prescott National Forest in ...
0
votes
2answers
845 views

How to update Geodatabase point file table from Excel data using FME

I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data ...
1
vote
1answer
347 views

Table to dBase tool failure when converting .xls files

Whenever I load my Excel 2010 worksheets into ArcMap 10 Table to dBASE tool, it fails, returning the error: "Failed to Copy Rows" The Copy Rows tool works just fine for me on a single document. There ...
1
vote
0answers
118 views

Adding information from excel into ArcGIS [closed]

I am working in ArcGIS and have a excel sheet with data pertaining to properties. I want to add this data to a map in ArcGIS of which i have property boundaries as a shapefile? I have a common folio ...
4
votes
1answer
2k views

Draw lines between two points in QGIS

I have an excel (Fig) which has both X & Y in projected coordinates (WGS84/UTM). Is it possible to draw lines between the X & Y in QGIS ? I've tried to create points based on X,From_y and X,...
1
vote
1answer
4k views

One to Many relation in ArcGIS for Desktop?

I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building. The attribute table for the building has these columns: id,label,number. I ...
0
votes
0answers
981 views

Is there a way to have a choropleth map in Excel reading data from a sheet?

Is it possible to have a solution similar to ESRI maps for office in which I want basically a geojson file or any file for that matters to render a choropleth map based on data in a sheet? Tried ...
2
votes
1answer
48 views

Atributing fields in arcmap and excel

How do I populate a field in ArcMap (and Excel) with only a specific part of another field's attributes? For example: I want to populate the LATDEG field with only the degree part of a latitudinal co-...
1
vote
2answers
1k views

Cannot convert dms to dd in Excel 2007 using VBA code

I am trying to convert the data in an Excel sheet from dms (degree-minute-second) to dd (decimal degree) format using the vba script available here. Here is sample data: 53° 0' 39.31" 6° 44' 50....
2
votes
2answers
507 views

Table to Excel Arcpy Error

I am trying to export a point shapefile to an Excel sheet using the arcpy.TableToExcel_conversion(FinalClipOutput, ExcelOut, "", "") The "FinalClipOutput" is the result of a clip that happens ...
2
votes
1answer
556 views

Can I batch import attribute tables into existing excel spreadsheets

I am using arcGIS 10.2 and I need to import the attribute tables of 100 layers into existing excel spreadsheets which will make graphs based on the values in the attribute tables. Doing this ...
3
votes
2answers
5k views

Changing field type of Excel attribute table for a Join

I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field ...
-1
votes
2answers
1k views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
1
vote
0answers
459 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
0
votes
1answer
77 views

Updating spreadsheet from polygons in shapefile using GDAL? [closed]

I am a beginner with GIS data, and have been looking for an answer but have not yet found it. I have a spreadsheet with lat/long points. I also have a shapefile with several numbered polygons over a ...
4
votes
1answer
983 views

Is there a way to edit field name, type & length after importing from Excel?

Is there a way to edit the name, type and length given to each column on the attribute table once the information has been imported from Excel?
2
votes
2answers
283 views

Randomly choosing one from multiple fields in Field Calculator of ArcGIS for Desktop?

Using the Field Calculator in ArcGIS for Desktop, I want to randomly choose one field from a list of 10 fields (strings). The Excel equivalent, which is working, is: =INDEX(A2:J2;rnd()*10+1). How ...
-2
votes
1answer
2k views

Creating a python script to import an excel spreadsheet, create shapefile and do some analysis [closed]

I am trying to write a script that does the following. Imports an xls file containing x, y, and other columns with data. I want to make this into a point shape file. I want to take that point ...
1
vote
2answers
217 views

Spherical law of cosine what does the 'a' represent?

I want to use the spherical law of cosine formula, θ = atan2( sin Δλ ⋅ cos φ2 , cos φ1 ⋅ sin φ2 − sin φ1 ⋅ cos φ2 ⋅ cos Δλ ), to calculate distances between coordinates, but, I cannot for the life ...
0
votes
0answers
252 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...
1
vote
1answer
109 views

How to count the number of entries a user has selected in a multivalue field of a tool dialogue using Python and ArcGIS 10.2.1

I am currently creating a script that will read data in one (to many) Excel spreadsheet(s) and would like to know how to get a count of the number of spreadsheets entered by the user. The script will ...
4
votes
2answers
645 views

Combining MS Office with GIS?

I would like to incorporate MS Office into my GIS program. I have been using QGIS and was wondering if this would be possible? I am trying to create a one stop shop for my staff to be able to ...
1
vote
1answer
295 views

Can X-Ray for ArcCatalog be used without Excel?

Can X-Ray for ArcCatalog be used without Excel? Our organization went with Libre Office as a budget savings move. Calc in that suite can read/write .xls files, but X-Ray appears to require Excel ...
1
vote
0answers
284 views

Batch Zonal Statistics to Spreadsheets?

I have a pretty immense amount of Zonal Statistics as Table computations to do, and would love to find a way to grab mean and variance values from the little .dbf tables ArcGIS creates and put them ...
0
votes
2answers
514 views

excel column does not appear when doing join after doing modification to the column

Using ArcGIS 10.1 I am trying to add " /1 " my column provided Shp File how it appears in the county supplied excel spreadsheet under "parcel #" 43002/1 18524/1 1666/1 4270/1 Currently, the county ...
1
vote
1answer
107 views

Automatically recalculating in ArcGIS Desktop if Excel data source modified?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
1
vote
1answer
1k views

Street index to CSV/Excel file

Anyone know how to generate a street index for a map with accompnaying page numbers that are data driven? I am use the toolbox for creating the street index but exports to PDF however I need it to be ...
1
vote
2answers
424 views

How to Convert Interpolated Map to Excel using ArcGIS for Desktop?

I have interpolated some SO2 data using IDW and have calculated means on county level using Zonal Statistics. I would like to convert this data now into an excel file. I already got the hint, that I ...
0
votes
1answer
143 views

Hand-written coordinates from a Garmin NUVI

I've been asked to map point data that was collected in the field by manually writing down the coordinate from a Garmin NUVI 1490 LMT. They were put into a spreadsheet and sent my way which I was ...
0
votes
2answers
495 views

Creating input data for LRS plugin from Excel table without coordinates?

I'm working with QGIS 2.2.0. I want to add a shapefile from an excel file that has informations I want to use in the LRS plugin. The excel file has no geographic information. Every time I try to save ...
0
votes
1answer
159 views

How to join information from an excel table to a road feature in QGIS?

I'm working with GQIS 2.2.0 Valmiera. I've made a shapefile of a road that consists in a single line. Now I want to add information that I have in an excel table about several point in the road. How ...
1
vote
1answer
605 views

Importing data from Excel into ArcGIS/QGIS

I have downloaded the hourly solar radiation data from NREL which is in CSV format but the problem is that the file does not have an exclusive column called latitude and longitude. There are 100s of ...
3
votes
1answer
2k views

Is it possible to link a QGis project with an excel file?

I have an Excel file with coordinates and I have used this file to plot the coordinates in QGis. I was wondering if it was possible to permanently link the excel file to the QGis project, so that when ...
2
votes
1answer
135 views

Adding dates into existing feature class from Excel spreadsheet using ArcPy? [closed]

I've been trying to load data from an excel spreadsheet into existing feature classes, but I've been having some trouble with the dates. I've written a script that compares the values in the ...
0
votes
1answer
120 views

Raw State Data on Health and Social Outcomes

I am looking for raw health and social outcome data (poverty, obesity, education levels, etc.) by state. I would like to download it as a csv or excel file. It needs to have the state fips listed in ...
2
votes
1answer
145 views

CartoDB linked to Sharepoint

Has anyone tried linking a Sharepoint Excel spreadsheet with CartoDB? My spreadsheet has a URL like it would from Google Drive or Dropbox and it is shared with editing and viewing privileges for ...
8
votes
2answers
50k views

Performing Distance Calculation using Excel?

Is there a way (preferably in Excel) to calculate the distance (based on lat, lon) between two lists of points? My end goal would be, for example, to have a list of Starbucks and a list of McDonald'...
1
vote
1answer
103 views

Ohio DNR Oil Gas Lat / Long Conversion in ArcGIS 10.1

Is anyone familiar with the Ohio Oil Well Search off their website? For the Lat/Long, they have WH_X and WH_Y. The numbers in their do not match up with the actual Lats/Longs off the OHio Well ...
1
vote
2answers
295 views

How to summarize Excel data within the zones of another dataset by using ArcGIS 10.2

I have the following Excel data, I want to summarize the P-value within the zones of map dataset. I have sereached a lot and learned I might need to convert Excel data into XY table, and then into a ...
2
votes
2answers
859 views

Using ArcMap Join and symbology

I'm still new into the GIS World, and here's what I'm trying to achieve. I have Yemen administrative shapefile with list of governments, and districts, I also have an Excel file with a list of ...
1
vote
1answer
3k views

Updating joined excel file in ArcGIS Desktop when adding new sheet?

When adding a new sheet to a joined Excel file in ArcGIS Desktop, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection? I have some projects ...
1
vote
1answer
215 views

Using xlsx data to clip shapefile in ArcGIS Desktop

I have an Excel table with just one column, with 1150 records, each of them a species name. I also have a shapefile with 24,000 records, each of them a species name and its geographic range. I need to ...
3
votes
1answer
652 views

Writing feature class attributes and counts to Excel workbook in Python? [closed]

I have a feature class with 3 fields that I would like to reference later in an excel workbook. They are all represented in 3 different maps. I would like to show the the attribute counts for these ...
0
votes
1answer
2k views

Adding and Editing Excel table to the data frame

I have few excel tables of almost 5-6 columns and i need to paste them at different locations in the same map. The values in the excel table gets revised every quarter and i need to edit the table. ...
4
votes
2answers
1k views

Generating Points Shapefile From Excel File with X Y Values?

Using ArcGIS 10.2, I have an Excel file (Please review attached zipped Excel file) from which I am able to Generate Points by using the "Add XY Data". The points are generated on the map (using WGS84)....