Share via

HOW TO CONVERT JSON TO EXCEL

kedar bvb 5 Reputation points
2025-06-04T14:21:36.49+00:00

I need to convert data from Json to excel . I have noticed that there is no option of convertion of Json to excel in my window 11 . I had a chat support with the team and he was not able to solve my issue and said to esclate to the Tech. team . Kindly help me in this subject and do the needful .my service request is as follows

A service request is being opened

Thanks for your information. Chat will begin shortly. If you don't see the chat window, open it now

Title

NEED JSON CONVERT TO EXCEL

Request Number

Status

Active

Name

Email

***@outlook.com

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,936 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dora-T 1,085 Reputation points Microsoft External Staff Moderator
    2025-06-05T02:07:47.66+00:00

    Hi @kedar bvb

    Thank you for reaching out to the Microsoft Q&A Forum. 

    Please understand that our forum is a public platform, and we will modify your question to cover your organization ___domain name in the description. Please notice to hide these personal or organization information next time you post error or some information to protect personal data.
    Regarding your query about converting JSON to Excel, I've tested this method in the Excel app, and it works. I recommend giving it a try.  

    1. Open Excel and go to the Data tab. 
    2. In the Get & Transform Data group, click Get Data. 
    3. Select From File > From JSON. 
    4. Browse and select your .json file, then click Import. 
    5. In the Power Query Editor, preview and transform your data as needed. 
    6. Click Close & Load to display the data as a table in your worksheet.

    User's image

    If the suggested method doesn't work, I recommend raising a support ticket for more effective assistance. As moderators, we offer general guidance and share resources, but we have limitations in direct troubleshooting. We don't have remote access, specialized diagnostic tools, or the capability to resolve specific software issues or complex data files. For the most efficient solution, please contact Contact - Microsoft Support directly. 

    Thank you for your understanding. 

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.