NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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%


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?

permanent link

answered 24 Aug '12, 10:49

NicolasDumoulin's gravatar image

NicolasDumoulin
3.3k42256
accept rate: 13%

edited 24 Aug '12, 10:49

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.

permanent link

answered 25 Aug '12, 07:15

malenki's gravatar image

malenki
4.7k24683
accept rate: 6%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22
×9

question asked: 24 Aug '12, 09:15

question was seen: 5,981 times

last updated: 25 Aug '12, 07:15

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum