Select to view content in your preferred language

XY table to point warning 040401

256
4
Jump to solution
01-14-2025 12:41 PM
Labels (2)
KaraG
by
Regular Contributor

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? 

KaraG_0-1736887293749.png

 

0 Kudos
1 Solution

Accepted Solutions
Brian_McLeer
Frequent Contributor

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. 

Brian

View solution in original post

4 Replies
Brian_McLeer
Frequent Contributor

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. 

Brian
KaraG
by
Regular Contributor

Thanks, the XLSX format worked! So weird, I had always thought a csv was the way to go!

DavidPike
MVP Frequent Contributor

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.

0 Kudos
KaraG
by
Regular Contributor

Thanks for the reply! I didn't end up needing to try this because switching from csv to xlsx format worked out! 

0 Kudos