🚀 From JSON to Excel Table - Zero Coding

Ever found yourself staring at a complex JSON file, wishing it could magically turn into a clean, readable Excel table? I recently explored a super simple way to make that happen — no manual formatting, no coding. Just smooth conversion and instant clarity.

In this post, I’ll walk through how you can easily transform JSON data into structured tables using Microsoft Excel. That will save time and effort for writing some easy-complex script. Perfect for developers, analysts, or anyone working with APIs and data exports / analysis.

For this tutorial I have taken help from M365 Copilot to generate a sample JSON file containing 100 rows of school student data, with fields like ID, Name, Age, Grade, Gender, Email, and Enrollment Date:

Next, lets open an Excel file, can be new, can be existing.

Click on "Data" tab and then on the left most side you will find an option "Get Data". Here all the magic begins.

Next click on : Get Data > From File > From JSON

Then Browse for the JSON file you want to convert or import in your excel.

Select the file and click on "Import".

After the Import is complete, a new window will pop-up, "Power Query Editor".

And below you will see a List got populated with all the items in JSON. For this example it was 100.

Right Click on the header "List". Then click on "To Table".

On the new pop-up, do not change anything and click on "Ok" .

Notice the list got changed with columns and records.

Beside the Column Name, look for a button with double arrow facing opposite sides. Click on that button.

A new pop-up will ask for selecting all the columns you want to see in the table. Either skip the selection or select only the necessary fields. When selection in done, click on "Ok".

That's the final step; your list will appear as Table.

Wohoo!!! You made it. You can see the JSON has converted into table. It's time to copy the data into excel.

Click on the Table icon and select "Copy Entire Table" from the dropdown list.

And you can close the "Power Query Editor" Window. Don't worry you copy will be saved in clipboard.

When you are back to the excel, paste the copied data anywhere you want.

🔚 Wrapping Up !!! Whether you're a developer streamlining workflows or a data analyst making sense of API outputs, converting JSON to Excel doesn't have to be a chore. With the right tools and a few smart steps, you can turn raw data into actionable insights — fast.

Have you tried converting JSON to Excel in your projects? Share your favorite tools or tips in the comments — I’d love to hear how others are tackling this!

#DataTransformation #JSONtoExcel #ProductivityTips #TechSimplified #ExcelAutomation