Export from ArcGIS to Excel

From IMSMA Wiki
Revision as of 16:45, 12 October 2014 by Alnaucler (talk | contribs)
Jump to: navigation, search
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

UTF 16 attr table.png

How the Attribute table in ArcMap 10.1 looks like

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

Table grab buttons.png

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