Difference between revisions of "Export from ArcGIS to Excel"
From IMSMA Wiki
| Line 19: | Line 19: | ||
# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' 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 | # Paste into an Excel file | ||
| + | [[Image:xxx3.png|400]] | ||
| + | <div > | ||
| + | ''How the final result looks like'' | ||
| + | </div> | ||
| + | |||
{{NavBox Technical Notes}} | {{NavBox Technical Notes}} | ||
[[Category:NAA]] | [[Category:NAA]] | ||
Revision as of 14:50, 12 October 2014
| Images missing |
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.
How the dbf-file looks like
- Open the Attribute table in ArcMap
How the Attribute table in ArcMap 10.1 looks like
- Click on the Table icon and choose Select All in the menu
Table button and the grab handle
- 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
