Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to get a list of street names and ranges for a specific area of my map. My intention is to make a street index of sorts from this data. I would like to export this data into excel if possible. Does anyone know if this can be done? If so, I would appreciate any help you can give me.

I'm using ArcGIS 9.3

Thank you.

share|improve this question
add comment

2 Answers

Did you open the attribute table (right-click on layer and click the Open Attribute Table menu-item) and then copy/paste the selected records?

The first part of this answer takes care of the copy/paste steps: Export table from ArcGis to Excel file

You can also export the selected records to text or dbf and open in excel.

share|improve this answer
    
Thanks you for your answer and help. –  Mike Mitchell Dec 29 '10 at 19:25
add comment

There are a number of tools/scripts available that will export to Excel directly from ArcMap. http://arcscripts.esri.com/details.asp?dbid=13194

Also, assuming you have Microsoft Office installed, the following method has worked for me.

  1. Create empty personal geodatabase (mdb)
  2. Export selected features into this new, empty personal geodatabase.
  3. Open up this personal geodatabase in MS Access, and the feature class created in step 2 should appear as a regular table. You should be able to export this table directly to Excel, or any number of other formats. You'll probably want to delete the geometry(SHAPE) column.
share|improve this answer
    
ahhh! Of course! Right in front of me. Thank you. –  Mike Mitchell Dec 29 '10 at 19:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.