How can I extract data from the Traveller Map for a spreadsheet

[Taythorian]

Originally Posted by tjoneslo

If you use the API, you can get it to dump the data out in a tab separated file (TSV), which you can very easily parsed by the spreadsheet.

The challenge with a comma separated file (CSV) is this is a poorly defined format and is easy to break in unexpected way. Especially given the names used for the Traveller worlds.

I know at least one person downloaded all the Traveller Map data and loaded it into a SQL database. I keep thinking I want to do the same thing, but not gotten around to it.

That may have been me. It took a little while to work it out, but works well now.

[robject]

I wrote a Perl script that proxies Travellermap data into the format I want.

It's nerdy, but fun.