Skip to main content
DataFormatKit
Text to CSVCSV to ExcelJSON to ExcelJSON to CSVXML to CSVCSV Validator
Open Text to CSV

Conversion tools

Text to CSVCSV to ExcelJSON to ExcelJSON to CSVXML to CSVCSV Validator

Ideas & support

Suggest a converter
Current tool
1

JSON source

Paste a JSON document or import a .json file.

Drag and drop · JSON · 10 MB maximum
0 B entered
2

Record mapping

Select the array that defines rows and how nested arrays are represented.

3

XLSX output review

Validation results and export actions appear here.

No JSON data has been validated

Add a JSON document, validate it, then confirm the detected record path and output columns.

A JSON to Excel Converter
for Nested Records and Long IDs

Convert JSON to Excel after choosing the array that represents spreadsheet rows. Review flattened fields, nested-array handling, missing values, and precision-sensitive IDs before creating the XLSX locally.

✓ Selectable record path✓ Long IDs kept exact✓ Local processing with no upload
Return to the converter

From nested JSON to reviewed workbook rows

The result depends on three choices: which array defines the rows, how nested values become columns, and which numeric tokens must remain text. The preview shows each transformation before the workbook is created.

  1. 01

    Validate the JSON source

    Paste a document or choose a local file. Duplicate object keys stop conversion, while candidate arrays are identified without uploading the JSON to a remote conversion service.

  2. 02

    Choose rows and nested rules

    Select the array that represents workbook rows, then decide whether nested arrays stay as JSON, join as scalar text, or expand once. Nested objects become readable path-based columns.

  3. 03

    Review and create XLSX

    Inspect mapped columns, missing values, long integer tokens, and transformations. Convert JSON to Excel only when the preview matches the records you meant to place in the workbook.

See a nested record and long ID together

{
  "items": [
    { "id": 1234567890123456789, "profile": { "name": "Ada" } },
    { "id": 42, "profile": { "name": "Lin" } }
  ]
}

Choose items as the record path and profile.name becomes a workbook column beside id. The 19-digit identifier is read from its original token and written as an Excel text cell, so every source digit survives the conversion.

Return to the converter

What this workbook conversion does not do

  • Only one nested array can be expanded into rows at a time; multiple arrays are not multiplied automatically.
  • Macros, charts, formulas, styling templates, and existing workbook updates are outside this converter.
  • Files are limited to 10 MB or 50,000 result rows, whichever comes first.

JSON to Excel questions before download

Direct answers about record paths, long integers, nested objects, arrays, and the resulting workbook.

How do I convert JSON to Excel with the correct rows?

To convert JSON to Excel, add the source and select the detected record path that should define spreadsheet rows. The preview shows the mapped columns before you create the workbook, so a wrapper object or unrelated array is not exported by accident.

Does JSON to XLSX keep long integer IDs exact?

A JSON to XLSX export retains the original numeric token. Integers that cannot be represented safely, or contain 16 or more digits, are written as Excel text cells so the resulting workbook keeps every source digit.

How does JSON to Excel handle nested objects?

The JSON to Excel converter flattens nested objects into escaped path columns such as profile.name. Literal keys containing dots remain distinct from nested paths, preventing separate source fields from being merged into one spreadsheet column.

Can the workbook expand multiple nested arrays?

The conversion can expand one selected array into rows. It does not multiply unrelated arrays automatically because a cross product could create relationships and row counts that were never present in the source.

Need a different source or output?

Convert text to CSV

Check delimiters and uneven rows in pasted text or local TXT files.

→
Convert CSV to Excel

Create a text-safe workbook from an existing CSV table.

→
Convert JSON to CSV

Use a flat text export when XLSX cell typing is not required.

→
Convert XML to CSV

Choose repeating XML record nodes and preserve attributes.

→
DataFormatKit

Small, inspectable data conversions that run in your browser.

Support DataFormatKit

Tools

Text to CSVCSV to ExcelJSON to ExcelJSON to CSVXML to CSVCSV Validator

Trust

PrivacyTermsAboutRequest a feature
© 2026 DataFormatKitNo account. No source-file upload. No hidden conversion.