Runs locally in your browser
Remove leading and trailing spaces or tabs from each line while keeping the text and line order unchanged.
About this tool
Invisible spaces around IDs, emails, SKUs, and copied labels can cause comparisons or database lookups to fail even when the values look identical.
Trimming removes whitespace only at the start and end of each row; spaces inside the value are preserved.
FAQ
No. Internal spaces remain unchanged; only leading and trailing whitespace is removed.
Yes. Leading and trailing tabs are whitespace and are removed.
Related tools
Guides
Learn safe methods to convert Excel columns to SQL IN clauses. Handle apostrophes, leading zeroes, query length limits, and use reusable browser tools.
Read guide →