# XLSX JSON Transformer

Bidirectional conversion between JSON arrays and Excel sheets, with nested object flattening and restoration

> Canonical page: https://elysiatools.com/en/tools/xlsx-json-transformer

- **Category:** Format Conversion

- **Keywords:** xlsx, excel, json, flatten, unflatten, nested, transform

## Overview

Convert data both ways:

- JSON array -> XLSX spreadsheet (flatten nested paths)
- XLSX spreadsheet -> JSON array (restore nested objects)

Nested key paths use a configurable separator (default: dot notation).

## Inputs

- **Transform Mode** (select)
- **JSON Array Input** (textarea): \[{"id":1,"user":{"name":"Alice"}}\]
- **Excel File** (file)
- **Sheet Name** (text): Data
- **Nested Path Separator** (text): .
- **Array Flatten Mode** (select)
- **Keep Null Values** (checkbox)
- **Restore Value Types** (checkbox)
- **Root Array Key** (text): items
- **JSON Indentation** (number)

## When to use

- When you need to export nested JSON API responses into a readable Excel format for business reporting.
- When you need to import data from an Excel spreadsheet into a JSON-based application or database.
- When you want to manage complex, multi-level data structures in a familiar spreadsheet interface without losing the original object hierarchy.

## How it works

- Select your transformation mode: JSON to XLSX or XLSX to JSON.
- Upload your file or paste your JSON array into the input field.
- Configure the path separator (e.g., dot notation) to define how nested object keys are mapped to spreadsheet columns.
- Execute the transformation to download your converted file or view the structured output.

## Use cases

- Preparing API data for non-technical stakeholders to review in Excel.
- Bulk-editing configuration files that are easier to manage in a spreadsheet.
- Migrating legacy Excel data into modern JSON-based web applications.

## Frequently asked questions

### How does the tool handle nested JSON objects?

It flattens nested objects into columns using a configurable separator, such as 'user.name' for a nested name field.

### Can I convert an Excel file back into JSON?

Yes, select the 'XLSX to JSON' mode, upload your file, and the tool will reconstruct the nested JSON structure based on the column headers.

### What happens to array data during conversion?

You can choose to either index array elements as separate columns or store them as a JSON string within a single cell.

### Does the tool preserve data types?

Yes, when enabled, the 'Restore Value Types' option ensures that numbers, booleans, and null values are correctly interpreted during the conversion process.

### Is there a limit to the file size?

The tool supports Excel files up to 100MB to ensure efficient processing and performance.

## Related tools

- [XLSX Range Extractor](https://elysiatools.com/en/tools/xlsx-range-extractor): Extract a specific sheet/range/named-range from Excel into JSON with coordinates or record objects
- [XLSX Sheet To JSON Schema](https://elysiatools.com/en/tools/xlsx-sheet-to-json-schema): Infer JSON Schema from worksheet headers and sample rows with types, enum candidates, and basic constraints
- [Excel to JSON Converter](https://elysiatools.com/en/tools/excel-to-json): Convert Excel file to JSON format, extracting data from the first worksheet
- [XLSX Conditional Formatting Rule](https://elysiatools.com/en/tools/xlsx-conditional-formatting-rule): Batch-apply conditional formatting rules such as threshold highlights, data bars, and color scales to Excel worksheets
- [XLSX Multi Sheet Splitter](https://elysiatools.com/en/tools/xlsx-multi-sheet-splitter): Split a multi-sheet workbook into independent files by sheet name, with ZIP output
- [XLSX Print Setup Pack](https://elysiatools.com/en/tools/xlsx-print-setup-pack): Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass
- [XLSX Sparkline Injector](https://elysiatools.com/en/tools/xlsx-sparkline-injector): Inject Excel sparklines into worksheet cells by patching XLSX sheet XML with sparkline definitions
- [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports

## Samples

- [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [Terraform Plan JSON Samples](https://elysiatools.com/en/samples/terraform-plan-json-samples): Sample Terraform plan JSON files exported from terraform show -json style payloads for dependency visualization and change review
- [Chat Transcript JSON Samples](https://elysiatools.com/en/samples/chat-transcript-json): JSON examples for multi-role chat transcripts

## Related content

- [Single-Workbook XLSX Cleaning and Field Mapping](https://elysiatools.com/en/hubs/xlsx-single-workbook-cleaning-and-mapping): A focused workflow for one workbook or one worksheet: select a range, map headers, convert the cleaned table to JSON, and review source, type, null, and duplicate behavior without expanding into batch ingestion or warehouse delivery.
- [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.
- [JSON Normalization and Interchange Workflow](https://elysiatools.com/en/hubs/json-convert): Turn a structured source into a checked JSON representation, then export the exact table, configuration, document, API, XML, CSON, EDN, BSON, or UBJSON form required downstream.