Export attribute table (feature class) to text file in batch?

Question

What would be the most efficient way to export attribute tables from multiple feature class files stored in a file geodatabase? Export to .txt or .csv. Is there any sort of batch process? Or python script?

I have hundreds of files within this geodatabase and really need to automate this process.

Take a look at: http://gis.stackexchange.com/a/42445/8104 – Aaron Apr 08 '14 at 13:49 — Aaron, Apr 08 '14 at 13:49

score 4 · Accepted Answer · answered Apr 08 '14 at 13:44

With Python, you can use arcpy.ListDatasets to create an object to loop through all the features in your file geodatabase, setting the workspace to the geodatabase first. Then, for each feature use arcpy.MakeTableView_management to create a table view that can then be used by arcpy.TableToExcel_conversion to export the tables to Excel. All of these documentation pages should provide you with enough code snippets to get you there.

alaybourn · Answer 2 · 2017-05-22T15:12:00.420

3

I just came across CopyRows_management() to convert shapefile attribute tables to csv. For example:

import arcpy
my_shp = 'lat_lon.shp'
out_csv = 'points.csv'

arcpy.CopyRows_management(my_shp, out_csv)

edited May 22 '17 at 15:12

answered May 22 '17 at 14:26

alaybourn

430
4
11

1

Please, could you elaborate this answer? It could help other users in the future. – mgri May 22 '17 at 15:04
1

A good answer should include not only what to use, but also how to use it. Please [edit] your answer to expand on how to use the copyrows_management(). – Midavalo May 22 '17 at 15:09

Export attribute table (feature class) to text file in batch?

2 Answers2

Linked