Rearranging XML to Excel data - have a column show up twice

The Ruby library OSMlib allows export into CSV.

The example in the documentation pointed to above has a hospital example that mirrors your restaurant example.

One thing to be aware of, as it sounds like you're looking to extract the data out of OSM, is that the license persists, and your new dataset in CSV form is still under the CC-BY-SA license (until OSM completes the license transition).

So if you distribute this file, it must be under the terms of the CC-BY-SA. If you make a new map, it's a derived work, and if you combine this data with other data, it's a derived work. You should read the various license pages on the OSM Wiki for more information about this, in particular the page on Common license interpretations may help.

OSM's a great resource for POI data. Good luck with your project!

Not that it's really anything to do with OSM, but the Excel data import wizard will import one row per tag combination. You can tell which tags are for the same item by looking at the "id" column.

How to rearrange the data in Excel is a question best asked somewhere like here.

Meanwhile the newly introduced --csv option of osmconvert will help you to create CSV files rather easily. For example:

./osmconvert shops.osm --all-to-nodes --csv="@id @lon @lat amenity shop name" --csv-headline
@id               @lon        @lat        amenity  shop       name
21548298          11.6122123  48.6884848  shop     bakery     Miller
21552613          9.0651970   49.9979332  shop     butcher    Jaeger
1000000168276611  6.6058085   51.4556093  shop     drugstore  AllForYou

To filter all restaurants out of an OSM file you may use osmfilter.