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. | ||
[[Image:UTF 16 dbf.png|400]] | [[Image:UTF 16 dbf.png|400]] | ||
<div > | <div > | ||
| − | '' | + | ''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:UTF 16 attr table.png|400px]] | [[Image:UTF 16 attr table.png|400px]] | ||
<div > | <div > | ||
| − | '' | + | ''In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK'' |
</div> | </div> | ||
| − | + | <ol start="2"> | |
| + | <li> Click on the Table icon and choose ''Select All'' in the 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> Paste into an Excel file <br/> | |
| − | |||
| − | |||
| − | |||
[[Image:UTF 16 Excel.png|400]] | [[Image:UTF 16 Excel.png|400]] | ||
<div > | <div > | ||
Revision as of 16:51, 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.
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 icon and choose Select All in the menu
- Hold down Shift, right-click on the first row's grab handle and choose Copy Selected in the menu
- Paste into an Excel file
How the final result looks like
