sheetdown

sheetdown

Convert a Google Spreadsheet into a table in Markdown. A node.js module, available here and NPM.

To Use

You'll need Node.js (and NPM, which in most cases 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:

Install sheetdown

Globally -g install it so that you can use it anywhere.

npm install -g sheetdown

Make Tables

Use your Spreadsheet key (see below)

Prints to terminal:

sheetdown SPREADSHEETKEY

Copies the output (and then you can paste it):

sheetdown SPREADSHEETKEY | pbcopy

Save Table as Markdown file

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 SPREADSHEETKEY --save

To Build

git clone https://github.com/jlord/sheetdown.git
cd sheetdown
npm install

Get a Spreadsheet Key

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

*Accessible Google Spreadsheets are those with Share settings set to either 'Public on the Web' or 'Anyone who has the link can view'. Spreadsheets set to 'Shared Private' cannot be reached because they're private, so they won't work.