A quick method for writing out some rows and a subset of columns from a feature class to a CSV. This is particularly well-suited for when you're working in ArcGIS Desktop or Pro and need to quickly export some rows and a subset of columns from a vect

arcgis_to_csv.py

import arcpy
import csv

with open('output.csv', 'w', newline = '') as csvfile:
    writer = csv.writer(csvfile) # Create writer object
    writer.writerow(['Column 1', 'Column 2', 'Column 3', 'Column 4']) # Define the header row
    with arcpy.da.SearchCursor('input_layer', ['Field1', 'Field2', 'Field3', 'Field4']) as cursor: # Define cursor object
        for row in cursor:
            writer.writerow([row[0], row[1], row[2], row[3]]) # Write values from each item in cursor to csv