Add XY data Latitude Category empty upon re using

[EricOstrowski]

Whenever I add XY data from a .CSV file the latitude category disappears when I reopen the .CSV file after uploading more data.

Is there a reason why my latitude category disappears when I try to update my coordinates?

The latitude coordinates are present in the .CSV but the option to choose those latitude coordinates is gone.

[DanPatterson_Retired]

Check the column... the columns won't be an option if it is represented as text...it may look like a number but it may be formatted as text, and/or the column contains text or blanks

[NICOLAPEDDIS]

Dan is right, the latitude and the longitude must be formated as number, then you can easly import the csv file in arccatalog or arcmap to trasform the point text in a point feature, and add the z value if is present as formatted a number. If lat and long are not present you wont able to rappresent x, y and z data in arcmap

[EricOstrowski]

I changed both latitude and longitude columns to number format from general format.

After converting the option to select latitude was still missing.

[EricOstrowski]

I addition the file does not save the changes from general format to number format.

[EricOstrowski]

In addition to that*

[DanPatterson_Retired]

I assume you are creating this file in something like a spreadsheet, hence if the format can't be changed from general to number there is something in the columns (like spaces) or in the cells that prohibits (like saving degrees minutes and seconds in a column)...but this is conjecture until you copy and paste some of the rows in your initial question to show what you are working with.

[EricOstrowski]

OBJECTID	Address	City	Zip	State	Trap Series	Latitude	Longitude	Pos_7_17	Pos_7_23	Pos_8_4	Pos_8_5	Pos_8_7	Pos_8_10	Pos_8_13	Pos_8_19	Pos_8_26	Pos_8_28	Pos_8_31	Pos_9_08	Pos_9_09	Pos_9_10	Pos_9_15	Pos_9_16	Pos_9_17	Pos_9_18	Pos_9_28	Pos_10_1	Pos_10_8	Pos_10_13	Pos_10_21_15	Pos_11_5_15
35	Santiago Creek & Bike Path	Orange	92866	CA	ET-04	33.77677	-117.851202			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
36	21510 E Basin Ave, Walnut Drain	Orange	92866	CA	ET-04	33.79456	-117.831225			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
37	6569 S Kentucky Dr, End of Loretta	Orange	92866	CA	ET-04	33.77736	-117.824821			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
38	22151 Reneer Ave	Orange	92866	CA	ET-04	33.79639	-117.876153			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

[EricOstrowski]

Here is an example of the formatting of our rows with false addresses. We found and replaced some of the spacing issues in the columns however the problem of the latitude category disappearing still persists when we attempt to re add the xy data from the file.

[DarrenWiens2]

Probably not the issue, but your column "Trap Series" has a space in it, which may throw a monkey wrench in the gears.