Data Viewers

Raw data is easier to read as a table. Rows line up, columns get headers, and a missing field or a stray value stands out. These viewers take JSON, CSV or a PHP array and render it as an HTML table without you writing any code.

Paste the data, upload a file or fetch it from a URL. The JSON viewer expects an array of objects and turns each key into a column. The CSV viewer lets you choose the delimiter and treats the first row as headers. The PHP array viewer parses both array() and [] syntax. All three handle large inputs and scroll horizontally when there are many columns.

Use them to check an API response before you write the parser, to inspect an export before importing it somewhere else, or to share a quick look at a dataset with a colleague.

Which tool for which job

  • Check a CSV export before importing it somewhere

    CSV to Table. Columns line up, so a shifted row or a stray delimiter is easy to see. Cells stay text, which keeps leading zeros on codes like 007.

  • Read an API response that returns a list of records

    JSON to Table. Each object becomes a row and each key a column, so a record with a missing field leaves a visible gap.

  • Read a PHP array from var_export() or a config file

    PHP Array to Table. Both array() and [] syntax are parsed, so output from var_export() works as well as a modern config file.

  • Pull one field out of every item in a large JSON response

    JSONPath Tester. An expression such as $.items[*].id returns every id, and a filter like [?(@.price < 15)] narrows the list.

  • Tidy a CSV file before an import

    CSV Cleaner. Spaces at the start or end of a value are a common reason two values that look the same fail to match after an import. Trim them here first.

Other tool categories

Specifications and references

This tool follows the specifications below. Read them when you need the exact normative wording, for example to settle an edge case between two implementations.

Frequently Asked Questions

What shape of JSON works in the table viewer?

An array of objects with mostly the same keys. Nested objects become dotted columns such as user.name, and arrays are kept as JSON text in a single cell. If the records sit inside a wrapper like {"data": [...]}, paste only the inner array, or pull it out with the JSONPath Tester first.

Can I paste the table into an email?

Yes. The Copy for Email button puts a formatted table on the clipboard, and it pastes into Gmail, Outlook, Google Docs or Word as a real table. Use the HTML option when you need the markup itself, for a template or a CMS.

Which JSONPath syntax does the tester understand?

The common syntax: $ for the root, .key or ['key'] for a child, [*] for every item, .. for recursive descent, [start:end] slices and filters such as [?(@.price < 15)]. JSONPath only got a formal specification in 2024, as RFC 9535, and libraries still differ on edge cases, so test the final expression in the library you ship with.

Copied to clipboard!