topic Re: Adding excel spreadsheet information to a map in ArcGIS Online Questions

Adding excel spreadsheet information to a map

IvanMravlag — Mon, 17 Feb 2014 13:42:26 GMT

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

Re: Adding excel spreadsheet information to a map

TimWitt — Mon, 17 Feb 2014 13:48:43 GMT

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

Re: Adding excel spreadsheet information to a map

LuciHawkins — Mon, 17 Feb 2014 18:40:00 GMT

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

Re: Adding excel spreadsheet information to a map

IvanMravlag — Tue, 18 Feb 2014 05:48:27 GMT

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

Re: Adding excel spreadsheet information to a map

LuciHawkins — Tue, 18 Feb 2014 11:21:00 GMT

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

Re: Adding excel spreadsheet information to a map

IvanMravlag — Tue, 18 Feb 2014 12:02:04 GMT

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