How to Clean Messy Data in Excel: Step-by-Step Guide

Every data analyst knows the reality: 80% of the work is cleaning data, 20% is actual analysis. Messy data — duplicates, blanks, inconsistent formatting, extra spaces, mixed cases, numbers stored as text, stray non-printable characters — can silently derail any report. A VLOOKUP that returns #N/A, a SUMIFS that undercounts by half, a pivot table with "Kolkata" and "kolkata " showing as different cities: all of these trace back to data quality, not formulas.

This tutorial walks through the ten techniques that handle roughly 95% of real-world cleaning tasks, using only Excel's built-in tools — no add-ins, no Power Query (though Power Query is what you graduate to once these techniques become muscle memory). Every section includes a real-world scenario taken from freelance client work and a beginner pitfall that will save you an hour of backtracking the first time you hit it.

Follow me on Instagram@sagnikteaches

Work on a copy of your data, not the original. Press Ctrl+Shift+End to confirm how far your data extends before you run anything destructive, and keep the row count visible on the status bar so you notice when Remove Duplicates or a delete strips more than you expected. If you are new to Excel, start with the Excel formulas guide — the techniques below assume you are comfortable with relative vs absolute references and the basic structure of an Excel worksheet.

Connect on LinkedInSagnik Bhattacharya

1. Remove Duplicates

The quickest win. Select your data, go to Data → Remove Duplicates. Choose which columns to check for duplicates. Excel will tell you how many duplicates were found and removed.

Subscribe on YouTube@sagnikteaches

Real-world scenario: A marketing agency exports leads from three landing pages into one sheet. The same person has signed up twice using priya@company.com and PRIYA@company.com. Ticking the Email column alone still leaves both rows because Excel treats the two strings as different. The fix is to add a helper column =LOWER(TRIM(B2)), tick only that helper for Remove Duplicates, then delete the helper — you collapse the real duplicates without losing the original casing on the rows that survive.

Beginner pitfall: Remove Duplicates keeps the first occurrence and deletes the rest, which is usually fine — but if the later rows contain updated data (a newer phone number, a corrected postcode), you silently lose that update. Always sort by date descending first, so the freshest row is the one Excel keeps.

Pro tip: Before removing, use conditional formatting to highlight duplicates first (Home → Conditional Formatting → Highlight Cell Rules → Duplicate Values). Review them before deleting — sometimes duplicates are legitimate (two separate orders from the same customer on the same day is not the same as a data-entry error).

2. Fix Extra Spaces

Hidden spaces are the #1 cause of failed VLOOKUP formulas. The TRIM function removes all leading, trailing, and double spaces (it keeps single spaces between words, so "John Smith" with two spaces becomes "John Smith"):

=TRIM(A2)

For non-breaking spaces (CHAR(160), common in data copy-pasted from web pages and PDFs), TRIM alone does nothing because Excel treats CHAR(160) as a real character, not a space. Wrap it in SUBSTITUTE first:

=TRIM(SUBSTITUTE(A2, CHAR(160), " "))

And for fully non-printable garbage (line breaks inside a cell, Ctrl characters from legacy systems), stack CLEAN on top:

=TRIM(CLEAN(SUBSTITUTE(A2, CHAR(160), " ")))

Real-world scenario: A finance team reconciles invoice numbers from the accounting system against a CSV from the bank. The VLOOKUP returns #N/A for about 30 rows. Visual inspection shows nothing wrong. A quick =LEN(A2) on both sides reveals the bank export has a trailing space on every value — invisible, but enough to break equality. Wrapping both lookup columns in TRIM (then pasting as values) fixes every row in one pass.

Beginner pitfall: Running TRIM in a helper column and then deleting the original will blow up the helper's formulas because =TRIM(A2) now points at a deleted cell. The correct order is: TRIM in helper → copy helper → paste special → values into the original → delete helper.

3. Standardise Text Case

"john smith", "JOHN SMITH", and "John Smith" are three different values to Excel. Any downstream COUNTIFS, pivot table, or dedupe will treat them as three distinct rows. Fix it with:

• =UPPER(A2) — JOHN SMITH
• =LOWER(A2) — john smith
• =PROPER(A2) — John Smith

Real-world scenario: An HR team imports employee names from three legacy HRIS systems, each with its own casing convention. Their headcount pivot shows 847 employees; the real number is 812. PROPER across the name column collapses the inflated count back to the truth — 35 ghost rows were just case variations of existing employees.

Beginner pitfall: PROPER is blind to context. It capitalises "mcDonald" as "Mcdonald", "O'Brien" as "O'brien", and acronyms like "NASA" as "Nasa". For a column that contains surnames, emails, or anything with acronyms, LOWER (for emails) or a manual pass with Find & Replace for the known exceptions is safer than trusting PROPER blindly.

4. Find and Replace

Ctrl+H opens Find and Replace. Powerful uses:

• Replace "N/A", "-", "NULL" with blank (leave the "Replace with" field empty)
• Replace old product codes with new ones in bulk after a SKU migration
• Remove specific characters (search for the character, leave "Replace with" empty)
• Use wildcards: * matches any characters, ? matches one character
• Click Options to restrict to "Match case" or "Match entire cell contents" — essential when "IT" (department) must not rewrite every "it" in a description column

Real-world scenario: A logistics team has 40,000 rows of addresses where the state column contains every variant of "Maharashtra": "MH", "maharashtra", "Mahrashtra", "Maha.". One pass of Find & Replace for each known variant → one clean value. Total time: under two minutes. Doing the same thing row by row would take the rest of the afternoon.

Beginner pitfall: Leaving Find & Replace set to "workbook" scope will silently edit cells on every sheet, including reference tables you did not want touched. Before clicking Replace All, check the Within dropdown reads "Sheet", not "Workbook", and select the column first so the replace is scoped to just that column.

5. Split Data with Text to Columns

Got "First Last" in one column? Select the column → Data → Text to Columns:

• Delimited — Split by comma, space, tab, or custom delimiter
• Fixed width — Split at specific character positions (useful for bank statements and legacy mainframe exports)

