How To Export A Feature Class Attribute Table From ArcGIS Pro

Several years ago I wrote about how to export an ArcGIS feature’s attribute table as a CSV file. ESRI didn’t make this extremely intuitive. Since that time I’ve moved into using ArcGIS Pro and thought I’d post about doing the same thing in this application.

It’s even easier to export table records in ArcGIS Pro. You can select a subset of records in your attribute table if you aren’t trying to export the entire thing. Then, right-click on the feature and click Data -> Export Table. Alternatively, click the feature layer “Data” tab and select Export Table. A geoprocessing dialog table will open with a Copy Rows task. 

Under the Output Table parameter enter a name for your table with a .csv extention. You can also choose to save your table as a .dbf, in a geodatabase or as a .txt file(comma delimited).

Incidently, if you try to save your table outside of a database but without an extention, the tool will default to exporting as a .dbf file.

This process isn’t difficult but it might throw some people off since you can’t select your extension in any dialog dropdown. You have to type it out yourself.

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 directly from the attribute table 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 use an ArcToolbox tool like the Export Feature Attributes to ASCII Tool or the Table to Excel conversion tool. But with each of these you have to open special tools or go through multiple steps to convert.

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 or if you specify .csv, then your output will be a .csv file by default.