Uploading multiple CSV files from folder using code

OriHarash

I'm trying to read multiple CSV files to my arcGIS pro project.

The csv files consist x,y coordinated so I would like to upload them to the project and show them on the map, as happends when I upload the CSV file through the 'MAP'-->'Add Data'-->'X,Y Point Data'.

I do this action very often so I would like to automate it.

I'll be happy to get some guidance or a script to do so.

 

Tnx a lot

JohannesLindner

When you do it manually, you open the tool XY Table To Point (Data Management)—ArcGIS Pro | Documentation.

To automate the process, you could use a script like this:

csv_files = [
    "H:/test.csv",
    # etc.
    ]

import os
wkid = 25832 # the wkid of your coordinate system
x = "X"
y = "Y"
z = None
gdb = None  # path to the database where you want to save the feature class. None: default gdb of your project
for csv in csv_files:
    print(csv)
    name = os.path.basename(csv).split(".")[0]
    if gdb is not None:
        name = os.path.join(gdb, name)
    arcpy.management.XYTableToPoint(csv, name, x, y, z, wkid)