In Microsoft 365, use the TEXTSPLIT function instead for more flexibility — it spills into a dynamic array and updates automatically when the source changes:

=TEXTSPLIT(A2, " ")
=TEXTSPLIT(A2, {",", ";"})

Real-world scenario: A CRM export dumps "Name | Email | Phone" into a single cell per lead. One pass of Text to Columns with | as a custom delimiter separates 8,000 records into three clean columns. Before pressing Finish, always set the destination cell to an empty column — otherwise Text to Columns overwrites the column to the right of your source without warning.

Beginner pitfall: Text to Columns remembers its last-used settings for the rest of the Excel session. If your previous split was on commas, and you now paste data into a cell, Excel will silently split that paste on commas too. Close and reopen Excel (or run Text to Columns once on a dummy cell with Tab as the delimiter) to reset the behaviour.

6. Handle Blank Cells

To find and fill blanks:

1. Select your range
2. Press Ctrl+G → Special → Blanks
3. All blank cells are now selected
4. Type a value (e.g. 0 or Unknown) or a formula (=A2 to copy from above) and press Ctrl+Enter to fill all at once

Real-world scenario: A pivot table from an accounting export shows "(blank)" as one of the row labels and throws off the totals. The source data has blank Region cells for rows where the exporter skipped the merged header. Ctrl+G → Blanks → =A2 → Ctrl+Enter fills each blank with the Region from the row above. Copy → Paste Special → Values, and the pivot cleans up in one refresh.

Beginner pitfall: Cells that look blank but contain an empty string ("") returned by a formula are not "blank" to Go To Special. =LEN(A2) will return 0 for both, but ISBLANK(A2) will return FALSE for the formula-blank. If Go To Special finds zero blanks when you can clearly see some, replace "" with an actual blank via Find & Replace (search for "", replace with nothing, or better: fix the upstream formula to return NA() or a sentinel like "-" instead).

7. Fix Numbers Stored as Text

If you see numbers left-aligned with a green triangle, they're stored as text. This is the single most common reason a SUM returns 0 when the cells clearly contain numbers. Fix it with any of these:

• Select the cells → click the warning icon → "Convert to Number". To prevent this issue entirely, set up data validation rules on your input columns so the user cannot type text into a numeric field
• Or: create a helper column with =A2*1 or =VALUE(A2), then paste-as-values back
• Or: select all → Data → Text to Columns → Finish (without changing settings) — this is the fastest bulk fix for thousands of rows
• Or: type 1 in an empty cell, copy it, select your text-numbers, Paste Special → Multiply. Every cell is now a real number in place.

Real-world scenario: A sales manager imports daily sales from a bank CSV. =SUM(D:D) returns 0. Every number in column D has a leading apostrophe from the CSV parser (this forces text storage). Text to Columns → Finish converts the entire column to real numbers in one click, and the sum updates instantly.

Beginner pitfall: Numbers with thousands separators ("1,234,567") or currency symbols ("£1,234") imported from web data will resist =VALUE and *1 because Excel cannot coerce them. Use =NUMBERVALUE(A2, ".", ",") in Microsoft 365, or strip the separators first with =VALUE(SUBSTITUTE(SUBSTITUTE(A2, ",", ""), "£", "")).

8. Extract Data with Formulas

Common extraction tasks:

• Extract domain from email: =MID(A2, FIND("@",A2)+1, 100). For more formula techniques, see the advanced formulas guide
• Extract first name: =LEFT(A2, FIND(" ",A2)-1)
• Extract last name (single-space names): =MID(A2, FIND(" ",A2)+1, 100)
• Extract numbers from text: =TEXTBEFORE(A2, " ") or =TEXTAFTER(A2, "-") in Microsoft 365; a combination of MID and SEQUENCE for older versions
• Postcode from a UK address: =TEXTAFTER(A2, ", ", -1) (the -1 takes the last occurrence)

Real-world scenario: A recruiter has 2,400 LinkedIn profile URLs in one column and needs the username for a mail-merge. =TEXTAFTER(A2, "linkedin.com/in/") returns every handle clean in one spill. The same task with old-school LEFT/MID/FIND would take three nested formulas and a lot of off-by-one debugging.

Beginner pitfall: FIND is case-sensitive and errors on a missing match (#VALUE!); SEARCH is case-insensitive and also errors on a missing match. Wrap either in IFERROR(..., "") so a single missing "@" in the email column does not cascade to every downstream formula. For extractions you will run repeatedly, reach for Flash Fill (next section) or Power Query instead — they handle exceptions gracefully where formulas crash.

9. Use Flash Fill

Excel's Flash Fill (Ctrl+E) is magic for pattern-based cleaning. Type the desired result for 2-3 rows in the column next to your source, then press Ctrl+E — Excel detects the pattern and fills the rest. For recurring data cleaning tasks, Power Query can automate the entire process. Flash Fill works for:

• Name reformatting ("Smith, John" → "John Smith")
• Extracting parts of strings (pulling "Pune" out of "Pune, Maharashtra, 411001")
• Combining data from multiple columns ("Priya" + "Sharma" → "Priya Sharma")
• Reformatting phone numbers and dates (9876543210 → +91 98765 43210)
• Masking sensitive data (priya@company.com → p****@company.com)

Real-world scenario: A customer-support team needs to reformat 5,000 product SKUs from SKU-2024-AB-001 to AB001-2024. Type the first two outputs by hand, press Ctrl+E, and Excel works out the pattern and fills the remaining 4,998 rows in under a second. A formula solution would need nested TEXTAFTER + TEXTBEFORE and still break on any SKU that has a different number of hyphens.

Beginner pitfall: Flash Fill is not a live formula — it is a one-time transformation. If new rows arrive, Flash Fill does not extend to them automatically. Either re-run Ctrl+E on the new rows, or replace Flash Fill with a formula/Power Query for any workflow that refreshes. Flash Fill also fails silently on inconsistent patterns; always spot-check rows 50, 500, and 5,000 before trusting the output.

10. Data Cleaning Checklist

Run this checklist top-to-bottom on every dataset before you start any analysis. Most beginners skip it and spend the rest of the day wondering why their pivot totals do not match the finance team's numbers.

Real-world scenario: A freelance analyst builds a reusable cleaning tab in every client workbook: a column for raw data, a column for =TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," "))), then a column with =PROPER(...). New data pastes into column A; columns B and C auto-spill clean output via the Table's calculated columns. The cleaning step becomes a 5-second operation instead of a 30-minute ritual.

