Exporting list of Feature Classes to CSV using ArcPy and Python?

Question

I am successfully using the follow script

import arcpy
from arcpy import env
import os
env.workspace = ("WORKSPACE")
fcList = arcpy.ListFeatureClasses()
print fcList

to export feature class names from a workspace.

I'd like to export the results to a CSV file (creating a simple one column list of Feature Class names); I've looked into the Python help guide but am struggling with the syntax and where to place the csv.writer and import csv functions.

How do I get the results to be written to a csv file?

Answer 1

Why not something like this:

import arcpy
from arcpy import env
import csv
import os
env.workspace = ("WORKSPACE")
fcList = arcpy.ListFeatureClasses()
with open('codes.csv', 'wb') as f:
     writer = csv.writer(f)
     writer.writerows(fcList)

Answer 2

It should look something like this:

import csv, arcpy, os
from arcpy import env

env.workspace = "C:/temp/mygeo.gdb"

    with open('C:\\temp\\test.csv', 'wb') as out_file:
       csv_writer = csv.writer(out_file, delimiter=',')
       csv_writer.writerow(('Name'))

       fclist = arcpy.ListFeatureClasses():
          for f in fclist:
             csv_writer.writerow(f)

Answer 3

I would suggest taking a look at the scripts referenced in Working with Microsoft Excel in ArcGIS Desktop and the updated ArcGIS 10 script referenced in this ESRI forum post.

Both scripts contain "fallback" methods (python code) for exporting to CSV.

Answer 4

you can achieve this with this way:

# Your code

import os
import arcpy
from arcpy import env 


env.workspace = ("WORKSPACE")
fcList = arcpy.ListFeatureClasses()
#print fcList

# Open a new file 
f = open("C:\Temp\newFile.txt", 'w')

# Loop feature class
for fc in fcList:
    f.write(str(row.getValue("id")) + ", " + str(row.getValue("name")) + ", " + 
           str(row.getValue("others")) + "\n")

f.close()

i hope it helps you...

Answer 5

import arcpy
from arcpy import env
import csv
import os
arcpy.env.workspace = r"C:\Temp\Geodatabase.gdb"
fcList = arcpy.ListFeatureClasses()
with open('FeatureClassList.csv', 'wb') as f:
    var = csv.writer(f)
    for row in fcList:
        var.writerow([row])
print "Done"

I had some issues with the other solutions offered here and was able to address them with my above code. I wanted each feature class to be listed in a row not as a column so I had to make up loop for each row.