Skip to main content

Microsoft now lets you bring your own data types to Excel

Over the course of the last few years, Microsoft started adding the concept of ‘data types’ to Excel, that is, the ability to pull in geography and real-time stock data from the cloud, for example. Thanks to its partnership with Wolfram, Excel now features over 100 of these data types that can flow into a spreadsheet. But you won’t be limited to only these pre-built data types for long. Soon, Excel will also let you bring in your own data types.

That means you can have a ‘customer’ data type, for example, that can bring in rich customer data from a third-party service into Excel. The conduit fort his is either Power BI, which now allows Excel to pull in any data you previously published there, or Microsoft’s Power Query feature in Excel that lets you connect to a wide variety of data sources, including common databases like SQL Server, MySQL and PostreSQL, as well as third-party services like Teradata and Facebook.

“Up to this point, the Excel grid has been flat… it’s two dimensional,” Microsoft’ head of product for Excel, Brian Jones, writes in today’s announcement. “You can lay out numbers, text, and formulas across the flexible grid, and people have built amazing things with those capabilities. Not all data is flat though and forcing data into that 2D structure has its limits. With Data Types we’ve added a 3rd dimension to what you can build with Excel. Any cell can now contain a rich set of structured data… in just a single cell.”

The promise here is that this will make Excel more flexible and I’m sure a lot of enterprises will adapt these capabilities. These companies aren’t likely to move to Airtable or similar Excel-like tools anytime soon but have data analysis needs that are only increasing now that every company gathers more data than it knows what to do with. This is also a feature that none of Excel’s competitors currently offer, including Google Sheets.



from TechCrunch https://ift.tt/2G8zUde
via IFTTT

Comments

Popular posts from this blog

Apple’s AI Push: Everything We Know About Apple Intelligence So Far

Apple’s WWDC 2025 confirmed what many suspected: Apple is finally making a serious leap into artificial intelligence. Dubbed “Apple Intelligence,” the suite of AI-powered tools, enhancements, and integrations marks the company’s biggest software evolution in a decade. But unlike competitors racing to plug AI into everything, Apple is taking a slower, more deliberate approach — one rooted in privacy, on-device processing, and ecosystem synergy. If you’re wondering what Apple Intelligence actually is, how it works, and what it means for your iPhone, iPad, or Mac, you’re in the right place. This article breaks it all down.   What Is Apple Intelligence? Let’s get the terminology clear first. Apple Intelligence isn’t a product — it’s a platform. It’s not just a chatbot. It’s a system-wide integration of generative AI, machine learning, and personal context awareness, embedded across Apple’s OS platforms. Think of it as a foundational AI layer stitched into iOS 18, iPadOS 18, and m...

The Silent Revolution of On-Device AI: Why the Cloud Is No Longer King

Introduction For years, artificial intelligence has meant one thing: the cloud. Whether you’re asking ChatGPT a question, editing a photo with AI tools, or getting recommendations on Netflix — those decisions happen on distant servers, not your device. But that’s changing. Thanks to major advances in silicon, model compression, and memory architecture, AI is quietly migrating from giant data centres to the palm of your hand. Your phone, your laptop, your smartwatch — all are becoming AI engines in their own right. It’s a shift that redefines not just how AI works, but who controls it, how private it is, and what it can do for you. This article explores the rise of on-device AI — how it works, why it matters, and why the cloud’s days as the centre of the AI universe might be numbered. What Is On-Device AI? On-device AI refers to machine learning models that run locally on your smartphone, tablet, laptop, or edge device — without needing constant access to the cloud. In practi...

Max Q: Psyche(d)

In this issue: SpaceX launches NASA asteroid mission, news from Relativity Space and more. © 2023 TechCrunch. All rights reserved. For personal use only. from TechCrunch https://ift.tt/h6Kjrde via IFTTT