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

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

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

To Build

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

Get a Spreadsheet Key/URL

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

`