[GIS] Adding CSV files to ArcMap

arcgis-desktopcsv

I need to use the Add Join tool but before I can do that I must get the csv file into ArcMap. Yet when I go to ArcCatalog to try to add the csv it is not there. Also I tried using simply the add data button but again the csv is absent. So how can i get the csv file to show up in ArcCatalog so I can begin the process with the Add Join tool?

Best Answer

Couple of things to try: Open the file in Excel; save a copy as a CSV. Open the file in notepad; save a copy as a CSV. Open the file in Excel; save a copy as a dbf. Open the file in notepad; save a copy as a dbf. Create a file geodatabase; import the file into the geodatabase, then add it to the map from the geodatabase.

Related Solutions

[GIS] Cannot read CSV-file from ArcMap

By default ArcGIS reads csv files as comma delimited, but sometimes it's not the case, probably due to local language settings. You can force the way ArcGIS reads your csv file using the schema.ini file. Normally, there is a schema.ini file in the same location as your csv file, and its content should look like this if you open it in Notepad:

[myFile.csv]
Format=Delimited(,)

It you don't find the schema.ini file or if its content is different, create it (create a text file named schema and change its extension) or modify it so that its content is the same as the example above.

More info about how ArcGIS handles ascii files here: Adding an ASCII or text file table.

[GIS] DBMS table not found error adding PostGIS layer in ArcMap

I found the answer: my postgis layers had capitals in their names. I changed it and now ArcMap can load them into the document.

Best Answer

Related Solutions

[GIS] Cannot read CSV-file from ArcMap

[GIS] DBMS table not found error adding PostGIS layer in ArcMap

Related Question