Changes

Export from ArcGIS to Excel

217 bytes added, 18:55, 12 October 2014

no edit summary

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 Excelwhich 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]]

</div>

<br/>

# Open the Attribute table in ArcMap.

[[Image:UTF 16 attr table.png|400px]]

<div >

</div>

<li> Click on the Table ~~icon~~ button and choose ''Select All'' in the drop-down menu . <br/><br/>

[[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 drop-down menu.

<li> Paste into an Excel file <br/>

[[Image:UTF 16 Excel.png|400]]

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits