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.

Elysia Tools

Navigation

Format Conversion

XLSX JSON Transformer

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

Details

What this tool helps you do

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).

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Prepared example runs

Click an example to fill the form automatically. File inputs still need an upload.

2 examples

Flatten Nested JSON to XLSX

Convert nested JSON array into an Excel sheet with dot-path columns

{
  "type": "file",
  "filePath": "/public/samples/xlsx/xlsx-json-transformer-example1.xlsx"
}

Restore Nested JSON from XLSX

Read flattened columns from Excel and rebuild nested JSON objects

{
  "type": "file",
  "filePath": "/public/samples/json/xlsx-json-transformer-example2.json"
}

Inputs

Options are grouped so long tools stay easier to scan.

10 options

FilesUpload source files for this workflow.1

Excel FilefileOptional

Single file max size: 100 MBSupported types: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

ContentPaste or type the main input values.4

JSON Array InputtextareaOptionalSheet NametextOptionalNested Path SeparatortextOptionalRoot Array KeytextOptional

SettingsAdjust formats, ranges, numbers, and modes.3

Transform ModeselectRequiredArray Flatten ModeselectOptionalJSON IndentationnumberOptional

TogglesEnable or disable optional behavior.2

Keep Null ValuescheckboxOptionalEnabled when checkedRestore Value TypescheckboxOptionalEnabled when checked

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

XLSX JSON Transformer

What this tool helps you do

Run this tool

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Prepared example runs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Exporting Nested API Data to Excel

2. Importing Spreadsheet Data to JSON

FAQ

XLSX Samples

XLS Samples

Terraform Plan JSON Samples

Chat Transcript JSON Samples

XLSX Range Extractor

XLSX Sheet To JSON Schema

Excel to JSON Converter

XLSX Conditional Formatting Rule

JSON Interchange and Format Translation Tools

Excel and XLSX Data Automation Tools

XLSX ETL, Import Normalization, and Warehouse Export Tools

XML Conversion, Mapping, and XPath Tools