search

shawnbot / tito

Tables In, Tables Out
Creative Commons Zero v1.0 Universal
21 stars 0 forks source link

Add Google Spreadsheets format #7

Open shawnbot opened 9 years ago

shawnbot commented 9 years ago

E.g.

url="https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AmYzu_s7QHsmdDNZUzRlYldnWTZCLXdrMXlYQzVxSFE&output=html"
tito --read google $url --write csv > data.csv
tito --read.format google --read.sheet 1 $url > data.ndjson

This could use tabletop, and should just be able to take a key instead of the full URL:

key="0AmYzu_s7QHsmdDNZUzRlYldnWTZCLXdrMXlYQzVxSFE"
tito --read google $key --write csv > data.csv
shawnbot commented 9 years ago

This is obviously a read-only format to start.