Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
1k views

How to create Feature Class based on DBF schema?

I have an attribute table schema (about 30 fields) stored in an Excel document, which I exported as a dbf. I can easily make a geodatabase table from this, using the Excel sheet as a template. How can ...
4
votes
2answers
8k views

How to edit Shapefile Attributes?

How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...
0
votes
1answer
873 views

How to layer statistics from Excel onto a map?

Would another free app or program be better and easier to do this than mapbox.com ? I simply want to layer census 2010 data by shading areas onto a map like on theatlanticcities.com/posts/map/ & ...
5
votes
2answers
1k views

Importing attributes from Excel file into new Polygons [closed]

I have a constantly updated Excel file containing address information which I am currently copying into the attributes of new polygons which I am creating on a daily basis. I am currently doing this ...
2
votes
2answers
388 views

Some data loss when Importing Personal Geodatabase Table from Excel?

When import table from excel some data were loss. I was trying to change field type but I can't solve this error. I have attached an example image to show the problem.
7
votes
5answers
59k views

How to export attribute table to Excel using ArcGIS Desktop? [duplicate]

In previous versions I could just export as a .DBF file, open it with Excel and then convert it to an Excel file. However, now in ArcGIS 9.3.1 the .DBF file can no longer be open by Excel. I have also ...
14
votes
2answers
77k views

Extracting Google Earth elevation data to Excel?

I have a polyline in Google Earth. I am able to see the elevation profile in Google Earth when I move along the polyline but is there a way to extract the lat,long and elevation data out to Excel?
4
votes
3answers
2k views

Converting *.xlsx datasheet with point feature data into POINT feature class using ArcPy?

I am trying to create a script tool to automate this process, eventually it will be used for batch processing but at the moment I can't even get test data to work. This is pretty basic at the moment, ...
5
votes
3answers
8k views

What is a good resource for making choropleth maps using excel data?

I would like to make a choropleth map of Malaysian regions, colour-coding them by population density. Is there a place where I can find templates of such a map?
5
votes
3answers
5k views

Importing data with empty cells without GIS replacing the empty cell with 0

I am importing data from excel into ArcGIS 10. The data are columns of GPS data, associated date and time, and a unique point identifier. For some of the rows the GPS data is missing and so the Lat ...
3
votes
1answer
1k views

How to change data type in Excel file before creating feature class?

I am trying to import data from Excel spreadsheets where each point coordinate has a 'datetime' timestamp (e.g. "2012-06-01 14:45:32") associated to it. When I check the table properties ArcGIS 10 ...
7
votes
1answer
2k views

Explaining different Standard Deviation results from same data in ArcGIS Desktop and MS Excel?

I have done some interpolation in Geostatistical Analyst in ArcGIS and I got the Standard Deviation (SD) a bit different from the SD that I calculated in Excel Spreadsheet. What algorithm does each ...
1
vote
0answers
481 views

Placemark that pulls information off an excel sheet row and display's the data in the description part of the Placemark

I am trying to find out if a certain function is available to link an excel sheet with a kmz. What i need to happen is have a Placemark that pulls information off an excel sheet row and display's the ...
6
votes
3answers
5k views

Saving *.dbf as *.xls using Python?

I've been let loose in the workplace to learn python to do things in Arcmap 10. so, I am learning python as I go and trying to remember the programming I have done. Where I am in this project is ...
2
votes
1answer
232 views

Plugging in population data into a map of provinces

Have shapefiles for provinces in several countries in an Asian region, but currently trying to plug in animal population data for each province with graduated symbols displayed the data. Am trying to ...
2
votes
1answer
3k views

Converting map coordinates using AutoCad to Excel sheet

I have some maps of pieces of lands and I want to convert the coordinates to excel sheet I want to arrange the data like this in the excel sheet: land number( the pink number in the pic) ...
2
votes
1answer
402 views

Creating sum layers by summing field values from *.dbf files using ArcPy?

I have 490 consecutive daily rainfall shapefiles/.dbf files in a single directory. Each consists of a uniform even-spaced grid of 220 points having uniform pointIDs, number of records, field names and ...
21
votes
6answers
65k views

Convert shapefile to CSV including attributes AND geometry?

