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 comes with Node.js).

Install

npm install -g sheetdown

Make Tables

Prints to terminal:

sheetdown SPREADSHEETKEY

Copies:

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.

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

`