Platform Banner

Lists - The right column type for each data set Tutorial

Unlock the potential of Microsoft Lists with our guide on selecting the right column type for each data set. Dive into the diverse options like text, choice, date, and location fields, each designed to enhance your data organization. Explore unique features and recommendations to optimize your lists today!

02:35
150 views

Available in Microsoft365

00:00:03

it is possible to choose from a wide range of column types depending on your needs.

00:00:09

The icon in front of the header symbolizes the chosen type.

00:00:14

To create a column,

00:00:15

begin by clicking on the button to add a column.

00:00:18

Microsoft Lists will then offer a selection of types to choose from.

00:00:22

By scrolling to the bottom of the window,

00:00:24

the button,

00:00:24

See all column types ensures that all types are available for selection.

00:00:29

Each column type comes with its own options and specific features.

00:00:33

It is possible to change the type before saving.

00:00:37

Here I am creating a text column

00:00:39

that can be configured in terms of maximum input length,

00:00:42

default value,

00:00:43

or whether input is required.

00:00:50

In a choice type column,

00:00:51

I offer selectable items by customizing the labels and colors of each item.

00:00:57

In this case,

00:00:58

I allow users to input an item that is not in the list.

00:01:03

Options related to the appearance or multi-selection

00:01:06

are also available.

00:01:10

Date fields will offer a mini calendar for selection.

00:01:13

The date can be returned in the standard raw format

00:01:16

or in a simplified

00:01:18

and user fashion display format.

00:01:22

The person column type will allow during input to associate a

00:01:25

username with a list item through their name or email address,

00:01:29

if applicable,

00:01:29

with or without including their profile picture.

00:01:33

The location column type can automatically generate

00:01:36

complementary fields

00:01:38

based on the entered address as shown here.

00:01:42

Be aware that an unrecognized address will

00:01:44

only populate the initially created field.

00:01:48

There's a range of possibilities and options depending on the chosen column type,

00:01:53

which you can explore to find the most appropriate type for your needs.

00:01:57

Some columns are optimized for storing text,

00:01:59

whether short or long for data entries or for referencing contacts.

00:02:04

Others will offer choice lists,

00:02:05

a binary checkbox system,

00:02:08

classic numerical values,

00:02:09

or optimized formats for storing monetary values.

00:02:13

The ability to refer to a multi-column geographical location

00:02:17

is also a plus,

00:02:18

as is the possibility of storing a hyperlink,

00:02:21

an image,

00:02:22

or a rating field.

00:02:24

I recommend experimenting on your own and exploring

00:02:27

beyond what we have covered in this tutorial,

00:02:29

to discover the options associated with the various column types.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

258 Views

Microsoft Lists - Getting started

Discover how Microsoft Lists simplifies data organization with powerful customization and collaboration features far beyond a basic spreadsh...

ALL COURSES