nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't get XY Table to Point tool to pull X Y fields in

AvaFarouche

Hi, all,

I added a table to my Pro map (version 3.5.2) and I can't get the XY Table to Point tool to recognize the X and Y Fields. It just won't pull them in so I can run the tool:

There are plain Lat Long fields. I made sure they're formatted to numeric w/6 decimal places. The field names are just Lat and Long. None of the field names have spaces or special characters or even numbers in them. All of the field headers/ names are formatted as text. I restarted Pro and then restarted my computer.

I do this all the time and I can't figure out why it's not working. I did download the original table as a giant csv, which I opened in Access, selected out the entries I was interested in, and copied those into Excel to create my table. Is there something residual from that that's messing me up?

Thanks for any insights!!

Finde mehr Beiträge mit dem Tag

Desktop

Accepted answers

Ayan Palit

@AvaFarouche Looks like you are directly using the Excel Table. Does your other processes work fine with data in Excel - there are specific instructions to Work with Microsoft Excel files in ArcGIS Pro

If the required drivers are installed, try using Excel to Table and use the GDB table as input to XY Table to Point tool.

All comments

DanPatterson

show a couple of rows of the table, perhaps, they ended up getting formatted as text (left_justified)

Ayan Palit

If the required drivers are installed, try using Excel to Table and use the GDB table as input to XY Table to Point tool.

DanPatterson

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

good catch if it is an excel file since a delimited file is expected

AvaFarouche

Hmm.. they are left justified. But they are also formatted as numeric. I experimented w/changing justification, just in case but it didn't change anything. Thanks for the suggestion!

AvaFarouche

Thanks for the tip!

I use Excel all the time! I guess I have gotten sloppy. I tried Excel to Table and that didn't fix the problem, but then I just saved my original spreadsheet to a csv and that worked! Thank you!!

AvaFarouche

Yes, that was the problem. I use Excel all the time!! I have gotten sloppy with that, but it generally works. I saved it to csv and that solved the problem. Thanks for chiming in!

DanPatterson

you can't just change the justification.

Go back to excel, format those fields as numeric and save the files as a *.csv, or do as Ayan says and use the Excel to Table tool

If you can't do it in excel, then you will have to add 2 new fields to your table and use the field calculator to convert the Long and lat fields to numeric (eg make a Long_ and Lat_ field as type double, then use the field calculator to convert from text to numeric Long_ = float(Long) etc

AvaFarouche

Well, they were formatted as numeric all along. But saving as csv solved the problem. Thanks for the tips!

RTPL_AU

Hi @AvaFarouche

Excel can sometimes create a file where the field is seen as text by Pro no matter what you do.
I find that rather than wasting time to 'fix' it in Excel or Pro, the easiest is to export the Excel sheet to CSV, inspect that in a decent text editor for any weird non-printing characters, then use the CSV to get data into Pro.

This happens to me a few times a year, and often with data I get from somewhere else.

Good luck.

AvaFarouche

Ah, good to know. Thanks! I have been using excel for years and it generally always works. I kind of knew I was being sloppy but it did the trick, and I use excel most often for formatting and prepping data that I download in table format from other sources. Good to know there's an easy fix. And good to know I should inspect in a text editor after - because I did not do that! Thanks!

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.