Beginner pitfall: "Finished cleaning" is a false summit. Before moving on, run =COUNTA(A:A)-COUNTBLANK(A:A), =SUMPRODUCT(1/COUNTIF(A2:A1000, A2:A1000)) (unique count), and =MIN(A:A)/=MAX(A:A) on numeric columns. If any of those look wrong, you still have messy data — the cleaning is not done yet.

Troubleshooting: Common Data-Cleaning Errors

These are the five errors that trip up almost every beginner the first time they clean real data.

TRIM did nothing — the spaces are still there

The "spaces" are not real spaces — they are non-breaking spaces (CHAR(160)) from a web copy-paste, or zero-width characters from a legacy export. TRIM only handles ASCII space (CHAR(32)). Use =TRIM(CLEAN(SUBSTITUTE(SUBSTITUTE(A2, CHAR(160), " "), CHAR(8203), ""))) to hit the common culprits.

Remove Duplicates says "0 removed" but I can see duplicates

Excel is comparing the entire row — one column has a trailing space, a different case, or an invisible character, so the two rows are not byte-for-byte identical. Add a helper column with =LOWER(TRIM(B2&"|"&C2&"|"&D2)) and tick only that helper column when running Remove Duplicates.

Flash Fill produced the wrong pattern

Your first 2-3 example rows were ambiguous — Flash Fill locked onto a pattern you did not intend. Undo (Ctrl+Z), add a fourth or fifth example row that disambiguates (especially rows that are edge cases — very short names, double-barrelled surnames, missing middle initials), then press Ctrl+E again.

Text to Columns destroyed the column to the right

Text to Columns has no "insert columns" option — it overwrites the columns to the right of your source. Always insert enough empty columns before running it, or change the Destination field on the final wizard step to a cell in an empty area of the sheet.

Numbers-as-text survived =VALUE(A2)

The "numbers" contain non-numeric characters — thousand separators, currency symbols, trailing spaces, or even a non-breaking space before the digit. Strip them first: =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,",",""),"£",""),CHAR(160),"")). For a one-shot bulk fix, Data → Text to Columns → Finish usually handles all of these in one step.

FAQ

How do I clean messy data in Excel?

Work on a copy of the data, never the original. Run this sequence top-to-bottom: (1) TRIM to remove extra spaces and CLEAN for non-printable characters, (2) PROPER/UPPER/LOWER for consistent case, (3) Find & Replace for known variants and typos, (4) Text to Columns or TEXTSPLIT to split combined fields, (5) Remove Duplicates (after deduping a helper column first), (6) Go To Special → Blanks to fill or delete gaps, (7) Text to Columns → Finish to convert numbers-as-text to real numbers. Wrap the whole thing in an Excel Table so new rows inherit the cleaning steps.

What are the most common data quality issues?

