Let’s talk

One operator. Three steps. One workflow in use.

Copilot in Excel now tidies your messy sheets

Excel's Copilot can now spot messy dates, odd capitals and mismatched categories in your sheets, then wait for your nod before fixing anything.

The Friday chore, mostly gone

You know that spreadsheet. The CRM export where half the company names are in capitals, the dates come in three formats, and "Spain", "spain" and "ES" all mean the same thing. Someone on your team spends an hour every week making it behave.

Microsoft's November Copilot update adds a clean data skill to Excel that does that tidying for you. It catches inconsistent capitalisation, formatting errors, mixed-up date formats and categories that don't match. According to Changing Social, it also flags duplicates and cells holding the wrong kind of data.

The part I like

It doesn't just go ahead and change things. It suggests each fix, and you approve it. That's the right instinct. Your data stays yours, and nobody wakes up to a list that was quietly "improved" into nonsense.

The same update brings accounting skills that help finance teams reconcile accounts and prepare journals, with every change visible and reversible. There's also an interactive canvas that turns your data into a live report of charts. Both are rolling out to everyone this month.

What it changes

No new tool, no new login. The cleanup happens inside the spreadsheet your team already opens every morning. Form responses, shared contact lists, monthly exports: less fiddling, more time for the work that actually needs a person.

Words worth knowing

  • Copilot: Microsoft's AI assistant, built into Excel, Word and Outlook.
  • Skill: a specific job an AI assistant knows how to do well, like cleaning a list.
  • Data type: what kind of thing a cell holds, a date, a number or text.
  • Reconcile: checking that two records of the same money agree.

Next time someone sighs at an export, open Copilot and see what it suggests. You still get the final say.

Want something like this working in your team's tools? That's what I do.

Field Notes, every Friday

The week’s best free and open-source tools in one short email. Plus David’s own notes when he has something worth sending.