Practical workflows for diagnosing, cleaning and validating Excel data with tested ChatGPT prompts and verification steps.
Inconsistent dates, mixed formats, extra spaces. Get a tested ChatGPT prompt to fix the whole column at once.
Read workflow →A tested ChatGPT prompt identifies which columns define a true duplicate, which record to keep, and gives you a COUNTIFS formula to verify before you delete anything.
Read workflow →Remove truly empty rows safely, distinguish formula-empty strings, or create a non-destructive cleaned output.
Read workflow →Tested ChatGPT prompts help you remove leading, trailing, extra, and hidden spaces in Excel, including cases where TRIM does not work and lookups return #N/A.
Read workflow →Tested ChatGPT prompts help you convert dates stored as text into real Excel dates, including yyyymmdd values, CSV imports, and dd/mm/yyyy vs mm/dd/yyyy locale problems.
Read workflow →Tested ChatGPT prompts help you match similar customer, company, or supplier names in Excel with Power Query, review ambiguous matches, and handle abbreviations with transformation tables.
Read workflow →Append monthly files with Power Query, preserve source filenames, handle schema changes, and reconcile row counts and control totals.
Read workflow →Choose Text to Columns or TEXTSPLIT, preserve empty fields, handle multiple delimiters, and split on the last delimiter safely.
Read workflow →Convert imported text safely with VALUE or NUMBERVALUE while preserving identifiers, missing values, and locale-specific separators.
Read workflow →