Excel and Google Sheets
Split Text Formula Builder
Generate TEXTSPLIT or SPLIT formulas for comma, pipe, tab, space, or custom delimiters.
OpenSpreadsheet tools
Fix spreadsheet problems faster.
Free Excel and Google Sheets tools for cleaning data, building formulas, comparing lists, and fixing everyday spreadsheet issues.
Quick Formula Finder
Pick a task
=TEXTSPLIT(A2,",")
Use this when a cell contains values like "north,west,enterprise".
Featured tools
Featured tools
The six most-used tools in a compact grid.
Data cleaning
Remove Duplicates from a List
Paste a list, remove duplicate rows, optionally sort it, and get formulas for Excel and Sheets.
OpenDate formulas
Date Difference Calculator
Calculate calendar days or business days between two dates and copy spreadsheet formulas.
OpenWhitespace and casing
Spreadsheet Text Cleaner
Trim messy text, collapse repeated spaces, change casing, and copy cleanup formulas.
OpenLookup formulas
XLOOKUP Formula Builder
Build exact-match XLOOKUP formulas and see when VLOOKUP is still acceptable.
OpenData reconciliation
Compare Two Lists
Compare two pasted lists, find missing values and overlaps, and copy formulas for spreadsheet reconciliation.
OpenBrowse by task
Browse by task
Start from the job and jump to the right tool or guide.
Data Cleaning
Data Cleaning
Trim noise, collapse duplicates, and prep imported data.
- Spreadsheet Text Cleaner
- Remove Duplicates from a List
- Clean Imported CSV Data Before It Reaches Your Workbook
Lookup & Formulas
Lookup & Formulas
Build lookup logic and compare results with confidence.
View allDate & Time
Date & Time
Work out deadlines, durations, and working-day logic.
View allImport & Compare
Import & Compare
Check lists, clean imports, and spot missing values fast.
- Compare Two Lists
- Clean Imported CSV Data Before It Reaches Your Workbook
- CSV Preview and TSV Converter
Popular guides
Popular guides
Short, useful articles that support the tools.
Spreadsheet guide
How to Split Text in Excel and Google Sheets
Use TEXTSPLIT in Excel or SPLIT in Google Sheets to separate names, tags, IDs, and imported CSV fields.
Read guideSpreadsheet guide
Remove Duplicates with UNIQUE in Excel and Google Sheets
Learn the clean formula-based way to deduplicate a list without changing your source data.
Read guideSpreadsheet guide
Calculate Days Between Dates in a Spreadsheet
Compare DAYS, subtraction, and NETWORKDAYS for calendar and business-day calculations.
Read guideSpreadsheet guide
XLOOKUP vs VLOOKUP
XLOOKUP is easier to read and safer for exact-match lookups, but VLOOKUP still appears in many legacy workbooks.
Read guide