Excel is a spreadsheet application. It features calculation, graphing tools, pivot tables.

learn more… | top users | synonyms (1)

0
votes
0answers
42 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

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 ...
0
votes
0answers
12 views

How to create Fire Run Book street index and export it to *.doc/*.csv rather than *.pdf? [duplicate]

I am using Fire Run Book toolbox through ArcGIS for Local Government but it exports the the street index into a PDF document. Any idea on how to create a street index and export it to an excel ...
0
votes
1answer
26 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 ...
0
votes
2answers
40 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
30 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
1answer
48 views

How to create input data for the LRS plugin from an 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
33 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 ...
0
votes
1answer
52 views

Help in importing excel data

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 ...
1
vote
1answer
40 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
51 views

Problem adding dates into an existing feature class from an excel spreadsheet [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
27 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 ...
1
vote
0answers
23 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 privlidges for ...
3
votes
2answers
165 views

Excel Distance Calculation

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's, ...
0
votes
1answer
32 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
88 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
79 views

ArcMap's Join and symbology

I'm still new into the GIS World, and here's what i'm trying to achieve , i have Yemen administrative shapfile with list of governments, and districts,i also have an excel file with a list of migrants ...
0
votes
0answers
19 views

export latitude and longitude from google earth to excel [duplicate]

I need to export the latitude and longitude of 300 specified sites from google earth to an excel file. I there any systematic way to do it? I really appreciate your help I have found the following ...
0
votes
0answers
26 views

Table merging: multiple corresponding objects

I'm working with a shapefile which has all the municipalities of France as areas, identificated with their unique code (INSEE code). I want to join a table, where every historical monument is ...
0
votes
1answer
46 views

arcgis - updating joined excel file when adding a new sheet

When adding a new sheet to a joined Excel file in ArcGIS, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection...? edit: sorry for the delay ...
1
vote
1answer
60 views

Need to use xlsx data to clip a shapefile

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 ...
0
votes
0answers
25 views

Can we integrate Shapefile, Maps into MS-Geo Flow for Office 2013?

i used Ms-Geo Flow for office 2013. it is very good tool to visualize your Spatial data. I wanted to integrate shapefile , Border maps, Thematic maps for making better presentation. so my question is ...
0
votes
0answers
56 views

Creating Cluster “Zones”

I've looked at the "Questions that may already have my answer" and it didn't appear that the questions were specific to my questions. Although I am sure I am not uncovering some brand new quetsion ...
3
votes
1answer
114 views

Is there a method to write feature class attributes and counts to an 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. Essentially, I would like to show the the attribute ...
0
votes
1answer
127 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. ...
2
votes
2answers
138 views

Issue on Generating Points Shapefile From An 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 ...
-1
votes
1answer
53 views

Where did my points go?

I had an excel file marking points on my map. I then added a base map and my points are gone. Even with the base map layer turned off the points do not show. I tried reordering the layers and tried ...
0
votes
2answers
83 views

How to add Excel-sheets with meter coordinates to QGIS?

I have an Excel-sheet where the coordinates are in meters. What is the most efficient way of inputting this file to QGIS? There are thousands of files to put so please recommend some straight-forward ...
3
votes
1answer
51 views

How to export layer attribute table to specific worksheet of already existing Excel workbook?

How to export a feature layer attribute table to a specific worksheet of an already existing Excel workbook?
2
votes
0answers
79 views

Shapefile From Excel Sheet Crash When Selected Spatialy or By Attributes

Using ArcGIS 10.2, I am receiving an Excel sheet, on a daily basis, which contains 105 columns(Fields) and includes has X and Y values. For whatever reason (which I cannot understand) all data types ...
0
votes
0answers
32 views

When doing table to table conversion, a text field gets converted to Blob type

I have one field that keeps getting converted to Blob type after conversion using table to table tool. The field is mostly text and fairly lengthy, maybe 250 ish characters. Is the length of the field ...
0
votes
1answer
68 views

Update the layout excel file automatically when the attribute table chnages in arcmap

I am trying to put an excel table in arcmap layout where this table includes some statistics over one of the Features Attribute table. This Feature is going to be updated regularly and consequently ...
2
votes
1answer
157 views

How to export Select By Location result to Excel using Python and ArcPy?

I have been using ArcGIS for a few years now but have only started using Python scripting for ArcGIS for a month or so. I am trying to create a script and I am having a hard time trying to get it to ...
9
votes
2answers
198 views

Can ArcGIS ModelBuilder open Excel file for manual editing, then feed those edits back into model?

I have been tasked with creating a model using ArcGIS ModelBuilder, that initially runs a couple of geoprocessing tasks, before then joining an Excel table to the result of those geoprocesses. ...
6
votes
1answer
128 views

How to call arcpy.RefreshActiveView() every 5 seconds using ArcGIS Python?

I have an Excel macro that generates random values after every 5 secs and I am reading it in ArcGIS for Desktop... to refresh the view I have to press f5 and the view gets updated. Now I want to ...
6
votes
1answer
91 views

Pull Data from Specific Excel Cell into ArcPy

I am new to Python and ArcPy, and wish to create a short script that pulls in a value from one specific Excel worksheet cell (namely, A2) and then performs an 'if' statement, whereby if the value of ...
0
votes
0answers
42 views

Visualize Data as 3D taken from Excel file on a map

My problem is that I have to do 3D visualization of data on map. I have Excel file with three fields: Latitude, Longitude and Value,as shown here Excel file. I need to represent Value field on map as ...
2
votes
2answers
103 views

Convert surveyor's calls in excel table to polygon shapefile

Do you know of a way to take surveyor's calls from an excel file (for example: N35-45-15W 60.0 ft, etc) and have them generate polygon shapefiles point by point in GIS? I know you can easily do this ...
1
vote
0answers
36 views

How to repair a data source with joins to Excel?

I have a set of MXD files, that do not use relative paths, and related data that have been copied to a new computer. Normally it's not a big problem to repair the data sources in the project, but in ...
1
vote
1answer
136 views

QGIS, making a topo map from an excel file

I will appreciate your help. I am new to QGIS, this question might be common but trough me search I did not find the answer I needed hence my question here. How do I make a topo map ( raster) from ...
1
vote
1answer
302 views

Error exporting attribute table in ArcMap to Excel

I try to export an attribute (and dbf) table from ArcMap10 to txt file, but the program gives "An error occurred exporting the table" I checked all others types of exporting - all give the same, ...
5
votes
3answers
266 views

Cleaning up data in Excel for use in QGIS

I am trying to clean up a large .txt dataset in Excel. I think that a macro or another application may be able to clean up the data they way I want but I have limited programming skills. I need to ...
3
votes
2answers
83 views

Why can't I open a .xls with QGIS in OSX?

I'm trying to open an .xlswith QGIS 1.8 in a Mac, I'm loading the vector layer from Add new vector layeretc. etc. the procedure works in Windows but not in Mac where I have an error Invalid source ...
3
votes
2answers
271 views

Why does ArcPy Excel To Table give AttributeError: 'module' object has no attribute? [closed]

I'm trying to import an excel workbook using arcpy. ExcelToTable, but I get the following traceback: ERROR updateParameters Execution Error: Runtime error Traceback (most recent call last): File ...
2
votes
1answer
107 views

ArcGIS Online heatmap

ArcGIS 10.2, ESRI Maps for MS Office Why a heatmap that was created in Excel and looks fine and is still fine on a preview of a map if I publish it it ArcGIS Online but turns into black points if I ...
0
votes
1answer
98 views

Import raster into ArcGIS

I received raster data from a grid of 1100 by 1000 meters with a resolution of 1 meter. It is the output of EFC-400 software showing the field strength around power lines. The data is currently in ...
5
votes
1answer
284 views

ArcGIS modelbuilder: Iterate through Excel sheets?

I am trying to use modelbuilder (ArcGIS 10.1) to add XY data to ArcGIS, then export the events as Feature Classes. The data comes in one xlsx document with a large number of sheets, each with an X and ...
3
votes
6answers
793 views

What is the best way to change a data type in the ArcGIS attribute table?

What is the easiest way to change the data type in an attribute table in ArcGIS for multiple fields? Say if the fields have been exported as a string from Excel and I would like to use them as ...
1
vote
0answers
41 views

Joining Data in ArcMap Errors

Has anybody encountered issues with ArcMap when joining data? Specifically, my rows join, however, depending on how ArcMap is feeling, I might or might not receive my data in the form of quantities. ...
0
votes
1answer
477 views

Convert Degree Minutes to decimal degrees [duplicate]

I have location points collected from a garmin device stored in an excel sheet in Degree Minutes format --- W00208.172,N1046.977. I am looking for an Excel formula to convert either to Decimal Degrees ...
0
votes
1answer
240 views

QGIS: CSV point grid to polygon - not raster

I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to ...