JSON / Array Converter

JSON-to-spreadsheet conversion sounds simple but real-world JSON is messy. API responses come as arrays of objects, single objects, nested objects, arrays of arrays, and combinations. SwitchPDF's converter handles all of these by walking the JSON tree, flattening nested objects with dot notation, and joining array values into comma-separated cell values.

Flattening means an object like { "address": { "city": "NYC", "zip": "10001" } } becomes two columns: address.city and address.zip. This preserves all the data while producing a flat tabular structure that works in Excel or CSV. Top-level arrays of objects become rows; a single object becomes a one-row spreadsheet; primitive values are placed in a "value" column.

The Excel export uses SheetJS to produce a real .xlsx file (not a CSV renamed). The CSV export properly escapes commas, quotes, and newlines using RFC 4180 quoting. The PDF export uses pdf-lib to generate a paginated table with a styled header row, alternating row colors, and automatic column-width calculation based on content. All three exports happen server-side in milliseconds — no JavaScript table-rendering libraries needed in the browser.

This tool is especially useful for: exporting API responses to Excel for non-technical stakeholders; turning a JSON dataset into a CSV for import into Google Sheets; producing a formatted PDF table from a JSON config for inclusion in a report; debugging the structure of a complex JSON response by visualizing it as a table.