ysskrishna logoysskrishna

Chapter 2 of 6 · 3 min

Import a Markdown table

Turn a README or docs table into real cells: what valid Markdown tables look like, alignment rows, escaped pipes and inline formatting.

Markdown tables are everywhere developers write: READMEs, issues, pull requests, docs sites, AI chat answers. Getting one into Sheets for sorting or charting is a common need.

Anatomy of a Markdown table

| Name   | Role     | Since |
|:-------|:--------:|------:|
| Asha   | Backend  | 2021  |
| Raj    | Frontend | 2023  |
  • Header row: the first line.
  • Separator row: dashes, with optional colons for alignment (:--- left, :---: centre, ---: right).
  • Body rows: one per line.
  • Leading and trailing pipes are optional in GitHub-Flavored Markdown.

The separator row is not data. A converter uses it to recognise the table and drops it.

Step by step

  1. Copy the table from your source, including the header and separator rows.
  2. Sidebar → Import → IMPORT FORMAT Markdown Table.
  3. Paste into DATA SOURCE.
  4. Choose Current selection (click the top-left target cell first) or a new sheet.
  5. Click Import.
  6. Check the column count and the last row. Clear empties the text box if you want to start over.

Things that trip up Markdown imports

ProblemExampleFix before import
Escaped pipe inside a cell`a \b`
Inline formatting**bold**, code, [link](url)Expect the Markdown characters to arrive as text, or strip them first
Ragged rowsA row with fewer cellsMissing cells import empty; add pipes if alignment matters
Text before or after the tableA heading and paragraphPaste only the table lines
AI chat tables with a trailing note"Note: prices may vary"Delete the note

Numbers and dates

Values arrive as text or are interpreted by Sheets, depending on how they are written. After import, select numeric columns and set Format → Number explicitly. For IDs with leading zeros, format the destination as Plain text before importing.

Example: a table from an AI answer

AI assistants often answer comparisons with Markdown tables. Copy the table lines only, import to a new sheet, then sort and filter: a quick way to check a comparison instead of trusting it.

Practice: a table with awkward cells

Import this into a fresh tab and check each cell afterwards:

| Feature | Free | Pro |
|:---|:---:|---:|
| Seats | 1 | 10 |
| Price |  | $12 |
| Support | Community | Email, chat |

What to look for:

  1. Alignment colons (:---, :---:, ---:) only describe alignment in rendered Markdown. The data should arrive the same as with plain ---.
  2. The empty cell under Free/Price should arrive as an empty cell, so the Pro value stays in column C. If the value shifts left, a pipe was missing in the source.
  3. $12 may arrive as text or as a number formatted as currency, depending on how Sheets reads it. Check with =ISNUMBER(C3).
  4. "Email, chat" keeps its comma; commas have no meaning in Markdown tables.

Cleaning AI-generated tables first

Chat assistants often wrap tables with extra text ("Here is the table:") and sometimes add bold markers to the header. Copy only the lines that start with |. If the header comes through as **Feature**, remove the asterisks afterwards with the Text Power Tools Strip specific characters option (type *), or with =SUBSTITUTE(A1,"*","").

Quick check

  1. Which row tells a converter "this is a Markdown table"?The separator row of dashes (with optional colons).

  2. Is the separator row imported as data?No, it only marks the table and the column alignment.

  3. Your import includes a paragraph as a row. What did you paste?Text around the table. Paste only the table lines.

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