A spreadsheet application by Microsoft
11
votes
8answers
5k 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 ...
9
votes
11answers
3k 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 ...
8
votes
3answers
6k views
How to convert .shp to .csv including attributes AND geometry?
I have a .shp file 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 ...
4
votes
1answer
313 views
What is the best way to connect spatial data with attributes in Excel table?
I have many attributes which are stored in an Excel table. They refer to USA counties. I need to somehow connect those attributes to polygons in some format (don't know which is the best) and ...
5
votes
3answers
26k views
Export table from ArcGis 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.
The other problem I have is with ...
3
votes
2answers
683 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 ...
3
votes
1answer
805 views
saving a dbf as xls in python
i've been let loose in the workplace to learn python to do things in Arcmap10.
so, i've learning python as i go and trying to remember the programming i have done.
where i am in this project is ...
3
votes
7answers
8k views
Having problems with joining an excel table to a 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 ...
17
votes
4answers
797 views
Run a Python Script when opening an 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 ...
7
votes
2answers
329 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. ...
2
votes
2answers
127 views
Some data Loss when Import PGDB Table from Excel
When import table from excel some data were loss. i was try to change field type but i cant solve this error. I have attached an example image to show the problem.
