This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

How do i format excel spread sheet to import into josm

1

Hi, I have downloaded the opendata plugin in josm as i need to import spreadsheet data into josm. I am using an excel spreadsheet and would like to know the correct format the table needs to be in so that i can import data from the spread sheet to either a node or a way if at all posible?

At the moment I am only getting a error message reading "No valid coordinates have been found"

Help will be greatly appreciated. Cheers.

asked 24 Aug '12, 09:15

Rory%20Keegan's gravatar image

Rory Keegan
16111
accept rate: 0%


2 Answers:

3

First of all, do you have read (and understand) the import guidelines?

If you intend to import data with josm, you have to be sure of what you're doing. Maybe the best solution is to give your data to someone with experience.

Where can we see your file to understand the error?

answered 24 Aug '12, 10:49

NicolasDumoulin's gravatar image

NicolasDumoulin
3.3k42256
accept rate: 13%

edited 24 Aug '12, 10:49

2

I don't know excel, but I guess you can convert it to .csv. From a .csv file you can easily create an .osm-file using some existing osm data as a template. For doing so I used awk.

There are also tools to convert .csv to .osm but they didn't match my needs.

answered 25 Aug '12, 07:15

malenki's gravatar image

malenki
4.7k24683
accept rate: 6%

Source code available on GitHub .