ysskrishna logoysskrishna

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

6 chapters · about 16 min · free

Google Sheets Table Converter
Google Sheets
Google Workspace Add-ons

Who it is for: Developers, technical writers and analysts who move tables between Sheets and READMEs, docs, APIs, chat and email.

What you will learn

  • Explain why pasted tables break and how a converter avoids it
  • Import a Markdown table, a JSON array, an HTML table or CSV into the current selection or a new sheet
  • Export a selected range as CSV, JSON, Markdown or HTML, then copy or download it
  • Prepare headers and values so exports are clean
  • Run a round trip: Sheets → README → chat

Before you start

  • A Google account with Google Sheets
  • Table Converter installed from the Google Workspace Marketplace (free)
  • Basic familiarity with Markdown or JSON helps

Chapters

  1. 01Why pasted tables break, and the converter's two jobs3 min
  2. 02Import a Markdown table3 min
  3. 03Import a JSON array2 min
  4. 04Import HTML tables and CSV3 min
  5. 05Export a range as Markdown, JSON, HTML or CSV2 min
  6. 06Recipe: one table, three destinations (Sheets → README → Teams)3 min

Start the course

Frequently asked questions

How do I convert Google Sheets to a Markdown table?

Install Table Converter, select the range including the header row, open the Export tab, choose Markdown and click Copy (clipboard) or Export (file).

How do I import JSON into Google Sheets?

Open Table Converter's Import tab, choose JSON Array, paste an array of objects, pick current selection or a new sheet as the destination and click Import. Keys become headers and each object becomes a row.

Can I paste a Markdown table into Google Sheets?

Plain paste puts each row in one cell. With Table Converter, choose Markdown Table in the Import tab, paste the table lines including the separator row, and click Import.

Which formats are supported?

Import: CSV, HTML Table, JSON Array and Markdown Table. Export: CSV, JSON, Markdown and HTML.

Will importing overwrite my data?

It writes at the current selection, which can overwrite cells. Choose a new sheet as the destination when you are unsure.

How do I handle nested JSON?

Flatten it first, for example with jq, so each nested field becomes its own key. A flat table holds one value per cell.

Is Table Converter free?

Yes. The Marketplace listing shows it as free of charge.

Why does my CSV split columns in the wrong place?

A value containing a comma was not wrapped in double quotes at the source. Quote it, or fix the export that produced the CSV.

How do I get a Sheets table into Microsoft Teams?

Export as HTML, or export Markdown and convert it with the Markdown to Teams tool before pasting. Teams does not reliably render raw Markdown tables.

Open the FAQ page

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