Forum Discussion
Dawn M Wertz
Mar 30, 2023Brass Contributor
How to report on connection information?
I need to justify moving some of my Cloud PCs to Azure regions closer to the users. I want to create a report listing the computer, the round tip time, and the sign-in location. I started by pullin...
expertopinionsa12
Mar 30, 2023Copper Contributor
Hi,
Try using the "From JSON" option in the "Data" tab. This allows you to easily import JSON data into Excel so you can manipulate it and analyze it as needed. Simply open a new workbook in Excel, select "From Text/CSV" in the "Data" tab, browse to the JSON file you want to import, and select it. Then choose "JSON" as the file type in the "Text Import Wizard" dialog and select the format for the data. Excel will create a new table with the imported JSON data, which you can then manipulate as needed. If you encounter any issues with the import, make sure that the JSON file is properly formatted and that it contains the required data fields. I hope this helps.
Try using the "From JSON" option in the "Data" tab. This allows you to easily import JSON data into Excel so you can manipulate it and analyze it as needed. Simply open a new workbook in Excel, select "From Text/CSV" in the "Data" tab, browse to the JSON file you want to import, and select it. Then choose "JSON" as the file type in the "Text Import Wizard" dialog and select the format for the data. Excel will create a new table with the imported JSON data, which you can then manipulate as needed. If you encounter any issues with the import, make sure that the JSON file is properly formatted and that it contains the required data fields. I hope this helps.