topic XY table to point warning 040401 in ArcGIS Pro Questions

XY table to point warning 040401

KaraG — Tue, 14 Jan 2025 20:41:45 GMT

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?

Re: XY table to point warning 040401

Brian_McLeer — Tue, 14 Jan 2025 20:47:57 GMT

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.

Re: XY table to point warning 040401

DavidPike — Tue, 14 Jan 2025 20:48:03 GMT

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.

Re: XY table to point warning 040401

KaraG — Tue, 14 Jan 2025 23:23:14 GMT

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

Re: XY table to point warning 040401

KaraG — Tue, 14 Jan 2025 23:24:04 GMT

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