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; } } }

problem with csv to feature points

matu89

hey,

i have an excel file with coordinates and Z values.

i saved it to CSV Comma Delimited and when i run X Y to point tool , the attribute table in the feature layer that been created is EMPTY.

i tried to save the excel sheet a few more times in the right CSV format but the table is still empty..

that i do wrong ?

thanks.

Find more posts tagged with

Analysis

Accepted answers

All comments

matu89

Solved: i change the coordinates system in XY tool and it worked .

now i can see the feature points in my map.

thanks to everyone who helped.

matu89

yes , a feature has been created but without information

as u can see here :

also i removed the brackets from the H filed as u can see .

David_Brooks

@matu89 and are there any features created when you run the tool? can you show screengrabs of the feature attribute table and point geometries in the data frame?

Have you tried removing the square brackets from the Z field? I can't recall if this is a special character that might screw things up.

matu89

here is how it show in the CSV file :

here is how it show in Arcgis :

these are the steps i did :

1. select all the rows in the CSV file

2. use XY point tool the select the column H [m] to be the Z feild

3. clicked Run

David_Brooks

@matu89 what are the names of the attribute fields. I'm guessing you have successfully created points in the location you want them? Do you have illegal characters in your other columns?

danretired

A screen grab of the first few lines of the table with the headers would help eliminate the guessing as to possible errrs

DavidPike

Common issues are:

X and Y fields mixed-up

Incorrect coordinate system specified, e.g. using a local coordinate system for lat long values.

do you have a sample of the csv structure and also your arguments/inputs for the xy table to point tool?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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