ysskrishna logoysskrishna

Chapter 5 of 6 · 2 min

Export a range as Markdown, JSON, HTML or CSV

Select a range, pick a format, copy or download. How to shape the sheet so each format comes out clean.

Export is the other half of the add-on, and the most searched one: "Google Sheets to Markdown" and "Sheets to JSON".

Step by step

  1. Select the range, including the header row.
  2. Sidebar → Export. Use Show current selection to confirm the range.
  3. Choose EXPORT FORMAT: CSV, JSON, Markdown or HTML.
  4. Click Copy to put it on the clipboard, or Export to download a file.

What each format is for

FormatUse inOutput shape
MarkdownGitHub READMEs, issues, PRs, docs sites, AI promptsPipe table with a header separator
JSONAPI fixtures, seed data, configArray of objects keyed by the header row
HTMLEmails, CMS editors, Teams messages<table> markup
CSVImporting into other tools, scriptsComma-separated with standard quoting

Example: the same range in two formats

Range (sample data):

toolusersfree
Text Power Tools2K+TRUE
Merge Tools82TRUE

As Markdown:

| tool | users | free |
| --- | --- | --- |
| Text Power Tools | 2K+ | TRUE |
| Merge Tools | 82 | TRUE |

As JSON (expected shape):

[
  {"tool": "Text Power Tools", "users": "2K+", "free": "TRUE"},
  {"tool": "Merge Tools", "users": "82", "free": "TRUE"}
]

Shape the sheet first

  • One header row, no merged cells. Unmerge with Merge Tools before exporting.
  • Headers that suit the target. For JSON keys, convert headers to camelCase or snake_case with Text Power Tools.
  • No blank rows inside the range.
  • Displayed vs. underlying values. A cell formatted as $1,200 holds 1200.
  • Pipes in cells for Markdown: a | inside a value must be escaped as \| in Markdown.

Markdown into Teams, Slack or Outlook

A Markdown table pastes fine into GitHub. Chat and email tools differ: Slack does not render tables, and Teams and Outlook need rich text or HTML. For those, export HTML, or paste the Markdown into the site's Markdown to Teams or Markdown to Outlook converter. Chapter 6 does this end to end.

Practice: export the same range three ways

Select a small range with a header row, for example three columns and four rows. In the Export tab, choose each format in turn and click Copy, pasting the result into a text editor:

  1. Markdown: check the separator line under the header and that every row has the same number of pipes.
  2. JSON: check that keys match your header text exactly; a header with a trailing space becomes a key with a trailing space.
  3. CSV: check that values containing commas are quoted.

Fix the header names in the sheet (short, no trailing spaces) and export again; this is usually the only cleanup needed.

Quick check

  1. What must your selection include for good JSON keys?The header row.

  2. Which format for a GitHub README?Markdown.

  3. Your export has empty-header columns. What was wrong in the sheet?Merged or blank header cells; unmerge and fill headers first.

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Table Converter

Google Sheets Table Converter

Pipe tables, JSON, CSV, or HTML in and out of Sheets, without leaving the grid you are already in.
Google Sheets Table Converter
Markdown & Docs
Text & Data Conversion
Google Workspace Add-ons
BlogCover image for Import JSON, Markdown, HTML & CSV Tables into Google Sheets Without Breaking Data

Import JSON, Markdown, HTML & CSV Tables into Google Sheets Without Breaking Data

Google Sheets Table Converter
Google Workspace Add-ons
+3
2 min read
BlogCover image for Convert Google Sheets to Markdown, HTML, JSON & CSV Without Breaking Tables

Convert Google Sheets to Markdown, HTML, JSON & CSV Without Breaking Tables

Google Sheets Table Converter
Google Workspace Add-ons
+3
2 min read
ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Delete multiple tabs in Google Sheets at once, hide and unhide in bulk, rename with find and replace, colour and sort tabs A–Z with the free Sheets Tab Manager.

Google Sheets Tab Manager
Google Sheets
+1

6 chapters · 24 min

ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script