Difference between revisions of "Export from ArcGIS to Excel"
From IMSMA Wiki
(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...") |
|||
| Line 1: | Line 1: | ||
| − | {{Under construction| | + | {{Under construction| 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. | 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| | + | [[Image:UTF 16 dbf.png|400]] |
| − | <div | + | <div > |
''How the dbf-file looks like'' | ''How the dbf-file looks like'' | ||
</div> | </div> | ||
# Open the Attribute table in ArcMap | # Open the Attribute table in ArcMap | ||
| − | [[Image:xxx1.png|400px | + | [[Image:xxx1.png|400px]] |
| − | <div | + | <div > |
''How the Attribute table in ArcMap 10.1 looks like'' | ''How the Attribute table in ArcMap 10.1 looks like'' | ||
</div> | </div> | ||
# Click on the Table icon and choose ''Select All'' in the menu | # Click on the Table icon and choose ''Select All'' in the menu | ||
| − | [[Image:xxx2.png|400px | + | [[Image:xxx2.png|400px]] |
| − | <div | + | <div> |
''Table button and the grab handle'' | ''Table button and the grab handle'' | ||
</div> | </div> | ||
Revision as of 15:17, 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
