Convert a Google Spreadsheet into a table in Markdown
Works with both old and new Google Spreadsheets.
-g install it so that you can use it anywhere.
npm install -g sheetdown
Use your Spreadsheet url and either run one of these commands to either print the table out to your console, copy it to your computer's clipboard or save it to a file named
table.md in the current directory.
Prints to terminal:
Copies the output (and then you can paste it):
sheetdown SPREADSHEETURL | pbcopy
Save Table as Markdown file
It will save the file
table.md in the current working directory, so if you want it to be somewhere specific, navigate yourself there in your terminal.
sheetdown SPREADSHEETURL --save
You'll need an accessible (settings that allow its data to be read) Google Spreadsheet:
- From your Google Spreadsheet click File > Publish to Web (this makes it so the data can be fetched). Click Start Publishing.
- From the Share button on the top right, have it set at least to 'Anyone who has the link can view'
git clonecd sheetdownnpm install