For many ArcGIS users, exporting an attribute table to a .csv file or excel format file is a common part of their workflow. Unfortunately, exporting to either of these formats has never been a core functionality of ArcGIS. To overcome this you typically have had two choices: write a script using third party libraries or bgo through multiple steps exporting to something like a .txt file and converting it to .csv or .xls.
However, there is a little shortcut you can take to quickly export your data to .csv right from the attribute table.
- From the table, click Export.
- Under “Output Table” browse to the folder you want to put your .csv file in, save type as .txt and enter a name for your output.
- If the ‘.txt’ extension is present in the name the tool will output a normal text file of your data. If, however, your name does not include the ‘.txt’ extension then your output will be a .csv file by default.
This was done with Microsoft Excel installed. I don’t know what the outcome would be if you only had something like OpenOffice installed or no spreadsheet software at all. If anyone has any experience with this feel free to let everyone know in the comments.