Hi everyone, I have a .csv file with about 500,000 records with lat/long coordinates in WGS 1984. I am unable to convert the table to a point feature class without getting Warning 040401 - Null geometry ignored.
I have gone through each column of the table to ensure there were no weird values. When I used an earlier, smaller subset version of this same data, it worked fine, so I don't know what is wrong with this version. I tried copying the data and pasting into a new spreadsheet, which didn't make a difference.
I checked the records that the tool is giving the warning about - they look wonky in the attribute table but fine in the original csv. Where is the disconnect?
Solved! Go to Solution.
I might have had this issue a while back and had to convert the CSV to an XLSX format due to a record number limitation. It might be worth trying to change the file format.
I might have had this issue a while back and had to convert the CSV to an XLSX format due to a record number limitation. It might be worth trying to change the file format.
Thanks, the XLSX format worked! So weird, I had always thought a csv was the way to go!
I'd open it up in notepad++ (Menu View → Show Symbol → *Show All Characters`)
and check for any newlines (\n) from any word wrapping or anything else which looks a bit off. I would think the ObjectID's would be close to the CSV line numbers in Notepadd++ to speed up the manual sanity check.
Thanks for the reply! I didn't end up needing to try this because switching from csv to xlsx format worked out!