Data types can help you achieve real-life goals more easily with the power and flexibility of Microsoft Excel. No more pasting from browsers or skimming search results, data types bring facts and data from trusted sources right into Excel.
Our data type templates help get things done faster, from comparing colleges to tracking investments to planning a movie night and more. In this post, we’d like to highlight what you can do with the new data types and provide links to the templates we've created to help you get started.
Get the help you need to choose a college in the United States. Learn about the colleges you're interested in, compare colleges to narrow down your choices, and keep track of your applications after you're decided to apply.
Relocate to a new city with confidence. Learn about the cities you're interested in, compare cities to narrow down your choice, and keep track of the things you need to do after you've decided to move.
Keep an eye on your portfolio by entering stocks and ETF’s you own to monitor trends and compare stocks. The data can be refreshed to make sure you’re always up to date with the current prices.
How to use data types
Open a blank Excel workbook.
Type “Earth” into A1.
To convert the text into a data type, select A1, and then select Data > expand the Data Types gallery > select Space .
See available data you can work with by selecting the icon next to Earth to view the card.
Insert data into the sheet by hovering over a field in the card and select the Insert Data button that appears. Otherwise, select the cell containing Earth and click the Insert Data button on the top right corner of the cell.
To use the new data types and templates, you need:
A Microsoft 365 Family or Personal subscription with the English editing language added to your Office Language Preferences.
To be using Excel on the Web or have joined the Office Insider program:
Windows build 16.0.13426.20184: all subscribers in the Beta Channel and a portion of the subscribers in the Current Channel (Preview) of the Office Insider program.
Macbuild16.44.1206.0: all subscribersin theBetaChanneland a portion of the subscribersin theCurrent Channel (Preview).