Export from ArcGIS to Excel

From IMSMA Wiki
Jump to: navigation, search

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 which in ArcMap 9.3.1 was possible to do with keyboard shortcuts like Ctrl + A. In ArcMap 10.1 these keyboard shortcuts do not work in the Attribute table and therefore the menus must be used.

UTF 16 dbf.png

In the dbf-file the non-Latin characters are not readable

  1. Open the Attribute table in ArcMap.

UTF 16 attr table.png

In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK

  1. Click on the Table button and choose Select All in the drop-down menu.

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

    How the final result looks like