Latest in Gear

Image credit: Microsoft

Microsoft Excel spreadsheets now take custom live data

Who knew spreadsheets could be exciting?
Jon Fingas, @jonfingas
October 29, 2020
238 Shares
Share
Tweet
Share

Sponsored Links

Microsoft Excel custom live data types in a spreadsheet
Microsoft

Microsoft is still finding ways to inject drama into spreadsheets. The Verge points out that Microsoft is giving Excel support for custom live data types, expanding the content you can include well past text, numbers and the occasional stock quote. You could slip a country’s data into a cell and create a formula that extracts the most recent population for your sheet, for example.

The approach works by using logic to structure the data you insert into a given cell, using Power BI to connect data types with Excel for business users. Existing cells can even be turned into linked data types, and you can use a Power Query feature to turn imported data into its own type.

Access is limited at first. If you’re an everyday user, you can only use Wolfram Alpha data as part of an Office Insider preview — Microsoft 365 users will have to wait. The corporate crowd can use Power BI data types in Excel for Windows for Microsoft 365 and Office 365 subscribers that also have Power BI Pro service plans.

How well this works will depend on how Microsoft interprets data. You might still have to tweak a dataset if Excel doesn’t know what to make of it. All the same, this could make Excel spreadsheets much more useful for putting data to work — you can easily use live, evolving info instead of painstakingly entering it by hand.

All products recommended by Engadget are selected by our editorial team, independent of our parent company. Some of our stories include affiliate links. If you buy something through one of these links, we may earn an affiliate commission.
Comment
Comments
Share
238 Shares
Share
Tweet
Share

Popular on Engadget

The 2020 Engadget Holiday Gift Guide

The 2020 Engadget Holiday Gift Guide

View
Spotify Wrapped chronicles your 2020 listening habits in a stories-style format

Spotify Wrapped chronicles your 2020 listening habits in a stories-style format

View
Watch the trailer for Studio Ghibli's first fully CG movie

Watch the trailer for Studio Ghibli's first fully CG movie

View
The 'lost' Superman PlayStation game has appeared in public

The 'lost' Superman PlayStation game has appeared in public

View
The Arecibo Observatory's telescope has collapsed

The Arecibo Observatory's telescope has collapsed

View

From around the web

Page 1Page 1ear iconeye iconFill 23text filevr