Easily Export ArcGIS Attribute Table to CSV

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 go through multiple steps exporting to 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 making sure to leave off the ‘.txt’ from the end of the name.
  • 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.

9 comments on “Easily Export ArcGIS Attribute Table to CSV

    1. The method I outlined above works on a single table. There are a couple
      of tools you can use to export to CSV that can be opened in
      batch mode. The first is the Export Feature Attribute to ASCII tool. You
      can read about how to use it on the North River Geographic site.
      The other tool is new at ArcGIS version 10.2 and is called the
      Table To Excel tool in the conversion toolbox. This second one exports to .xsl format not .csv though. You could also script these two tools if you are handy with Python.

  1. Any ideas on scripting this Python or implementing it in model builder? Unfortunately the right click > data > export functionality does not seem to be accessible from a tool or in the arcpy module.

    One other note, there is a tool to export a table to a .csv file in the Highways extension (if you have the license):

    http://resources.arcgis.com/en/help/main/10.2/index.html#//02240000000s000000

    Why ESRI would bury this tool behind the highways extension?? Doesn’t seem to really have functionality exclusive to ‘maintaining highway data with linear referencing systems’

Leave a Reply

Your email address will not be published. Required fields are marked *