Export to CSV from Arcgis Online Shifts Cells into the Wrong Columns

631
1
06-23-2017 01:34 PM
PaulKarkoska
New Contributor II

I exported a feature layer to CSV in Arcgis Online. When I download the csv and open it I can see that many of the fields have shifted to the wrong column. I checked the pop up window in agol and the entries are in the right columns. I did notice that it happened after a comma was used in the text entries. The text after the comma was shifted to the next column and then everything after was shifted as well. How can I download a csv with out any cells shifting? 

0 Kudos
1 Reply
MicahBabinski
Occasional Contributor III

That's annoying. What if you exported to a file geodatabase and then ran the Table to Table (conversion) tool on the resulting FGDB table with the output table having a .csv extension?

I think that would do it.

Micah

0 Kudos