Exporting or importing osm data to excel sheet

Thank you for your help but steel am having problems with osmconvert I can't get the option to convert ether to Excel or csv file can you help me with the code or ....

As an example, here's the full process that I used to obtain all mapped railway stations in mainland GB with lat and long in a spreadsheet:

1) osmconvert great_britain.osm.pbf -o=great_britain.o5m

2) osmfilter great_britain.o5m --keep="railway=station" > stations.osm

3) osmconvert stations.osm --all-to-nodes --csv="@id @lat @lon railway name" --csv=headline > stations.txt

4) Open stations.txt in your spreadsheet program of choice, and remove lines that don't have "station" in column D

Step (1) is needed because osmfilter doesn't understand pbf (protobuf format) files. You could process as a raw .osm file, but it'd be much bigger.

Step (4) is a sanity check to get rid of a few bits and pieces.

@SomeoneElse step 3 should read --csv-headline and not --csv=headline, as far as i can see.

Step 4 could also be achieved automatically with perl, e.g. with (untested):

 perl -ne'print if /.*?\t.*?\t.*?\t.*?\t(station).*/' stations.txt

Thank you very much it works! I also use Moor.XmlToCsvConverter.exe and its very simple!