Skip to content
Quick Capture for ObsidianQuick Capture - Vault notes for Obsidian

Free Tool

Obsidian JSON to Table Converter

Convert JSON into markdown tables you can paste directly into Obsidian. Paste JSON or upload a file, choose how objects become columns, and copy the finished table. Everything runs in your browser — nothing is uploaded.

or drop a file onto the input area below

Conversion mode
Nested values

Paste an array of objects, a wrapped array, or a single object. Auto picks a table shape; you can override it above.

Table preview

Toggle columns in the header to include or exclude them when copying.

Convert JSON to see your markdown table preview here.

How to convert JSON to a table for Obsidian

  1. Paste JSON, upload a file, or drop one onto the input area.
  2. Choose a conversion mode (Auto, Records, or Key / Value) and how nested objects should be handled.
  3. Click Convert to table when the JSON passes validation.
  4. Review the preview and toggle columns to include or exclude them.
  5. Click Copy markdown to copy the Obsidian-ready table.
  6. Paste the table into an Obsidian note and save.

Why convert JSON to a markdown table for Obsidian?

JSON is the usual export format for APIs, scripts, and apps, but it is awkward to read inside a note. Converting it to a markdown table keeps the data next to the rest of your writing without a plugin.

The converter also lets you flatten nested objects, drop columns you do not need, and escape pipe characters so the table stays valid in Obsidian.

Notes

  • Auto picks a table shape from the JSON: arrays of objects become records, arrays of arrays become a grid, arrays of primitives become a values column, and a wrapped object such as { "users": [...] } uses the first array of objects. Other objects become a Key / Value table.
  • Records builds one row per object and unions all keys as columns. Missing keys become empty cells.
  • Key / Value turns an object into two columns. Arrays of objects are not converted in this mode — switch to Records or Auto.
  • Flatten turns nested objects into dotted columns such as address.city. Nested arrays, including arrays of objects, stay as compact JSON in a single cell and are not expanded into extra rows.
  • Disabled columns stay visible in the preview but are left out of the copied markdown.
  • Pipe characters in cell values are escaped for Obsidian markdown tables. Line breaks inside cells are replaced with spaces.
  • Standard JSON only — comments and trailing commas are not supported.
  • JSON input is limited to 1 MB and 500 data rows.
  • Copy to clipboard requires a secure connection (HTTPS) and browser permission.