Blog Blog Posts Business Management Process Analysis

How to Convert JSON to Excel?

JSON and Excel are two widely used formats for storing and exchanging data. This blog aims to explore the process of converting JSON data to Excel and make this process accessible and user-friendly. It will empower you to efficiently manage and manipulate your JSON data within Excel spreadsheets.

Table of Contents

Check out this video on Excel to learn it in one go:

“@context”: “”,
“@type”: “VideoObject”,
“name”: “Advanced Excel Full Course | Excel Tutorial For Beginners | Excel Training | Intellipaat”,
“description”: “How to Convert JSON to Excel?”,
“thumbnailUrl”: “”,
“uploadDate”: “2023-07-26T08:00:00+08:00”,
“publisher”: {
“@type”: “Organization”,
“name”: “Intellipaat Software Solutions Pvt Ltd”,
“logo”: {
“@type”: “ImageObject”,
“url”: “”,
“width”: 124,
“height”: 43
“embedUrl”: “”

What is JSON?

What is JSON

JSON, or JavaScript Object Notation, offers a standardized structure that enables the representation and transmission of data in a readable manner. JSON finds widespread application in web development as it facilitates data exchange between servers and web applications. It utilizes key-value pairs and accommodates diverse data types, including strings, numbers, booleans, arrays, and objects.JSON’s simplicity, versatility, and compatibility with multiple programming languages have made it a popular choice for storing, retrieving, and transmitting data in modern applications.

Intellipaat provides a Power BI Course. Enroll now to get a professional certificate!

Applications of JSON files

Below, we will discuss some common applications of JSON files:

Check out the Power BI Interview Questions if you are preparing for a job interview.

What is Excel?

What is Excel

Excel is a robust spreadsheet application created by Microsoft, offering a complete solution for data organization, analysis, and manipulation. It is a widely used tool due to its intuitive interface and extensive features, catering to diverse needs like budgeting, inventory management, and report generation. 

Users can effortlessly create worksheets comprising rows and columns to store and arrange data efficiently within Excel. 

Additionally, it provides a vast array of functions, formulas, and tools. This empowers users to perform calculations, generate visually appealing charts and graphs, and automate repetitive tasks. 

Learn more about Power BI from this Power BI Tutorial!

Applications of Excel

Several applications of Excel can be utilized across different fields and industries. Here are some common applications of it.

How to Import JSON to Excel?

How to Import JSON to Excel

To convert JSON data into Excel, you can follow the steps outlined below:

Before importing JSON data into Excel, ensure the JSON file or data is ready. JSON is a popular format for storing and exchanging data. It uses a key-value pair structure similar to dictionaries in Python or objects in JavaScript. Ensure your JSON data is appropriately formatted and contains the necessary information to import into Excel.

To start, open Microsoft Excel on your computer. Click on the “File” menu at the top, then choose “New.” From the options provided, select “Blank Workbook.” This will create a fresh Excel workbook for your tasks.

To import JSON data into Excel, you’ll need to use the Power Query add-in, available in newer versions of Excel (2010 and later). If you’re using an older version of Excel, you may need to download and install the Power Query add-in from the Microsoft website. Once you have the add-in, you’ll need to enable it in Excel by going to the “File” menu, selecting “Options,” then choosing “Add-Ins.” From there, you can select “COM Add-ins” in the “Manage” dropdown and click “Go.” Check the box next to “Microsoft Power Query for Excel” and click “OK” to enable it.

Career Transition

Once the Power Query add-in is enabled, proceed to import the JSON data into Excel. Locate the “Data” tab in the Excel ribbon at the top and click the “Get Data” button. A drop-down menu will appear—select “From File” and then pick “From JSON.” This action will prompt a file explorer window to appear. Use it to navigate to the location where your JSON file is stored. Once you’ve found the JSON file, click “Open” to proceed.

After importing the JSON file, Excel will automatically launch the Power Query Editor window. This specialized tool allows you to transform the data according to your needs. Within the Power Query Editor, you can perform various tasks, such as filtering data, removing unnecessary columns, renaming columns, and more. Utilize the available options and tools in the Power Query Editor to modify and shape the JSON data per your requirements.

Once you have finished transforming the data, click the “Close & Load” button in the Power Query Editor to load the data into Excel. By default, it will create a new worksheet with the imported data. Depending on your preferences, you can load the data into an existing worksheet or create a data connection instead.

Point to Consider: If you are looking to convert JSON files into Excel format, there is an essential requirement you need to keep in mind. For this conversion process to work seamlessly, it is necessary to have Microsoft Office 365 installed on your system. With it, the conversion might function as expected.

Microsoft Office 365’s advanced features and compatibility make it an ideal choice for converting JSON files into the popular Excel format.


Understanding how to convert JSON to Excel opens up data management and analysis possibilities. By importing JSON into Excel, users can seamlessly integrate and leverage the strengths of both formats. With the help of tools like Python’s Pandas or online converters, the conversion process can be simplified, allowing for efficient data integration and analysis. This knowledge empowers learners to optimize their data-handling capabilities and make decisions effectively.

Still in a doubt? Visit our BI Community!

The post How to Convert JSON to Excel? appeared first on Intellipaat Blog.

Blog: Intellipaat - Blog

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples