Mastering Data Type Templates in Microsoft Excel: A Step-by-Step Guide

Quick Links

If you’ve ever used Microsoft Excel’s data types feature for details on geography , stocks, food, and more, then you’ll love the addition of templates. Microsoft offers several data types templates to help you track all sorts of things.

These templates help you use the cities data type to plan a relocation, the stocks data type to track your investments, and the food data type to log meals for your diet. But of course, there are more! Here, we’ll help you view and obtain templates as well as work with an example to learn how to use it.

Available Templates and Requirements

You can view and download available templates on Microsoft’s Discover Data Types Templates web page. As of this writing, there are almost a dozen handy templates available, and each has a brief description of how you can use it. You can:

curate a list of your favorite movies.
study the elements with an interactive periodic table.
learn about planets and comets, or stars and constellations.
get help selecting the right college.
obtain details about cities you’re considering moving to and use the checklist.
keep a list of baby names you’re contemplating.
log the food that you eat and set dietary goals, or analyze your favorite recipes for nutrition details.
track your activities and exercise routines.
keep up with your stock portfolio.

The data types feature in Excel is available to Microsoft 365 subscribers as well as to those who use Excel on the web or are part of the Office Insiders Program. You must also be connected to the internet, as the information comes from online sources.

Download a Data Types Template

If you see a template that you want to try, click its name (which is a download link) from Microsoft’s templates website . Depending on whether you use Windows or Mac and which browser you use, you may be asked to save the file or to open it immediately in Excel.

Use a Data Types Template in Microsoft Excel

Once you download a template and open it in Microsoft Excel, it’s ready for use right from the start. However, the “Welcome” tab gives you a helpful, short, and sweet summary of how to use that particular template. Each template is a bit different from the others, but they all begin with you entering a keyword or phrase.

For this how-to, we’re going to use the Movie List template. With this template, you can track your favorite movies, view details like cast and box office totals, and include a rating and review of your own.

Start by entering a keyword or phrase in the appropriate cell that applies to the data type. For the Movie List, you’ll enter a film title.

Once you enter your item, the template takes over and fills in the remaining details.

If for some reason the data for your word or phrase cannot be found, you’ll see a question mark next to it. Click the icon to open the Data Selector sidebar, and then search for and select the correct item.

Some templates have several tabs for you to work with, and the data types that you add populate those, too. For example, our Movie List template has a tab for the actual Movie List as well as tabs for Dashboard and Cast.

The Dashboard shows the films that you add to the list as movie poster images and includes ratings as well as movies by decade and genre.

The Cast tab has a drop-down box at the top that populates with the movies that you add to your list. Select a film from this box and you’ll see the movie’s cast, director(s), and producer(s).

Other tabs in the template can also contain more information. Using our Movie List example, if we visit the Cast tab, we can get more details on a cast member by clicking the contact icon next to their name.

If you’d like to see even more details for your data type that aren’t in the spreadsheet, it’s easy to do. Just click the data type icon next to it. Just like with the cast member icon above, this will open the Data Card. You can drag to resize it or simply scroll through for more information.

After grabbing one of these templates, be sure to check out each tab and icon for more details. When you finish, remember to save the file like any other Microsoft Excel workbook. Then, pop it open and add more data to it anytime!

Windows11

Mastering Data Type Templates in Microsoft Excel: A Step-by-Step Guide