Open JSON as rows you can sort and filter.
Open a .json file up to 50 MB and turn its records into a table you can sort and filter. Export the active view as CSV when you are ready. The file contents are parsed in your browser and are not uploaded to Loam. When you want trustworthy answers from your data, learn how Loam grounds your AI.
Drop a .json file here or click to choose a file
Your file contents are parsed in your browser and are not uploaded to Loam.
Turn JSON records into rows and columns
JSON is useful for moving data between tools, but it can be hard to scan. This viewer turns an array of objects into rows and columns. Nested fields get clear names such as customer.address. You can sort and filter the table, then export the active view as CSV.
Ask questions about the rows you export
The viewer helps you inspect a JSON file in your browser. Loam connects your files to your AI, so your AI answers from your real data. To try questions in the free chat tool, export this view as CSV and upload that CSV separately. The chat tool accepts CSV and TSV files, not JSON.
How to open a JSON file
For a visual view, drop a .json file into the tool above. If you prefer to work in code, these examples show the first 20 rows:
Python (pandas)
import pandas as pd
df = pd.read_json("data.json")
print(df.head(20))DuckDB
SELECT * FROM read_json_auto('data.json') LIMIT 20;Frequently asked questions
Give your AI the real values
Loam connects your files to your AI, so your AI answers from your real data.