Remove Tabs: When One Excel Column Becomes Two Fields
Copying a single column out of Excel often drags a trailing tab with it, and a single-line input field reads that as a column break. Deleting the tab joins the text back up, which is what a search box or a tag field wants.
When deleting tabs is the right move
Copying one column of cells from Excel usually leaves a tab at the end of each value. Pasted into a field that accepts a single line, the tab acts as a column separator, so the value is split in two or the submit fails validation. Deleting it is more thorough than replacing it with a space, which can end up inside the value.
The same applies to fixed-width text exported from older systems: fields are separated by tabs, but you only need one continuous piece of text, or you want to join several into a single tag. Removing the separators matches the goal better than turning them into spaces.
- Single Excel column pasted into a one-line field
- Joining fixed-width text from legacy exports
- Tags and keywords without separators
How to delete tabs without collateral damage
Only the tab character (U+0009) is removed. ASCII spaces, full-width spaces, and other whitespace survive, so indentation spaces are untouched. But if two words were separated only by a tab, they now touch: a label, a tab, and a name become one run-on string.
When the gap matters, decide how many spaces you actually want and use the tabs-to-spaces tool instead. Delete is for removing separators while keeping the spaces that were already there. The two can be combined: convert first and collapse, or delete and add spacing by hand.
- Only tabs are removed; all spaces stay
- Text on either side merges, so use tabs-to-spaces for gaps
- Tabs are invisible, so confirm they exist first
Where it stops, and what to use instead
It does not distinguish a tab used as a separator from a tab used as indentation, and removes both. In a source file indented with tabs, deleting them destroys the structure, so use your editor's convert-indentation command for code instead.
It also cannot remove only leading or trailing tabs, or collapse consecutive tabs into one. Those need regex in an editor, for example replacing a run of tabs with a single space, or matching only tabs at the start of a line.
- No distinction between separators and indentation
- Do not use it on tab-indented source files
- Precise control needs regex
FAQ
Why did two pieces of text merge into one word?
Deleting the tab removes the only separator, so a label, a tab, and a name become one run-on string. Use the tabs-to-spaces tool instead when you need the gap kept.
Does it remove spaces and other invisible characters too?
No. Only the tab character (U+0009) is matched; ASCII spaces, full-width spaces, and other whitespace are left alone, so indentation spaces survive.
Can it remove only the tabs at the start of each line?
No. Every tab is removed regardless of position. Stripping leading indentation needs a regex replace such as a caret followed by one or more tabs in an editor, or the trim-line-ends tool for leading whitespace.
Related tool：Remove Tabs