Catalogue · Excel and data with AI

Clean up a table in one click

You fix inconsistent text and extra spaces in a list typed by hand.

ExcelBeginner0:46Capsule 3 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
Open the Data tab, then Clean Data.
02
Go through the suggestions, card by card.
03
Open a card to see the details of the fixes.
04
Click Apply.

The habit to keep

Read every suggestion, you’re the one who approves.

Worth knowing

What the video does not hide from you.

Clean Data is rolling out gradually in Excel for the web: it may not be on your account yet.

Related capsules

You might also like

Open Copilot in Excel and pick a mode

You open Copilot in Excel and pick the right mode: edit, plan or just answer.

Ask your table a question

You ask your table a question in your own words and get the answer, without changing anything.

ExcelIntermediate

Remove duplicates and split names

You remove duplicates from a list and split title, first name and last name in one request.

Newsletter

Monday's capsule

One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.

Your data stays in the EU. Never sold.