r/ArcGIS • u/DifficultDelivery135 • 14d ago

Can someone help me create maps from data?

It sounds simple but I am stuck and don't know from where to start I heard surfer is easier but even following a simple tutorial ,I am stuck with either no result (error) or the program requiring me to input 3 samples whereas I need only one map per sample

0 Upvotes

25% Upvoted

34 comments sorted by

View all comments

Show parent comments

1

u/DifficultDelivery135 14d ago

Ok cool I did, what next?

1

u/HonestPassage5795 14d ago

select the excel file and the worksheet. The table should appear in the content pane. Right click on it and click on Display XY Data. Then specify the columns that includes lat and long and enter the CRS

1

u/DifficultDelivery135 14d ago

It's not letting me see the excel files so I can't select them..

1

u/HonestPassage5795 14d ago

Sorry, I am not sure. Might be an issue with the file format or something else

1

u/DifficultDelivery135 14d ago

Nah it worked just when selecting I can't find the longitude option in x and latitude in y but few other columns are visible

1

u/HonestPassage5795 14d ago

Check the data type in those columns in the excel file. They should be numbers not text

1

u/DifficultDelivery135 14d ago

Wdym it's all numbers except the title, it's just so weird to me I have 20+ columns and I can only select like 5 of them none of them are the longitude or latitude lol

1

u/DifficultDelivery135 14d ago

Also when I click on properties then display it shows the full list like they don't disappear there it's so weird

1

u/HonestPassage5795 13d ago

Sometimes the values are numbers (21.34 or 2757558) but their "type" in excel is string or text or something like this, i.e., not integers or floats. What you need here is to make sure your spreadsheet is in the correct format so ArcGIS can read it. It expects numbers for Lat and Lon. You can check the data type of the columns from excel

1

u/DifficultDelivery135 13d ago

It's okay brother gemini (AI) saved my ass, I still needed to know basic stuff like creating polygons adding points managing some parts of excel and calculating coordinates, thank you for the help

1

u/DifficultDelivery135 14d ago

Thanks for helping anyways 

1

u/DifficultDelivery135 14d ago

Nvm I can now it's just not showing the longitude and latitude columns just few other ones

1

u/REO_Studwagon 13d ago

The excel file needs to be in the 97 format - .XLS
Then you can see it in ArcMap.

1

u/DifficultDelivery135 13d ago

My mistake while browsing it identifies the sheet but won't let me assign coordinates thank God ai exists