I have a shapefile with 60k+ entries, all of which are polygons with corresponding attributes (acreage totals, landowner names, tax ID #s, etc.). What I ultimately need is a CSV file with all of ...
1
vote
1answer
4k views

How to generate shapefile from Excel or CSV files? [duplicate]

Possible Duplicate: How can I convert an excel file with x, y columns to a shapefile? Probably this could be an easy question for most of the people. But I would like to know the way to generate ...
6
votes
1answer
3k views

Excel object does not display more than 19 fields in ArcMap 10

I have an A0 map. I want to put a table underneath it. I want to insert an Excel object as the table. When I do this, the size of the table is 19 fields/columns. I cannot increase this number of ...
4
votes
4answers
5k views

Using a list of geographic locations, and determining the X closest locations to a user-defined location

I've got a list of geographical locations in an Excel spreadsheet. I want users to be able to search for a user-defined location, and then have the X number of closest locations from the list pulled ...
0
votes
2answers
3k views

How to import data from excel and associate it with individual shapes?

New user on ArcMap - Working with shapefiles... Question: the shapefile I am working on, a polygon is a plot of land, each plot of land has a history of owners. I am currently having to copy/paste ...
4
votes
4answers
907 views

update spatial data from excel to ms-sql server 2008

I have 1000's of data with 50's of column. It is point data. The data is in MS-SQL server.Now each day I need to load 100's of data similar in structure. How can I achieve it ? I tried to append ...
4
votes
2answers
3k views

VBA functions use in ArcGIS Field Calculator

Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or ...
0
votes
1answer
2k views

How to dynamically connect Excel data sources to MapInfo?

How to connect Excel(2010) with Mapinfo(10.0)? I saw that Excel can be connected using Excel as Data Source but my Data Source is already MS-SQL. Actually I would like to reflect any changes in excel ...
8
votes
2answers
1k views

How can I find the median column in a database?

I have data on period of construction for dwellings in dissemination areas. I have transferred this data to my study areas and would like to determine the median period of construction for each study ...
9
votes
7answers
61k views

Joining Excel table to shapefile in ArcMap?

I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...
3
votes
1answer
162 views

Can the Reporting Tool in ArcMap connect to Auxiliary data, like Excel tables?

Is it possible in ArcMap 10, using the reporting tool, to connect a report to non-spatial data, like from Excel or Access tables?
22
votes
3answers
3k views

Running Python Script when opening MXD?

Can anyone tell me how to accomplish this? I want a Python script to run on opening the MXD which would pull an excel worksheet into a GDB and refresh the map. I only want this to happen in this ...
1
vote
1answer
17k views

saving .xls as .dbf…at a dead end [duplicate]

Possible Duplicate: DBF creation and manipulation without excel 2003 Hi - I'm trying to convert an excel file to a shapefile in arview 3.3. using suggestions by Bill Huber (on the ESRI forums ...
10
votes
5answers
59k views

Exporting table from ArcGIS Desktop to Excel file?

Is there a way to export a table with selected records to an Excel spreadsheet? I was trying to export just to .txt file but ArcGIS gives me an error message. An error occurred exporting the table ...
12
votes
13answers
18k views

DBF creation and manipulation without excel 2003

My company just upgraded to Office 2007 and now I am no longer able to easily manipulate and create dbf's. I do not understand MS's decision by removing this capability but alas there is no use ...
2
votes
1answer
6k views

how can i convert an excel table to a shapefile with correct scale in arcmap?

i know that there is already one similar question to this one but my problem is different and none of the provided answers did resolve my problem. i've an excel table with some rows and in each row ...
5
votes
1answer
1k views

Converting ArcGIS topology rules file (*.rul) to *.txt, *.csv or *.xls for reviewing?

Has anyone converted ESRI's topology rules file (.rul) into another format? I built a complex topology rules set and would like to QC it in something easier to read and work with than ArcCatalog. ...
2
votes
2answers
513 views

Join Issue with Attribute Table

I am trying to use the tool to make the join a Mineral Database (excel) with my attribute table. When I check the attribute table, it shows up as "NULL". Why does it causing that and what did I do ...
10
votes
2answers
602 views

Data-type detection in ArcGIS table loading

When adding tables layers from Excel files, ArcGIS attempts to guess the data-types: Microsoft Excel does not enforce field types for values during data entry like standard databases do. ...
26
votes
9answers
18k views

How can I convert an excel file with x, y columns to a shapefile?

How can I convert an excel file with x, y columns to a point shapefile? There are some somewhat optional requirements in addition to the correct creation of a shapefile: Column types (as per Excel's ...

1
7 8 9 10
11