Difference between revisions of "Export from ArcGIS to Excel"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{Under construction| Text should be placed here}} When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format d...")
 
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{{Under construction| Text should be placed here}}
+
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.
−
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.
 
  
−
[[Image:UTF 16 dbf.png|400px|center]]
+
[[Image:UTF 16 dbf.png|350px]]
−
<div align="center">
+
<div >
−
''How the dbf-file looks like''
+
''In the dbf-file the non-Latin characters are not readable''
 
</div>
 
</div>
−
 
+
<br/>
−
# Open the Attribute table in ArcMap
+
# Open the Attribute table in ArcMap.
−
[[Image:xxx1.png|400px|center]]
+
[[Image:UTF 16 attr table.png|350px]]
−
<div align="center">
+
<div >
−
''How the Attribute table in ArcMap 10.1 looks like''
+
''In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK''
 
</div>
 
</div>
−
# Click on the Table icon and choose ''Select All'' in the menu
+
<ol start="2">
−
[[Image:xxx2.png|400px|center]]
+
<li> Click on the Table button and choose ''Select All'' in the drop-down menu. <br/><br/>
−
<div align="center">
+
[[Image:Table grab buttons.png|400px]]
−
''Table button and the grab handle''
+
<li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the drop-down menu.
 +
<li> Paste into an Excel file <br/>
 +
[[Image:UTF 16 Excel.png|400]]
 +
<div >
 +
''How the final result looks like''
 
</div>
 
</div>
−
# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
+
</ol>
−
# Paste into an Excel file
+
 
 
{{NavBox Technical Notes}}
 
{{NavBox Technical Notes}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 14:59, 17 October 2014

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
    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=17190"