Convert JSON arrays into Excel-compatible XLS tables with automatic headers, nested-field flattening, live preview, and one-click download privately offline.
Part of our Converters collection — Explore more Converters tools · See also: Unit & File Size Converter, JSON ↔ CSV Converter.
Quick answer: JSON to Excel — JSON → XLS download Free, no signup, runs in your browser. See below for the interactive tool, 4-step guide and FAQs.
Paste a JSON array of objects. Preview as a table, copy as CSV, and download as .xls (HTML table compatible with Excel).
Supports array of objects or a single object. All processing runs locally.
| name | age | city |
|---|---|---|
| Ada | 36 | London |
| Bob | 29 | Paris |
| Cara | 31 | New York |
Reviewed by the Tool4SaaS Editorial Team — In-house reviewers who build and test every tool locally for accuracy across current Chrome, Edge, Firefox, and Safari. Last updated: . See our authors, methodology or contact us.
It takes arrays of flat items or 1 wrapped item. For example, 2 rows with name and age give 2 cols and head in 1 view. Nests flat to text in 1 pass. Paste in-tab offline with no post at any time.
Yes. Sheet builds stay fully in-tab here. XLS turns for 1000 rows with 4 cols run locally with no post and no login. For instance, tables keep private, work net-off, and erase on shut. No account is needed here.
Yes. Builds run fully offline in 1 view on-device. For example, 1,000 rows preview in 2 seconds with live grid and 1-click save. No upload or account is used. Free with exact heads.
Spreadsheets require flat rows, so nested address.city must become single column address.city to preserve values. Our tool flattens two-level nests into dot notation, joins arrays with semicolons, and renders booleans consistently. For example, Ada with city Lagos exports cleanly, while 1000-row catalogs retain structure. This approach keeps Excel filters functional without manual unnesting daily.
Choose XLS for multi-type reports needing headers, previews, and one-click downloads that open directly in Excel. For example, finance teams share 200-row reconciliations with dates and totals formatted correctly. Use CSV for lightweight pipelines and Postgres COPY operations. Our offline builder previews tables, validates headers, and downloads .xls instantly without server exposure.
Builder turns JSON arrays into Excel-compatible XLS tables with automatic headers, flattened nests, live preview, and one-click download privately offline. Example 1: paste two objects with name and age like Ada 36 and Bob 29, see two columns and header rendered instantly. Example 2: paste 1000-row product catalog with sku, price, stock, preview paginated grid before saving for stakeholder review. Operations teams ship weekly reports, clerks send invoices, analysts distribute cleansed extracts without cloud exposure. Preview validates alignment, headers derive from first keys, Unicode preserves accents, downloads name sensibly. Managers approve payrolls, teachers share gradebooks, nonprofits report grants, and startups circulate metrics securely offline every day without licensing hurdles. Administrators distribute payrolls, event planners track registrations, and analysts publish cleaned extracts with documented methodologies for stakeholders.
First object keys establish column order, subsequent rows align beneath headings, nested structures flatten deterministically for spreadsheet compatibility. Reference mapping table: key name becomes column Name | nested address.city becomes address.city | array tags becomes semicolon list | boolean true becomes TRUE | null becomes empty cell | number 36 stays numeric. Each row fills cells under headers; ragged keys leave blanks for manual cleanup. Save operation writes BIFF-compatible XLS in one tap, preserving text types. Edge case: inconsistent schemas across rows create sparse matrices; standardize fields to two core columns and optional extras before bulk conversion, validating with preview filters and search across large catalogs thoroughly. Teams enforce naming conventions, archive source JSON alongside outputs, and record transformation dates for audit trails.
Example 1: paste two-item JSON with name and age fields for Ada and Bob, preview two columns, save two-row XLS in three seconds. Example 2: load 1000-row inventory with sku and quantity, verify headers, download for warehouse distribution and barcode labeling. Edge case: files above 5 MB may slow mobile browsers; split into 1000-row chunks for smoother previews. Limitation: output supports flat tables only, without formulas, styling, pivot tables, or multiple worksheets for advanced reporting. For comma-separated interchange use transformer at /json-csv; for interactive exploration visit viewer at /csv-viewer, both offline private tools supporting analyst workflows. Teams archive snapshots, auditors sample ledgers, and coordinators track deliverables reliably with versioned filenames. Departments standardize templates, schedule weekly exports, and train staff on offline workflows to reduce errors.