From inconsistent sales records to cluttered project trackers, discover how Copilot in Excel can help you clean, organize, and make sense of everyday spreadsheets.
A sales report arrives with a different layout for each month. A customer list has grown through several imports. A project tracker contains three ways of saying “in progress,” and nobody is sure which rows still need attention.
These spreadsheets may contain useful information, but working with them takes more effort than it should. Before you can compare results or decide what to do next, you have to untangle inconsistent entries, unclear headings, and missing details.
Copilot can help with that work inside Excel. The starting point is deciding what you want the spreadsheet to help you do: follow up with customers, compare sales, or see which tasks are falling behind.
Copilot in Excel can help inspect data, suggest or apply changes, create formulas, sort and filter records, and build tables, charts, or PivotTables. You describe the outcome in ordinary language, then review the result.
For example, you might ask it to identify inconsistent product names, organize a report into a clearer table, or summarize records by month after the underlying values have been checked.
You need an account with access to Copilot in Excel. Features depend on your subscription and organization settings. If mode options are available, Chat only lets you discuss the workbook, while editing mode can make changes directly. Use a copy of an important workbook when trying a cleanup for the first time.
Inconsistent text: extra spaces, variations in capitalization, or different labels for the same status or category.
Dates and numbers that do not behave as expected: amounts stored as text, mixed date conventions, or values that look similar but cannot be compared reliably.
Repeated or incomplete records: duplicate imports, missing identifiers, blank fields, or entries that need a person to confirm what they mean.
Awkward structure: inconsistent column headings, related information scattered across sheets, or several pieces of information packed into one column.
Poor readability: crowded columns, no useful filters, or important exceptions buried in a long list.
Some of these are straightforward formatting changes. Others require a decision about the data itself. Tell Copilot which rules to apply and which uncertain entries to flag.
Imagine you have combined contact lists from an event, a website form, and an older spreadsheet. One file uses “Company,” another uses “Organization,” and some contacts appear more than once. You want a usable follow-up list without losing details from the original imports.
Review the contact sheets in this workbook and propose a consistent set of columns for a follow-up list. Identify equivalent headings, extra spaces, missing email addresses, and possible duplicate contacts. Use matching email addresses to flag potential duplicates. Show conflicting details for review rather than choosing which version is correct. Do not change the source sheets yet.
Review the suggested column mapping and duplicate groups. Then ask Copilot to create a consolidated sheet using the rules you approve, keeping a source column and a review note for unresolved records.
The useful result is a list you can filter and work through, with uncertain records clearly marked. Check that all source records are accounted for before accepting any merges. A repeated name by itself is not enough to establish that two contacts are the same person.
Suppose each branch sends a sales sheet with its own headings and product labels. Some amounts are stored as text, dates use different conventions, and the same product appears under several names. A chart built immediately from those sheets could group the data incorrectly.
Inspect the monthly sales sheets and identify what prevents a reliable comparison by month, branch, and product. Check column headings, date formats, amounts stored as text, product-name variations, and currency labels. Propose a shared structure. Flag ambiguous dates and uncertain product matches, and keep different currencies separate. Do not alter the source sheets.
Confirm the date convention for each source and approve a product-name mapping. Then ask Copilot to build a combined table using those decisions, preserving the source sheet and original labels alongside the standardized values.
Check row counts and sales totals against each source, separately for each currency. Once the figures agree, ask for a PivotTable by month and branch, or a chart comparing product sales. Now the organization serves a purpose: making a comparison you can explain.
A team tracker often becomes harder to use as more people contribute. Status labels multiply, due dates are missing, and completed tasks sit beside urgent work. Here, the goal is to make the next actions visible.
Review this project tracker and suggest a clearer working view. Identify inconsistent status labels, missing owners or due dates, and open tasks with due dates before today. Propose mappings to Not started, In progress, Blocked, and Complete. Flag unclear labels for review. Keep task IDs, descriptions, and existing assignments unchanged; do not invent missing owners or dates.
After approving the mappings, ask Copilot to create a cleaned table with filters and highlight overdue open tasks and missing information. You can also request a summary showing the number of open tasks by owner and status.
Check a few tasks you know well and compare the total task count with the source. The finished tracker should make it easier to see who needs a follow-up, which work is blocked, and what information the team still needs to supply.
Choose the problem that most often slows you down in your own spreadsheets. Start there, review the result, and keep the rules that worked. Over time, those rules can become a repeatable way to prepare each new report or import.
Product guidance checked September 23, 2026. References: Microsoft Support: Get started with Copilot in Excel · Microsoft Support: Copilot in Excel FAQ
Learn how to make clearer requests in our prompting guide
For a broader introduction to using AI in everyday life, explore Mastering AI for Everyone.
