How to Merge Excel Files: Easy Methods (2026)
Merge multiple Excel files (XLS & XLSX) using free online tool, Python pandas, VBA macros, or Power Query. Complete guide for append rows, separate sheets, and header matching.
Convert JSON to Excel (XLSX) or CSV instantly with our free online JSON to Excel converter. Transform JSON data into spreadsheets with real-time preview, automatic flattening, and smart data detection. Perfect for developers, analysts, and teams working with API data.
or drag and drop a .json file here
How nested JSON becomes a flat spreadsheet
[
{
"id": 1,
"name": "Alice Johnson",
"email": "alice@company.com",
"department": "Engineering",
"address": {
"street": "123 Main St",
"city": "Portland",
"zip": "97201"
},
"skills": ["JavaScript", "React", "Node.js"],
"active": true,
"salary": 95000
},
{
"id": 2,
"name": "Bob Smith",
"email": "bob@company.com",
"department": "Marketing",
"address": {
"street": "456 Oak Ave",
"city": "Seattle",
"zip": "98101"
},
"skills": ["SEO", "Content Marketing"],
"active": true,
"salary": 75000
}
]Flatten + Tabularize
Flatten + Tabularize
| id | name | department | address.street | address.city | address.zip | skills | active | salary | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Alice Johnson | alice@company.com | Engineering | 123 Main St | Portland | 97201 | JavaScript, React, Node.js | true | 95000 |
| 2 | Bob Smith | bob@company.com | Marketing | 456 Oak Ave | Seattle | 98101 | SEO, Content Marketing | true | 75000 |
Input
user.address.cityColumn Header
Input
tags: ["a", "b"]Cell Value
Input
nullCell Value
Paste JSON, upload a .json file, or load the sample.
Pick CSV or XLSX. Under Advanced, set flattening and date handling.
Check the preview, then download the file or copy it as CSV.
Converting JSON to Excel in Python is efficient using the pandas library with pd.json_normalize() to flatten nested JSON and to_excel() to write XLSX files. Use this when the conversion is part of a script or scheduled job. For cell formatting, formulas, or styling, work with openpyxl directly.
import pandas as pd
import json
# Load the JSON file
with open("data.json", "r") as f:
data = json.load(f)
# Normalize nested JSON into a flat table
df = pd.json_normalize(data)
# Export to Excel
df.to_excel("output.xlsx", index=False, engine="openpyxl")
print(f"Converted {len(df)} rows with columns: {list(df.columns)}")Power Query in Excel provides a no-code way to convert JSON to Excel tables. Use Json.Document() to parse JSON files or API responses, then expand nested records and lists into columns. The same steps can be done from the Power Query editor without writing M code, and the query can be refreshed when the source file changes.
let
Source = Json.Document(File.Contents("C:\data\input.json")),
// Convert the JSON array into a table
ConvertedToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
// Expand all record fields into columns
ExpandedColumns = Table.ExpandRecordColumn(ConvertedToTable, "Column1",
{"name", "address", "tags"}, {"name", "address", "tags"}),
// Expand nested address object
ExpandedAddress = Table.ExpandRecordColumn(ExpandedColumns, "address",
{"city", "zip"}, {"address.city", "address.zip"}),
// Convert tags list to comma-separated string
TransformedTags = Table.TransformColumns(ExpandedAddress,
{{"tags", each Text.Combine(List.Transform(_, Text.From), ", "), type text}})
in
TransformedTagsThis tool takes a JSON array and writes each object as a row in an Excel spreadsheet. Each key in your JSON objects becomes a column header in the Excel file. Numbers and booleans keep their types, and ISO date strings such as 2026-01-31 or 2026-01-31T10:00:00Z are written as real Excel dates in XLSX output. If you only want to look at the rows rather than download a file, open the data in JSON to Table instead.
Everything runs in your browser, so your data never gets uploaded to any server. It's completely free with no signup required.
The converter accepts up to 15 MB of JSON, which covers tens of thousands of typical rows in a modern browser. If your file is bigger than that, split it with the JSON File Splitter and convert each part.
Paste or upload your JSON, check the preview that appears as you type, and download your XLSX or CSV file. That's it. If you convert several JSON files this way, combine the downloads afterwards with the Excel Merger (XLSX) or the CSV Merger.
Nested objects get flattened using dot notation. For example, if your JSON has {"user": {"name": "Ali"}}, the Excel file will have a column called user.name with the value Ali in the cell.
Arrays of simple values become comma-separated values in a single cell. So {"skills": ["Python", "SQL"]} becomes a cell with the text "Python, SQL". Arrays of objects are written into one cell as JSON text.
If you want nested objects kept in a single cell as a JSON string instead of split into columns, open Advanced and turn off "Flatten nested objects". If you need more control over how keys are joined (a different separator, or arrays expanded into indexed columns), run your data through the JSON Flattener first, then convert the result here.
Quick example: {"address": {"city": "Portland", "zip": "97201"}} becomes two columns: address.city and address.zip. Each gets its own column in the spreadsheet.
This is the most common source of confusion. If your Excel file has weird column names with dots in them, this is why. It's flattening nested objects automatically.
You don't need to reshape it. A single object (starts with {) is converted into a one-row sheet. If the object is an API response that holds its records in a data, results, items, records, rows, or list array, the tool picks up that array automatically and tells you how many records it found.
If your records sit under some other key, or deeper inside the response, copy that inner array out and paste it in on its own. Otherwise the whole object becomes a single row.
A bare value like a number or string also works: it becomes a single cell under a column named value. The only input that is rejected is invalid JSON, and the error message points you to the usual causes such as missing commas or trailing commas.
This tool only goes one way: JSON to Excel. If you need to convert Excel back to JSON, you can use a quick Python script with pandas: df.to_json(orient='records').
There are also online Excel to JSON converters available, but we don't have one built into this site yet.
Merge multiple Excel files (XLS & XLSX) using free online tool, Python pandas, VBA macros, or Power Query. Complete guide for append rows, separate sheets, and header matching.
Convert JSON to CSV in Notepad++ with plugins, regex methods, and online alternatives for transforming JSON arrays and objects.
Enhance VS Code JSON editing with 7 useful extensions for formatting, minification, visual exploration, inline diagnostics, conversion, and repair.