Excel Column Helper
Paste columns from two sheets, clean them, build formulas, and troubleshoot data.
Sheet 1 – Input
Clean options (Sheet 1)
Text (trim, collapse spaces, uppercase)
Numeric (trim, keep digits, decimal)
ID / SKU (trim, keep as-is except spaces)
Clean Sheet 1
Copy Input
Copy Cleaned
Send Cleaned → Input
Clear
Sheet 1 – Output
Sheet 2 – Input
Clean options (Sheet 2)
Text (trim, collapse spaces, uppercase)
Numeric (trim, keep digits, decimal)
ID / SKU (trim, keep as-is except spaces)
Clean Sheet 2
Copy Input
Copy Cleaned
Send Cleaned → Input
Clear
Sheet 2 – Output
Formula Builder
Formula type
MATCH
VLOOKUP
XLOOKUP
INDEX+MATCH
FILTER
Array compare
IFERROR wrapper
Custom
Coordinates / Ranges
Row (e.g. 2):
Col (letter, e.g. A):
Lookup range (e.g. Sheet2!A:A):
Return range (for VLOOKUP / INDEX, etc.):
Current sheet name:
Description / Notes
Build Formula
Copy Formula
Clear Formula Area
Formula Output
Data Trouble Sleuth
Analyze
Copy Analysis
Clear Sleuth
Analysis Output