Convert a Google Spreadsheet into a table in Markdown. A node.js module, available here and NPM.
You'll need Node.js (and NPM, which in most comes bundled with Node.js). To get Node.js (for running JavaScript on servers (and in this case your computer is one)), go to nodejs.org and click the icon that corresponds to your operating system. Install. When it's done, open Terminal (in Mac) or Command Prompt (Win) and proceed:
Globally -g
install it so that you can use it anywhere.
npm install -g sheetdown
You can use your Spreadsheet key or the spreadsheet URL (see below)
Prints to terminal:
sheetdown SPREADSHEET
Copies the output (and then you can paste it):
sheetdown SPREADSHEET | pbcopy
It will save the file in the current working directory, so if you want it to be somewhere specific, navigate yourself there in your terminal.
sheetdown SPREADSHEET --save
git clone https://github.com/jlord/sheetdown.git
cd sheetdown
npm install
You'll need an accessible Google Spreadsheet:
- From your Google Spreadsheet click File > Publish to Web (this makes it so the data can be fetched). Click Start Publishing.
- It will return a url in the dialogue box, copy the portion that is your key.
The URL
https://docs.google.com/a/github.com/spreadsheet/ccc?key=0Ao5u1U6KYND7dGN5QngweVJUWE16bTRob0d2a3dCbnc#gid=0
The Key
0Ao5u1U6KYND7dGN5QngweVJUWE16bTRob0d2a3dCbnc