DataWarrior Import from Google sheet

[drc007]

We can use this URL

https://docs.google.com/spreadsheets/d/168-a1_l51Nfbms67eG8zU8p-EhEtEO26FUzRInbu7fY/export?format=tsv

to access the first tab of the Google sheet, how do we import from specific tabs?

[drc007]

Looks like this works (many thanks to Isabelle).

url=https://docs.google.com/spreadsheets/d/168-a1_l51Nfbms67eG8zU8p-EhEtEO26FUzRInbu7fY/export?format=tsv&gid=1078638615 format=td

[drc007]

I've created 4 macros to import various subsets.
OSADataWarriorMacros.zip

Uncompress and save the files somewhere, in DataWarrior in the Macro menu select import. The macro should then appear in the "Run Macro" menu items. @mattodd @danaklug @loriferrins let me know if this works for you.

[danaklug]

@drc007 Yep worked for me - thanks to you and Isabelle!

[drc007]

Brilliant.