Microsoft improves data management in Excel

From Microsoft the announcement of a novelty for Excel that extends the potential of the software beyond what has been so far by adding support for custom data formats. This means that it will be possible to manage them in a way defined according to specific needs.

Excel and structured data: news from Microsoft

reference throughout the rest of the spreadsheet. There are many potential uses for this functionality. This is how the Redmond group describes it in their press release.

If, for example, you have a system for tracking your customers and you want to import their data into Excel for analysis, you can now do so in a structured format defined by you or from your company. If you are a Power BI customer, Excel will automatically connect to PowerBI so that any data already published can be easily found and imported into Excel in a structured form. If you don't have Power BI, you can leverage Excel's Power Query technology to manually connect dozens of different types of data sources, specifying how to structure them.



Subscription users Personal or Family to the Microsoft 365 suite or those who use Office 365 and are part of the Insider program are now made available over 100 new types of data to be managed in Excel relating to areas such as the performance of stocks on the stock market to keep investments controlled , the nutritional values ​​of foods to plan a diet and much more, thanks to the Wolfram Alpha service.

Source: Microsoft