topic Re: Adding a CSV Table in ArcPro in ArcGIS Pro Questions

Adding a CSV Table in ArcPro

KrishnaTiwari — Mon, 06 Jun 2022 12:38:56 GMT

Hello,

I'm trying to view a CSV table in ArcPro and receive the following error message:

Error: A column was specified that does not exist

Does this mean the table needs to be re-formatted or edited in some way?

Re: Adding a CSV Table in ArcPro

MarcelSt-Germain — Mon, 06 Jun 2022 13:38:05 GMT

Hi,

Do all column have an header? Sometime you can also have problem with divider in number between English "." and metric ",". If you can show a sample of you data.

Re: Adding a CSV Table in ArcPro

RobertBorchert — Mon, 06 Jun 2022 15:43:05 GMT

Yes, open the .csv in Excel and make sure all columns have headers. And headers that are appropriate.

Best practice for .csv headers are with no special characters other than Underscore "_"

And they should not start with numbers. Though with newer version they can be added. I have a .csv provided to me for Arc Flash data that contains spaces and the @ symbol. However, I immediately load them into an appropriate table

Re: Adding a CSV Table in ArcPro

KrishnaTiwari — Mon, 06 Jun 2022 19:19:50 GMT

Hello RobertBorchet,

Thank you for the help. I just needed to reformat the csv sheet.

Re: Adding a CSV Table in ArcPro

KrishnaTiwari — Mon, 06 Jun 2022 19:20:41 GMT

Hello MarcelSt-Germain,

Thanks for the information. The csv sheet just needed to be properly formatted. I appreciate the help!

Re: Adding a CSV Table in ArcPro

RobertBorchert — Mon, 06 Jun 2022 20:00:09 GMT

I have had some minor horror stories with spreadsheets and files that people send to me in the attempts to call it legitimate data.

Column headers that are sentences

Merges cells

Fancy Excel formatting

I tell people plain and simple with zero formatting. I had one guy, an intern, I simply sent it back to him over and over telling him what was wrong. Finally his supervisor called to ask why I was giving his intern a hard time. I showed him what was going on. Next version was what I asked for the first time.

Seems a lot of non GIS or Engineer types cannot not make a spreadsheet with lots of formatting.

"But this is the way I want it to look in the GIS"