Excel – Get Data from JSON

This Post will explain how to convert Json data to Excel

  1. Data -> Get Data -> From File -> From Json

  1. Click on To table

  2. Press OK

  3. Click Arrow next to column 1

  4. Select the columns you want, Make sure to remove the check box next to: Use original column name as prefix

  5. Click on Close & Load

    That’s it.

IT strategy: Driving efficiency through low-code app development

As an IT professional, you are in the eye of the digital transformation “storm,” often with limited resources. From network maintenance to app development, compliance and security to systems integration, your work is important to many parts of your organization.

Learn how to reduce costs and increase the agility of your IT resources and discover why leaders are turning to low-code app development platforms. Access the e-book now!

Miami Dade

Remote learning is the new norm for many, but even before the pandemic hit, one US school district was establishing itself in technology-supported education. Read this story to learn how the district’s digital initiative supported increasing technology in the classroom, and how this proactive mindset helped prepare the district for remote learning. Contact Purple Digits to get started.

Mobile collaboration with the Malteser aid organization

In order to streamline volunteer access and processes, as well as meet security and privacy compliance, one German nonprofit realized it needed to modernize. Malteser Verbund aid organization opted to augment their private cloud with a public cloud solution based on #Microsoft 365. Access their compelling story and learn how this solution inspired other nonprofit organizations in their region.

The DIY guide to building your first business app

You might think that building apps would require teams of developers to write the code line by line. In the past, it would have. But today, with an innovative approach known as “low-code” development, you can build them yourself.

With Microsoft Power Apps and Power Automate, you can rapidly automate processes and build custom apps to meet your needs. These solutions connect to a wide range of data sources for maximum flexibility, including Office 365 and SharePoint. Learn how to turn your ideas into apps with no coding experience required. Access the e-book now.