topic Re: Trouble Creating XY Point Feature From Imported Table in ArcGIS Pro Questions

Trouble Creating XY Point Feature From Imported Table

BRobbins — Thu, 04 Jan 2024 22:08:33 GMT

Hi all,

I've been encountering an issue preventing me from creating an X-Y Point features from an imported .xlsx table.

Using ArcGIS Pro 3.2.1 I've imported a .xlsx file as a standalone table into my project and am able to successfully open it and confirm that all the expected is there.

My problem has arisen when I attempt to create points from the table using the "XY to Point" geoprocessing tool. The Geoprocessing tab on the right side of the project window only seems to recognize one column from my table (AutoNumberID) and none of the other fields.

*Note: The coordinate system shown in the Geoprocessing tab (GCS_WGS_1984) is simply the default. I normally switch it to the project's PCS (NAD 1983 UTM Zone 10N) but didn't go back and retake the screen capture.

I've tried converting the table to .csv files and uploading those and creating new, abbreviated, tables with only the two Northing and Easting columns, but I encounter the same problem.

Frankly, at this point, I'm pretty stumped.

Any thoughts or suggestions?

Re: Trouble Creating XY Point Feature From Imported Table

DanPatterson — Thu, 04 Jan 2024 22:19:02 GMT

Without being able to see what the coordinates are,...

if they are left justified, then it is text

Re: Trouble Creating XY Point Feature From Imported Table

BRobbins — Thu, 04 Jan 2024 22:41:15 GMT

Some examples of coordinates in the table would be

214455.096 (COORD_NORTH column), 661601.852 (COORD_EAST column)

and

207013.59 (COORD_NORTH column), 692608.46 (COORD_EAST column).

Re: Trouble Creating XY Point Feature From Imported Table

Faiez — Thu, 04 Jan 2024 23:42:37 GMT

Hi!

Create points from a table

Best,

Faiez

Re: Trouble Creating XY Point Feature From Imported Table

DanPatterson — Fri, 05 Jan 2024 00:54:40 GMT

If the numbers in the table are right justified, then they are numbers and not a text representation of numbers

Re: Trouble Creating XY Point Feature From Imported Table

Faiez — Fri, 05 Jan 2024 08:11:53 GMT

Hi!

Field names should not contain spaces.

Best,

Faiez

Re: Trouble Creating XY Point Feature From Imported Table

BRobbins — Mon, 08 Jan 2024 17:05:07 GMT

Ah! Good catch. I don't believe it was my original problem, but it was worth correcting.

Re: Trouble Creating XY Point Feature From Imported Table

Faiez — Mon, 08 Jan 2024 17:11:48 GMT

Hi!

Good luck.

Best,

Faiez

Re: Trouble Creating XY Point Feature From Imported Table

BRobbins — Mon, 08 Jan 2024 17:15:41 GMT

I was able to create the XY Point feature after converting the Excel file to .csv, so initial issue solved; but I'm still unsure of why it didn't initially work with the .xlsx file.

It was an Excel Workbook, but it only had one sheet, and even if it had more, I've had similar files work in the past....

Re: Trouble Creating XY Point Feature From Imported Table

BRobbins — Mon, 08 Jan 2024 17:22:11 GMT

I experimented with changing the cell justifications as well as formatting them all as both Text and General, to no avail.

The issue was resolved by converting the file to .csv, but I'm still not sure why the initial .xlsx file wouldn't work.

Re: Trouble Creating XY Point Feature From Imported Table

Faiez — Mon, 08 Jan 2024 19:37:30 GMT

Hi!

1. In order to add data via XY coordinates, it should be save as a CSV.

2. If your excel coordinates does not match your map coordinates, it will not works, so you have to change the map coordinates based on your excel coordinates Lat, Long, an example, WGS 1984.

3, in the X row you have to put long, and in Y row you have put lat.

4. As I mentioned before, field names must not contain spaces.

Best,

Faiez

Re: Trouble Creating XY Point Feature From Imported Table

JoannaWhittier — Tue, 09 Jan 2024 14:06:11 GMT

As DanPatterson suggested, it may be that your fields in the excel table are still not numeric. General format doesn't always work. Whenever I have had this issue, I had to format the XY fields as numeric. Or just do as you did and convert to .csv.