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.

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 tried saving as a text file but to no avail.

share|improve this question
1  
see this gis.stackexchange.com/questions/26227/… –  iRfAn Jun 27 '12 at 11:12
add comment

5 Answers

You can still do this, although Excel has made it more difficult by breaking the loading sequence for associated .dbf's.

Export normally.

Open Excel on its own.

Go to File -> Open, select 'All Files', and find the .dbf.

share|improve this answer
add comment

XTools Pro has a Export to Excel option that exists in the free tools available even after the 14-day trial period. I've been using that for years. You can export the attributes to Excel, or if you have Excel installed, you can just directly open up the attributes in Excel.

share|improve this answer
add comment

You can also drag and drop the dbf into Excel (at least Excel 2007/2010). Sometimes easier than doing this:

Go to File -> Open, select 'All Files', and find the .dbf

share|improve this answer
add comment

A new tool in ArcGIS 10.2 has been introduced to export a table to an Excel file.

See here.

share|improve this answer
add comment

The .dbf should open without any problems in excel, however, if it's a feature class in a geodatabase you can't get to the dbf.

Option 1: If you have a license with X-Tools (maybe even the free version) you can export table to excel, which will launch the program automatically.

Option 2: Export Data outside of the geodatabase (to a shapefile) and grab the dbf just like Chris.Leeney suggested.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.