I would like to import Json to Excel with microsoft office ltsc standard 2024 excel, why without "expand" icon

Dear @Kara,

I understand how confusing this behavior can be, especially when you are expecting to see the “Expand” icon after importing your JSON file. To better understand why the “Expand” icon is missing in your case, I’d like to ask a few quick questions to help narrow this down:

• First, could you confirm what you see in the Power Query Editor before clicking “Into Table”? For example, does it show a List, Record, or already a table with columns like “Name” and “Value”? This helps determine whether you are at the correct level of the JSON structure.
• Next, after you click “Into Table”, what does your column actually display? Do you see values like [Record], [List], or just normal text/numbers?
• Another helpful detail is the structure of your JSON file. Is it a simple flat structure (like a list of objects with fields such as name and age), or does it contain nested objects inside other objects?
• If possible, could you please share screenshots for me to better determine the issue?

In the meantime, I’d also like to confirm your exact steps, could you try importing your Json file to Excel again by following the Microsoft Official Guide here: Import data from data sources (Power Query) and File: JSON + Table.ExpandTableColumn

Moreover, here are some relevant information I recommend you look through: How to expand columns dynamically in Power Query and How to expand a column that cannot be expanded in Power BI and Power Query in Excel

Disclaimer: These links are shared by community members for your convenience. It points to third-party sites that are not managed or verified by Microsoft. We can’t guarantee the quality, safety, or suitability of any content or software found there. Please review carefully and make sure you understand any potential risks before using it.

Note: Please understand that as a forum moderator, my role is to provide general guidance and troubleshooting support. I don’t have access to internal systems or backend tools, and I appreciate your understanding of these limits.

I hope the information shared helps point you in the right direction. Please try the steps above and let me know if they work. If not, we can continue working together to narrow this down.

The first response may not always resolve the issue right away, but with your help and more details, we can work toward a solution.

Thank you for your patience and understanding. I'm looking forward for your reply.

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.