Difference between revisions of "Export from ArcGIS to Excel"

From IMSMA Wiki
Jump to: navigation, search
Line 19: Line 19:
 
# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
 
# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
 
# Paste into an Excel file
 
# Paste into an Excel file
 +
[[Image:xxx3.png|400]]
 +
<div >
 +
''How the final result looks like''
 +
</div>
 +
 
{{NavBox Technical Notes}}
 
{{NavBox Technical Notes}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 15:50, 12 October 2014

Ambox warning blue construction.png Images missing

When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.

400

How the dbf-file looks like

  1. Open the Attribute table in ArcMap

400px

How the Attribute table in ArcMap 10.1 looks like

  1. Click on the Table icon and choose Select All in the menu

400px

Table button and the grab handle

  1. Hold down Shift, right-click on the first row's grab handle and choose Copy Selected in the menu
  2. Paste into an Excel file

400

How the final result looks like