Table Renderer

Edit a table in a spreadsheet-style grid and get it as a Markdown (GFM) table, HTML, CSV, TSV, JSON or JSONL. Paste cells from Excel or Google Sheets. The output updates as you type, and formulas such as =SUM(A2:A5) and custom date and duration formats are supported.

About this tool

What does the Table Renderer do?

Writing a Markdown or HTML table by hand is tedious: every pipe and tag has to line up. The Table Renderer gives you a small spreadsheet to type or paste data into and renders it in the text format you need, ready to paste into a README, a wiki page, a web page or a script.

How to use

  1. Type into the grid, or copy cells from Excel, Google Sheets or another spreadsheet and paste them in.
  2. To add or remove rows and columns, click a row number or column letter and right-click it. Drag the corner of the grid to make it bigger.
  3. Pick an Output format. The result appears in the editor below the grid.
  4. For formats with named columns, choose whether to Use the first row as a header.
  5. Copy the result or download it (for example result.md or result.csv) with the buttons in the editor corner.

Output formats

FormatOutput
Markdown(GFM)GitHub Flavored Markdown table with padded columns; pipe characters are escaped and line breaks become <br>
HTML<table> with <thead> and <tbody>; values are HTML-escaped
CSV / TSVComma- or tab-separated values
JSON(Double array)An array of rows, e.g. [["a","b"],[1,2]]
JSON(Object array)An array of objects keyed by the header row
JSONLOne JSON object per line

When Use the first row as a header is off, column letters (A, B, C …) are used as headers and every row is treated as data.

Features

  • Spreadsheet-style editing with copy and paste from other spreadsheets
  • Formulas: cell references (=A1+B1) and functions such as SUM, AVERAGE, COUNT, IF, ROUND, VLOOKUP and CONCATENATE; the output contains the calculated values
  • Date time format: dates are written using a pattern like YYYY-MM-DD HH:mm:ss, with presets such as EU, US and date only
  • Time duration format: durations are written using a pattern like HH:mm:ss
  • Live output that updates on every edit

Example

A 3 × 2 grid rendered as Markdown(GFM) with a header row:

FAQ

How do I convert an Excel range to a Markdown table?

Select the cells in Excel, copy them, click the top-left cell of the grid and paste. Then choose Markdown(GFM) as the output format.

Can I import a CSV file?

There is no file import; paste the cells into the grid instead. To convert CSV text or files to JSON directly, use the CSV / JSON Converter.

Is my data sent anywhere?

No. The grid, formulas and output are all handled in your browser.