Select to view content in your preferred language

Adding excel spreadsheet information to a map

920
5
Jump to solution
02-17-2014 05:42 AM
IvanMravlag
Emerging Contributor
All,

I am new to ArcGIS and I am trying to add information (vendor names and addresses) to a map.

I have made an excel spreadsheet with the two first columns being latitude and longitude, followed by the rest of the information. When I do this, however, the following error message pops up: "File does not seem to contain fields with point coordinates". The lat and long info I've put is in decimal format, so, from what I've read, it should be in the correct format.

The spreadsheet is saved in .csv format. Are the spaces between names an issue with the .csv formatting? How can I format my information in order to successfully upload my table?

Any help on this issue is greatly appreciated.

Thanks in advance,

Ivan
Tags (2)
0 Kudos
1 Solution

Accepted Solutions
LuciHawkins
Frequent Contributor
Hey,

This is part of a csv I used to upload data to ArcGIS.com
"OBJECTID","Park_Type","COMMENTS","Park_Address","Park_Name","X","Y"
1,"SPCL PURPOSE"," ","109 MIRACLE STRIP PKWY SW","MUNICIPAL AUDITORIUM",-86.620833,30.405421
2,"COMMUNITY","","126 JET DR NW","BMX/SKATEBOARD PARK",-86.622751,30.413969


Put the " quote marks around text values and add an "OBJECTID" field and number your points also.  It will probably work then.

Hope this helps,

Luci

View solution in original post

0 Kudos
5 Replies
TimWitt
Deactivated User
Ivan,

If you have a ArcGIS Desktop license, you can always make a shapefile out of your excel spreadsheet there and then upload the zipped shapefile to ArcGIS Online. This might be less hassle 🙂

Tim
0 Kudos
LuciHawkins
Frequent Contributor
Hi Ivan,

You should have a "Header" row in your excel spreadsheet so you can tell ArcMap which column is X and Y and they should NOT have any spaces.

X Coord  -  will fail as a column label in your Header row because of the space between X and Coord

XCoord - will be fine

Thanks,

Luci
0 Kudos
IvanMravlag
Emerging Contributor
Tim, thanks for the reply, but sadly I do not have a desktop license.

Below is a excerpt of what I have in my .csv file:

Latitude,Longitute
29.665784,-95.019373
30.458283,-91.14032
29.760193,-95.36939
36.153982,-95.992775
29.760193,-95.36939
29.760193,-95.36939
29.665784,-95.019373
53.033748,5.655647
29.665784,-95.019373
29.760193,-95.36939

I've tried using less decimal places (3), but still no luck.

I would later like to add more columns with information regarding each point.

Thanks,

Ivan
53.033748,5.655647
0 Kudos
LuciHawkins
Frequent Contributor
Hey,

This is part of a csv I used to upload data to ArcGIS.com
"OBJECTID","Park_Type","COMMENTS","Park_Address","Park_Name","X","Y"
1,"SPCL PURPOSE"," ","109 MIRACLE STRIP PKWY SW","MUNICIPAL AUDITORIUM",-86.620833,30.405421
2,"COMMUNITY","","126 JET DR NW","BMX/SKATEBOARD PARK",-86.622751,30.413969


Put the " quote marks around text values and add an "OBJECTID" field and number your points also.  It will probably work then.

Hope this helps,

Luci
0 Kudos
IvanMravlag
Emerging Contributor
Luci,

It worked!

I had to change around my lat and long around as well, but all is well now.

Next step is to figure out how avoid chrome from crashing every five minutes, but that's another story.

Many thanks,
Ivan
0 Kudos