Export from ArcGIS to Excel

From IMSMA Wiki
Revision as of 15:51, 12 October 2014 by Alnaucler (talk | contribs)
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.

400

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 icon and choose Select All in the menu

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

    How the final result looks like

    Technical Notes
    FAQ
    A - E
    F - P
    Q - Z
    Known issues
    Workarounds
    Misc
    Languages
    Countries
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Export_from_ArcGIS_to_Excel&oldid=17014"