Convert JSON to Excel in Microsoft Power Automate for Desktop
Do you receive JSON files that you'd like to convert to Excel tables? In this video, we show you how to convert JSON to Excel tables in Microsoft Power Automate for Desktop.
Doing this transforms JSON file data into Excel format so that it becomes very easy to see, read, and do subsequent data manipulation such as filtering, applying formulas, etc.
00:00 Introduction
00:11 Sample JSON file used for this tutorial
00:38 Extract the keys from the JSON file
03:00 Write keys to Excel
07:30 For each key, access the value and write to Excel
10:34 Save the Excel file
If you're not yet familiar with the basics of Microsoft Power Automate for Desktop, you may want to check out these topics used in this tutorial:
Loop actions in Microsoft Power Automate for Desktop: • How to use loops in Microsoft Power A...
Excel automation basics: • Power Automate Desktop Excel Automati...
Conditionals in Microsoft Power Automate for Desktop: • Conditionals (if, else, switch, case)...
Text manipulation (including replace text): • Manipulating text in Microsoft Power ...
Keep in touch!
Website https://mspowerautomate.com/
Twitter / msautomate
Facebook / ms-power-automate-105388391663527
LinkedIn / power-automate
#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate
Watch video Convert JSON to Excel in Microsoft Power Automate for Desktop online without registration, duration hours minute second in high quality. This video was added by user MS Power Automate 01 April 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,675 once and liked it 76 people.