Extra leading/trailing spaces (the #1 cause of VLOOKUP #N/A errors), inconsistent capitalisation, duplicate records that differ only by case or whitespace, mixed date formats (DD/MM vs MM/DD), numbers stored as text (SUM returns 0), blank rows splitting a range so pivots stop at the gap, merged cells breaking formulas, and inconsistent category names ("NY" vs "New York" vs "new york "). TRIM + PROPER + Remove Duplicates fix roughly 80% of what you will meet in the wild.

Why does my VLOOKUP return #N/A when I can see the value?

99% of the time it is an invisible space or case-mismatch. Run =LEN(A2) on both the lookup value and the target — if the lengths differ, one side has hidden whitespace. Wrap both in TRIM and paste as values. For case-mismatches, VLOOKUP is case-insensitive by default, so case alone rarely causes #N/A — but it does cause phantom duplicates downstream.

Should I use Flash Fill or formulas for data cleaning?

Flash Fill for one-off cleans on static data — it is faster, requires no formula knowledge, and handles fuzzy patterns gracefully. Formulas (or Power Query) for any workflow that refreshes, because Flash Fill is a one-shot transformation and does not extend to new rows. Rule of thumb: if the data will never change, Flash Fill; if the data will be updated monthly, Power Query.

When should I graduate from formulas to Power Query?

When you catch yourself repeating the same cleaning steps each month, when your workbook is over 50MB, when TRIM + SUBSTITUTE chains become unreadable, or when the data source is multiple files/folders. Power Query records your cleaning steps once and replays them on refresh — a 10-step manual cleaning becomes a one-click Refresh All. Start with the Power Query guide when you hit any of those thresholds.

Related tutorials

• The Complete Excel Formulas Guide (hub) — start here if you are new to Excel; the cleaning techniques above assume formula fluency.
• Excel Data Validation — Prevent Errors Before They Happen — the upstream fix, so bad data never reaches the cleaning stage.
• Excel Power Query — Automate Data Transformation — graduate here once your cleaning workflow is stable.
• Mastering Pivot Tables — A Complete Guide — what you build after the data is clean.
• Excel Tables Best Practices — convert your cleaned range to a Table so new rows auto-inherit the format.
• Advanced Excel Formulas — for the trickier extraction and transformation cases.

Using this in a small business

• Is Your Business Data Ready for AI? A Clean-Up Checklist — a business-wide version of the clean-up in this tutorial.
• How to Prepare Your Business Data for AI, Step by Step — a step-by-step data preparation routine for small businesses.
• Can AI Analyse My Sales Spreadsheet? What to Upload and Check — what to clean in a sales export before AI analyses it.
• Can ChatGPT Read PDFs, Spreadsheets and Photos? What Breaks — what AI can and can't read from a messy file.
• How to Clean Up a Messy CRM With AI — the same clean-up applied to a CRM's contacts and deals.
• How to Find Dead Stock and Slow Movers With AI — clean sales and stock data to find what isn't selling.
• Best AI Inventory Tools for Small Retailers Compared — clean product data is what makes AI stock forecasts work.
• Can AI Read Emailed Orders Into a Wholesaler's System? — turning emailed orders into clean rows for a stock system.
• What to Prepare Before You Set Up AI Marketing — cleaning customer lists before AI marketing tools touch them.
• What Are Diners Really Saying? Using AI to Analyse Your Reviews — tidying exported reviews before AI sorts them into themes.
• Can AI Handle Vaccination and Check-Up Reminders for a Vet? — removing duplicate client records before automated reminders go out.
• Hire a Data Analyst or Use AI for Your Reporting? — A bookshop's reporting problem priced out: when AI tools run by your own team are enough, when a freelance analyst should build the base, and when to hire.
• Salesforce Agentforce for Nonprofits: Is It Worth It for a Small Team? — An independent verdict on Agentforce for small charities: what the free licences cover, what credits cost, what a first agent can do and cheaper options.
• Software for Vacation Rentals Pricing: How AI Sets Nightly Rates — How rental pricing software sets nightly rates from demand, events and lead time, and the floor, ceiling and test rules that protect you.
• Martial Arts School Software: Gradings and Parent Updates Compared — Compare martial arts school software on belt tracking and parent updates, then see where AI-written messages help and what data must stay out.
• AI for Cafés: Plan a Seasonal Drinks Menu From Your Sales Data — Export drink sales, add costs, and have AI rank profit per cup, propose specials from stock, set prices and score a four-week test with keep-or-drop rules.
• AI for Hotel Revenue Management: Weekly Reports for Small Hotels — A twenty-minute Monday routine: a PMS export, a sheet for occupancy, ADR, RevPAR and pace, and an AI summary that ends in questions, not rate orders.
• AI for Restaurant Order Management: One Queue for Every Channel — One queue for every channel: choose where it lives, map each menu with AI, test phone ordering, and run the checks that catch dropped or doubled orders.
• AI for Used Car Sales: Price Each Car Against Local Listings — How to price each used car: comparable adverts into a sheet, mileage and condition adjustments, a floor, range and advertised price, and a guide cross-check.
• AI for a Jewellery Business: Anniversary and Repair Client Messages — Twelve templates for repair-ready and anniversary messages, plus the client segments, consent record and opt-out wording that keep them sendable.
• Barbershop Loyalty Programme: Test Three Rewards on Your Own Numbers — Export a month of visits, remove the names and let an AI assistant cost three reward schemes, so you know which breaks even before you print a card.
• Best AI Tools for CEOs: Build a Monday Briefing From Email and Sales — ChatGPT, Claude, Gemini or Copilot can read your mail, diary and sales sheet and brief you on Monday. Setup, privacy checks and a prompt to copy.
• Cloud Kitchen Inventory: Forecast Prep by Delivery Platform With AI — How to forecast orders per delivery app and daypart, measure promo and weather effects, and turn the result into a prep sheet your kitchen can follow.
• CrossFit Marketing Automation Strategies: On-Ramp Courses and Win-Backs — Eight automations for a foundations course and lapsed members, in build order, with the trigger each one needs, sample wording and the numbers.
• Event Feedback Survey: Write It and Summarise the Answers With AI — Ten event survey questions, a frozen theme codebook, counts you verify in the sheet and a one-page report, with the AI doing the reading.
• Event Venue Marketing: Corporate Away-Day Campaign Written With AI — A six-week corporate away-day campaign for a venue: price the package, write the outreach and follow-up with AI, then draft a case study from a real booking.
• Florist Inventory Management: Use AI to Track Stems and Waste — A stem-and-waste sheet for a one-shop florist: recipes turn bouquets sold into stems used, a waste log shows what to cut, and AI writes the formulas.
• Food Truck Inventory Management: Build Tomorrow's Prep List — A week of sales exports, a recipe matrix, par levels and waste notes turned into a Friday prep list, with the prompt that writes it each evening.
• Gym Referral Programme: Set Rewards and Test the Maths With AI — Test gym referral rewards against how long your members actually stay: a cohort sum, six reward designs, plain wording, a tracking sheet and AI prompts.
• Hardware Store Inventory Management: SKU Clean-Up With AI — Export, de-duplicate and categorise a hardware store's SKUs, then set reorder points from real demand and let AI audit the numbers before you load them.
• How AI Can Help in Sales: A Gift Shop's Bundle and Follow-Up Plan — A gift shop's AI sales plan built on its own till data: three priced bundles, gift-note wording and four follow-up messages for one holiday month.
• How to Price a Wedding Venue: Peak Dates, Midweek and Minimum Spend — A worked price grid for a 120-guest venue: four date tiers, food-and-drink minimums, a midweek discount test and three yearly scenarios modelled with AI.
• How to Use AI in a Trucking Company: Load Paperwork Without Retyping — A step-by-step way to turn rate confirmation PDFs and broker emails into reviewed load records with ChatGPT or Claude and a two-tab sheet.
• Mattress Shop Marketing: Comparison Pages, Offers and Reviews With AI — How an independent mattress shop can use AI for a firmness comparison page, trial wording, offers worked through in numbers, and review requests after delivery.
• Multi-Unit Franchisee: One Weekly AI Summary Across Locations — How a multi-unit franchise owner turns each store's POS export into one KPI sheet, an AI-written weekly summary, an exceptions list and a call sheet.
• Restaurant Supply Ordering: Compare Prices and Draft Orders — A weekly workflow: two supplier price lists in one sheet, AI-flagged cheapest lines and substitutes, price-creep alerts and draft orders from par levels.
• Retail KPI Dashboard in Excel: A Weekly Sheet From Till Data With AI — One week of till data worked through: clean the export, reconcile it, then build a sheet showing sales, margin, stock cover and best and worst sellers.
• Salon Commission or Booth Rent? Model Both on Your Numbers With AI — Work out the break-even rent for a salon chair at three occupancy levels, build the sheet with ChatGPT and check employment status first.
• Supply Chain AI Software: What a Small Importer Needs First — A buying checklist for small importers covering data, lead times, supplier emails and stock sync, with one worked reorder to test any vendor against.
• Travel Agent Commission Tracking: Match Supplier Payments With AI — A manual-to-AI method for matching supplier commission statements to your bookings, with a worked month, prompts and a chase list.
• Wedding Catering Proposals: Tastings, Quotes and Follow-Ups With AI — A caterer's workflow for wedding proposals: tiered quotes you can check, tasting invites, guest dietary lists and follow-ups after the tasting, drafted with AI.
• Sports Club Treasurer's Report: A Plain Summary of the Books With AI — How a volunteer treasurer builds a one-page table, has AI draft a plain summary, three talking points and member answers, then checks every figure.
• AI Pricing for Grocery Stores: Can It Set Short-Date Markdowns? — Turn an expiry list into markdown rules an AI can apply, with one chilled aisle worked through and a two-week check on waste and margin.
• How Can a Coffee Shop Use AI? Start With Supplier Prices — Supplier invoices into a sheet, rises flagged by ChatGPT, then recosted drinks and calm price moves, with worked numbers and Square's Order Guide beta.
• Museums and AI: Turn Visitor Feedback Into Next Season's Plan — How a small museum can sort a season of visitor comments into themes with AI, check the tags, and turn the counts into five fixes for next season.
• Rental Car Companies Using AI: Seven Uses a Small Fleet Can Copy — Seven AI jobs a 20-car rental fleet can copy, each with a worked example, a cost and a check, from rate rules to after-hours calls.
• AI Answering Service for Contractors: 100 Calls Priced Across Five Vendors — Smith.ai, Dialzara, Goodcall, Rosie and Jobber Receptionist priced at 100 calls a month, with the call-length sums and the plan limits that change the bill.
• HVAC Dispatch Software Compared: Which Has AI Routing for Small Fleets? — Jobber, Housecall Pro and ServiceTitan compared on routing limits and plan cost for a four-van HVAC fleet, with a one-week replay test.
• Heating Engineer Software Compared: What AI Adds for a UK Firm — Job management software for a heating firm of one to five people, compared on regional prices, gas and service records and the AI features each really offers.
• Heating Oil Delivery Software: Route Winter Top-Ups With AI Help — A demo checklist for heating oil delivery software: tank-level estimates, run-out priority, route order and truck load, with worked sums and AI uses that fit.
• Six AI Automations an Electrician Can Set Up in a Weekend — Missed-call texts, invoice reminders, quote chasers, review asks, job notes and certificate reminders, ranked by weekend effort, cost and payoff.
• AI in Construction Accounting: Job Costs, WIP and Retainage Checks — Four month-end checks for a small contractor: code invoices, catch job-cost errors, recalculate WIP and track retainage, then hand your accountant a clean pack.
• Best AI for HVAC Business Owners: Find Ageing Systems to Replace — Find customers whose heating or cooling systems are old enough for a replacement conversation, with age bands, letter and text templates, and reply tracking.
• Bill of Quantities Template: A Worked Example Checked With AI — A worked bill of quantities with Excel check formulas and AI prompts for codes, descriptions, units and totals, with measurement left to the QS.
• Construction Job Costing With AI: Find Which Jobs Actually Made Money — Export costs from Xero or QuickBooks, add timesheet labour, build a margin table by job and let AI flag the coding errors that hide losses.
• How to Price Drywall Jobs: Per-Sheet and Per-Square-Foot Rates With AI — One basement priced three ways, with finish levels, ceilings and repair pricing, plus an AI back-test of your per-sheet rate against six past jobs.
• How to Price Pressure Washing Jobs With an AI-Built Rate Card — A rate card built from your hourly cost and timed production rates, with worked driveway, deck and house prices, modifiers and a margin check.
• How to Price Welding Jobs: Build a Rate Sheet With AI — A welding rate build-up, a fixed-price gate quote, per-inch pricing from timing, and an AI check of quoted against actual hours on twelve past jobs.
• Landscape Business AI: Work Out Job Profit by Crew From Timesheets — A worked month for a three-crew landscaping firm: timesheet and materials exports, margin by job type and crew, and the checks to run before acting.
• Plumbers AI: Turn Supplier Price Lists Into a Parts Markup Sheet — A worked example: clean a merchant price list export with AI, apply banded markup by formula, and spot-check the sheet before it feeds your quotes.
• Plumbing Maintenance Plans: AI-Written Offers and Renewals — Sort 200 past customers, price three plan tiers from the cost of a visit, draft the offers with AI and run a five-touch renewal sequence.
• Plumbing Van Stock Lists: Set Reorder Levels From Job History With AI — Export a year of parts, merge duplicate names with AI, rank the top 40, set minimum and maximum levels per van and check them against supplier stock.
• Septic Business Software: What to Ask for Pumping Logs, Reminders and AI — A grouped checklist of what septic business software must record, remind and route, with demo tests, vendor questions and honest limits on what AI adds.
• Tradify for Electricians: Quotes, Jobs and AI SmartTools Set-Up — Tradify set-up steps for an electrician, five quote templates, a CSV price list guide and a SmartTools value test with the sums for Plus.
• Workers' Comp Audit: Get Payroll and Subcontractor Records Ready With AI — A records checklist by trade for a workers' comp audit, with a worked payroll and subcontractor example and prompts that sort the files.
• Can AI Update Your Plumbing Price Book From Supplier Invoices? — Update a plumbing price book from a wholesaler invoice with AI: line extraction, cost comparison, markup rules and the checks that catch mistakes.
• Construction WIP Report: What It Shows and How AI Builds One — What a work-in-progress schedule shows, a three-job worked example of over and under billing, and where AI helps and where it must not.
• How Can AI Help Quantity Surveyors? BoQ Checks, Takeoffs and Cost Reports — Where AI saves a quantity surveyor time on BoQ checks, takeoffs and cost reports, and the checks that must stay manual.
• General Liability Audit for Contractors: What the Auditor Asks For — What a general liability premium audit asks a contractor for, and how to gather gross receipts, subcontract costs and certificates before the auditor calls.
• AI Automation Agency for Real Estate: Scope, Fees and Red Flags — Typical scope, retainer versus project fees, red flags and an in-house alternative for a real estate business weighing an AI automation agency.
• Best AI Tools for Commercial Real Estate Brokers, Compared by Job — A job-by-job comparison of AI tools for commercial brokers, with verified costs, a worked OM example and three stacks by team size.
• AI Commercial Real Estate Underwriting: A First-Pass Model — A worked six-suite example: clean the rent roll, reconcile the operating statement, model NOI and challenge the assumptions with AI.
• AI Lead Generation for Real Estate Agents: No Bought Lists Needed — A consent-first plan for agents: nurture your sphere, publish local answers and capture website enquiries with AI, with no bought or scraped lists.
• AI Staffing Tools for Workforce Planning: Forecast Client Demand — Turn two years of placement history into a seasonal demand forecast and a bench target, using a spreadsheet and AI for the clean-up and cross-check.
• AI for Commercial Appraisers: Lease Abstracts and Income Prep — A lease abstract template with page cites, plus rent roll and expense checks, so AI prepares data and you derive every conclusion.
• HOA Collection Letters With AI: A Consistent Escalation Ladder — A five-rung escalation ladder with fill-in templates, plus a prompt that checks each letter against your notice rules before anyone signs it.
• Is Copilot Worth It for a Small Accounting Firm? Tasks and Seat Cost — Copilot Business at $21 a seat, priced against named Excel, Outlook and Teams tasks for a partner, a senior and a bookkeeper, with a three-seat start.
• AI Tools for Commercial Property Managers: Service Charges, Leases — Three jobs for a commercial property manager: service-charge replies from a building pack, a verified lease-event sheet and owner-report drafts.
• AI for Australian Bookkeepers: BAS Prep, GST Checks and Xero — A quarter-end BAS review that pairs Xero's automation with invoice checks, reconciliations and a documented sign-off.
• AI for House Flipping: Rehab Budgets, Comps and Contractor Quotes — A scope-of-work template, line-item rehab budget, quote comparison table and contingency rule, with AI doing the sorting and you checking the costs.
• AI for Insurance Brokerage: Reconcile Insurer Commission Statements — A routine for parsing insurer commission statements, matching them to a brokerage's policy ledger, listing exceptions and chasing insurers.
• AI for Printing Business Repeat Orders: Reminders and Re-Quote Emails — Turn your order history into reminder emails and re-quotes: find who is due, draft the message with AI, check the price, then approve and send.
• AI to Find Investment Properties: Searches, Filters and Sanity Checks — Use AI to turn buying criteria into searches and a shortlist table, then run red-flag and arithmetic checks before you book a single viewing.
• Bank Statement PDF to Excel With AI: Check Every Line Before Import — A bookkeeper's routine for converting statement PDFs to Excel, then proving the result with balance, count and sign checks before anything is imported.
• AI Bookkeeping in Canada: GST/HST Coding and Remittance Checks — A bookkeeper's review routine for GST/HST coding and payroll remittances: formulas for the maths, AI for the judgement calls, CRA pages for the dates.
• AI Rent Roll Analysis for Multifamily: Reconcile to the Bank — Clean a rent roll, summarise vacancy and delinquency, and tie billed rent to bank deposits with AI, using four prompts and a worked 48-unit example.
• HR Analytics and AI: Analyse Staff Turnover From a Spreadsheet Export — A privacy-first spreadsheet method for checking turnover and absence, with a worked rate and practical prompts.
• Recruitment Agency KPIs: A Weekly Scorecard From Your CRM Export — The handful of weekly recruitment agency KPIs worth tracking, and how AI turns a CRM or ATS export into a one-page scorecard with ratios and commentary.
• Seller Discretionary Earnings With AI: Recast and Find Add-Backs — Follow a broker's recast from reported profit to supported seller discretionary earnings, with a reviewable add-back register.
• Selling an Accounting Practice: Prepare the Due Diligence Pack With AI — Assemble an indexed buyer pack from practice records while controlling when identifiable client files become visible.
• WIP Report Template for Service Firms: Build One From Timesheets — A WIP report for a service firm built from a timesheet export: ageing buckets, write-offs, roll-forward and lock-up days, with sample figures.
• AI in Healthcare Staffing: What a Small Agency Can Automate — Credential expiry chasers, shift-fill messages and timesheet checks a small healthcare staffing agency can automate, and the sign-offs that stay human.
• Can AI Check a VAT Return Before You File? Coding Error Checks — Export your quarter's transactions, run VAT-specific checks for rate, zero-rated and reverse-charge coding errors, and sign off the return yourself.
• ChatGPT for Tax Preparers: How to Redact a Return Before You Paste — A redaction checklist for tax preparers: what counts as taxpayer information, how to strip a PDF properly and which placeholders keep the answer useful.
• How to Use AI to Manage Projects Across Several Clients — One task board, a weekly AI status digest and deadline alerts for a small firm running six client projects at once, with the setup steps and sample outputs.
• Law Firm KPI Dashboard: A Monthly Partner Pack Built With AI — One small firm's monthly partner pack, walked through with sums: the four core KPIs, the export, the prompts and the checks before partners see it.
• Law Firm Knowledge Management: Build a Precedent Library With AI — Build a precedent library your fee earners can search in plain English, with client data kept out and every answer pointing to its source document.
• Lease Renewal Letters With AI: Offers, Reminders and Rent Changes — A renewal sequence a leasing team can run with AI: offer letter, reminders and rent-change wording, with a notice check and sign-off before sending.
• Estate Agent Complaints Handling: AI-Drafted Replies and a Log — A three-stage routine for estate and letting agents: AI drafts the acknowledgement, investigation notes and reply, while a log keeps the redress-scheme trail.
• Can AI Draft Journal Entries? Accruals and Prepayments, Then Review — Trace an invoice to two adjusting entries, review the schedule and keep posting authority with the accountant.
• Can AI Select an Audit Sample? Document and Defend It — A small-practice method for AI-assisted audit sampling: a reproducible selection in Excel or Python and the documentation wording a reviewer can test.
• Can AI Draft Pension Auto-Enrolment Letters? Check Regulator Wording — Use AI to fill, personalise and proof auto-enrolment letters while the regulator's template wording stays untouched, with a line-by-line check.
• Can AI Help Draft a Reconsideration of Value Response? — How an appraiser can use AI to structure a reconsideration of value response and compare cited comps, while the analysis and the decision stay theirs.
• Which AML Client Checks Can an Accountant Automate With AI? — A step-by-step map of client due diligence in an accounting practice: what to automate, what AI may only draft, and what must stay with a person.
• AI for Dental Billing: Claim Checks, Statements and Follow-Up — Use AI to catch claim errors before submission, word patient statements clearly and work an aged-claims queue, with a person approving every code.
• AI for Dentists: Consumables Stock Ordering and Price Checks — Set par levels, build a weekly reorder sheet and compare supplier pack prices for dental consumables with AI, shown on a worked three-chair practice.
• Starting a Mobile Phlebotomy Business: Admin and AI Scheduling — Set up mobile phlebotomy admin in order, then let AI handle scheduling windows, patient reminders and facility invoices, with the rules to check first.
• Pharmacy Near Miss Log: Finding Patterns With AI, Not Blame — How an independent pharmacy can turn a near miss log into themes and actions with AI, using de-identified entries and a blame-free team review.
• Medical Practice KPIs: A Monthly Dashboard Built With AI — Six medical practice KPIs with exact formulas, a worked month of numbers, a sheet layout and an AI prompt for the commentary the partners will read.
• NDIS Plan Manager Invoices: Checking Claims Against Budgets With AI — Field checks, category matching and a flag-and-hold list for provider invoices, with a person approving every payment and participant data kept tight.
• Urgent Care KPI Dashboard: Wait Times and Visits per Hour With AI — Door-to-provider time, left-without-being-seen rate, visits per hour and payer mix, built from a visit export into a sheet with a weekly AI commentary.
• ChatGPT for Veterinarians: Admin Uses, Plans and Client-Data Limits — Practice-admin jobs ChatGPT handles well for vet owners and managers, which plan to pick, and what client data stays out.
• Dental Practice Valuation Explained: Prepare Your Figures With AI — How buyers value a dental practice, and how to use AI to tidy your accounts, add-backs and patient data before a broker or accountant takes over.
• AI Demand Planning Software: Built-In Add-Ons vs a ChatGPT Spreadsheet — Katana and Cin7 add-ons versus a DIY forecast: a backtest on last year's sales shows which one a small product business needs.
• AI for Ecommerce Analytics: Shopify Reports, GA4 or ChatGPT First? — Shopify reports, GA4 or a spreadsheet queried with ChatGPT or Claude: what each shows a small store, what it costs, and the order to set them up.
• ACES and PIES Data: AI Cleans and Checks Your Parts Catalogue — What ACES (fitment) and PIES (product data) cover, the mismatches AI can find between them, and a sample audit that catches wrong fitment early.
• AI Systems for Manufacturing: MRP Add-On or Chatbot on Your Own Data? — Compare native MRP AI replenishment tools against desktop chatbots running over CSV exports, with BOM thresholds and shop-floor tests.
• Cost per Drop: Work Out Delivery Cost From Route and Fuel Data — A step-by-step cost-per-drop calculation from your own route, fuel and driver-time exports, with a worked van example.
• Cost per Mile for Trucking: Work It Out From Your Own Statements — Build a true cost per mile from your own statements, split into fixed and variable, with a worked one-truck example and AI statement-reading prompts.
• AI Automation for Business in the UK: Five Set-Ups and the GDPR Check — Choose a first small-business automation and check what personal data it sends, stores and decides.
• AI Automation for Startups: Seven Workflows, Ranked by Set-Up Effort — Rank lead capture, follow-ups, support, reporting, invoices, onboarding and hiring by the effort to run them well.
• AI for Delivery Managers: A Daily Exceptions Report From Route Exports — A 12-van example shows how to filter route exceptions, check the counts and draft customer updates without inventing ETAs.
• AI for Freight Business Analytics: Margin by Lane From a Spreadsheet — A 200-shipment example shows how to find thin lanes without trusting an unchecked chatbot total.
• AI for Hydroponic Farming: Review Nutrient and pH Logs Each Week — A grower's daily log becomes a weekly exception review, with readings checked against the crop's own target sheet.
• AI for WooCommerce Stores: Descriptions and Support Replies — Draft descriptions in a controlled CSV batch and prepare support replies from verified order details.
• Amazon FBA Reimbursement: Spot Lost and Damaged Stock Using AI — Reconcile three Seller Central reports with AI to find units Amazon lost or damaged and never paid for, and file the claim with evidence.
• Amazon Search Term Report With AI: Find Wasted PPC Spend — Export the search term report, let AI flag terms with clicks but no orders and group them into a negative keyword list, then decide yourself.
• Calibration Log Template: AI Tracks Due Dates for Gauges and Scales — A spreadsheet calibration log with AI-built due dates, status flags and reminder emails, where certificates stay the evidence.
• ChatGPT for Startup Analytics: Read Your Metrics Without an Analyst — A founder's Monday routine: export the numbers, strip customer data, have ChatGPT explain what moved, and re-check every figure in a spreadsheet.
• Cold Chain Temperature Logs: AI Flags Breaches in Logger Exports — How a small food distributor can use AI on logger exports to find breaches, spot gaps and faulty sensors, and draft the corrective-action note.
• Connect Claude to Shopify: What It Can and Can't See — What Claude's Shopify connector reads, what it can change, and the four numbers it never sees, with a worked margin example.
• Customise ChatGPT for Your Business: Projects, Instructions and Files — Build a ChatGPT Project that knows your tone, price list and policies, then prove it works with ten real customer questions.
• Cycle Count Template: AI Plans Counts by ABC Class — Rank stock into A, B and C classes, set how often each is counted, fix the variance thresholds and let AI produce the weekly count sheet.
• Dietary Supplement Claims: What to Cut From AI-Written Product Copy — A practical cut list for AI-written supplement copy: disease claims, cure words, medical comparisons and borrowed reviews, with a review routine.
• Driver Debrief Notes: Turn Voice Memos Into an Exceptions Log — A two-minute voice-memo debrief for drivers, turned by AI into a structured log of damage, delays, access problems and follow-ups.
• EV Fleet Transition: Which Vans to Switch First? Model It With AI — A van-by-van electric switching model for a small fleet, with route data, charging access, total cost and a grant check done by hand.
• Ecommerce Cross-Selling: Find Bundle Pairs in Your Orders With AI — Turn your order export into pair counts, pick three bundles, price them and measure whether average order value rises.
• Ecommerce Return Fraud: Find Repeat Abusers in Your Returns Data — Join orders to returns, rank customers by return rate and value, separate fraud from fit problems, and flag for review without auto-banning.
• Export Certificate of Origin: What AI Prepares, What the Chamber Issues — What AI can safely do before you apply for a certificate of origin, what only the issuing chamber can do, and how to avoid rejections.
• Factory Energy Audit With AI: Find Peak Loads and Idle Waste — A step-by-step factory energy audit from a half-hourly meter export: find the peak, the idle baseload, and what to hand an auditor.
• Failed Deliveries: Sort Driver Notes Into Fixable Causes With AI — Code a month of driver notes into a short list of causes, find repeat addresses and bad time windows, and match each cause to a fix.
• How to Use AI for Self-Employment Tax: A Monthly Set-Aside Sheet — A spreadsheet that turns income, expenses and your tax authority's published rates into one set-aside percentage, built and checked with AI.
• Wholesale Nursery Availability List: AI Builds and Emails It Weekly — A weekly routine that turns a grower's stock sheet into a priced availability list, emails it to trade buyers and marks lines as sold.
• Product Data Cleansing for Shopify: Supplier Sheet to Import File — Map supplier columns to Shopify's product CSV, group variants under one handle, fix SKUs and units, then prove the file with a ten-row test import.
• Scrap Yard Software: Price Sheets, Weighbridge Tickets and Where AI Fits — Daily price sheet, ticket exports checked and turned into monthly statements, and buyer emails: where AI fits around a yard's scales and records.
• Shopify Profit Report With Claude: Add Ad Spend, COGS and Returns — Join four exports in Claude to see profit per order after ads, costs, shipping and returns, with a full worked month.
• Shopify RFM Analysis: Segment Customers With ChatGPT From an Export — Score customers on recency, frequency and spend from a Shopify export, then write one email per segment, keeping personal data minimal.
• Six AI Applications in Manufacturing That Need No New Machines — Six office-side AI jobs for a small factory, each with a worked example, a starting step and the check that keeps it honest.
• Stock Count Variance: Find Why Your Count and System Disagree — A value-first routine for small shops: rank every count variance in dollars, then rule out the three cheap causes before you suspect theft.
• Supplier Scorecard Template: Score Delivery and Quality With AI — Turn a PO export into a one-page supplier score with on-time, in-full and defect rate, using AI for the formulas and the write-up.
• Using AI to Promote Products: A Four-Channel Plan for a Small Brand — One product, four channels: what AI drafts for email, social, marketplace and ads, who approves it, and the sheet that shows what worked.
• Warehouse Slotting: AI Analyses Pick Frequency From a WMS Export — A 200-SKU warehouse walked end to end: the WMS export, the ABC split, which 20 SKUs to move first and when to re-slot.
• WooCommerce Product CSV Import: Clean Supplier Data With AI First — AI cleanup rules for supplier spreadsheets, the exact columns WooCommerce's CSV importer expects, and a 10-row dry run on staging.
• eBay Seller Rating Levels: Audit Defects and Late Shipments With AI — How eBay's seller levels are set, and a weekly routine that turns Seller Hub defect and late-shipment exports into a ranked fix list with AI.
• Scrap Rate Tracking: Group Reject Reasons From Shop Notes With AI — The scrap rate formula, reason codes grouped from free-text shop notes with AI, and a weekly Pareto list operators help you check.
• Can AI Run a Vending Machine Business? Restocks Yes, Servicing No — Use AI to turn machine sales into par levels, a ranked visit list and a slow-seller review, and keep the physical servicing with a person.
• Can AI Schedule Production for a Small Maker? A Spreadsheet Test — A seven-job test of AI scheduling from a spreadsheet: setups, due dates, a rush order, how to check the result and when software is worth buying.
• Airtable vs AppSheet for a Job Tracker: Cost, Offline Use and AI — A six-person trade firm's job tracker priced on Airtable and AppSheet, with offline behaviour, record limits and AI features compared.
• Apollo.io vs HubSpot: Prospect Database or CRM First? — Which to buy first, a prospect database or a CRM, with free-tier limits, seat and credit costs and the order that wastes least.
• Best Dropbox Plan for a Small Business: Storage, Dash and Sign Compared — A five-person Dropbox plan choice that counts storage, Dash search and signature senders instead of guessing from tiers.
• Claude Excel Add-In Cost: Which Plan Do You Need for Claude for Excel? — Price the Claude subscription and test the add-in on a copy of a real workbook before assigning seats.
• Is Salesforce Good for Small Business? Starter Suite vs HubSpot — Salesforce Starter Suite against HubSpot Free, Starter and Professional for a small team: seat costs, admin effort, AI and when to avoid Salesforce.
• Is Zoho Worth It for a Small Business? Free CRM vs the Full Suite — Zoho's free CRM covers three users. Here are the five signs it has run out, and what each paid step costs in money and admin time.
• Julius AI vs ChatGPT for Spreadsheet Analysis: Which Fits You? — Both run code on your spreadsheet. Here are their documented limits, what each shows you, and a 45-minute test to run on your own file.

Sources

• Microsoft Excel Documentation
• Microsoft 365 Blog
• ExcelJet Function Reference