Difference between revisions of "Export from ArcGIS to Excel"
From IMSMA Wiki
| Line 1: | Line 1: | ||
| − | 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. | + | 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. |
[[Image:UTF 16 dbf.png|400]] | [[Image:UTF 16 dbf.png|400]] | ||
| Line 6: | Line 6: | ||
</div> | </div> | ||
<br/> | <br/> | ||
| − | # Open the Attribute table in ArcMap | + | # Open the Attribute table in ArcMap. |
[[Image:UTF 16 attr table.png|400px]] | [[Image:UTF 16 attr table.png|400px]] | ||
<div > | <div > | ||
| Line 12: | Line 12: | ||
</div> | </div> | ||
<ol start="2"> | <ol start="2"> | ||
| − | <li> Click on the Table | + | <li> Click on the Table button and choose ''Select All'' in the drop-down menu. <br/><br/> |
[[Image:Table grab buttons.png|400px]] | [[Image:Table grab buttons.png|400px]] | ||
| − | <li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu | + | <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/> | <li> Paste into an Excel file <br/> | ||
[[Image:UTF 16 Excel.png|400]] | [[Image:UTF 16 Excel.png|400]] | ||
Revision as of 18:55, 12 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.
In the dbf-file the non-Latin characters are not readable
- Open the Attribute table in ArcMap.
In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK
- Click on the Table button and choose Select All in the drop-down menu.
- Hold down Shift, right-click on the first row's grab handle and choose Copy Selected in the drop-down menu.
- Paste into an Excel file
How the final result looks like
