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
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.
How to convert JSON to a table for Obsidian
- Paste JSON, upload a file, or drop one onto the input area.
- Choose a conversion mode (Auto, Records, or Key / Value) and how nested objects should be handled.
- Click Convert to table when the JSON passes validation.
- Review the preview and toggle columns to include or exclude them.
- Click Copy markdown to copy the Obsidian-ready table.
- 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.