Missing field in csv

7905
13
Jump to solution
10-13-2015 04:23 PM
TinaGrant
New Contributor III

I have a table saved to a .csv in LibreOffice. When I add the table to ArcMap, the last field is missing. The whole column just...gone. Suggestions?

0 Kudos
13 Replies
TinaGrant
New Contributor III

Nothing fancy here, just integers and text.

Capture.PNG

0 Kudos
RebeccaStrauch__GISP
MVP Emeritus

You can't copy it to an xls, but do you have any other options?  .dbf or a true .csv ? 

0 Kudos
TinaGrant
New Contributor III

And there it is...I opened and saved the file as a .csv with Notepad++. Added it to the map, and the missing column appeared! Thanks for the help

NeilCurri1
New Contributor III

I was having this maddening problem as well and did the same workaround. Exported CSV from MS Access. Excel wouldn't see this column. ArcMap wouldn't see this column. Finally, I opened up the exported CSV in Notepad and saved it as a CSV again from Notepad with another file name and ArcMap saw my missing column.