What Is the Split Text Tool?
The Split Text Tool is the exact complement of the Merge Lines tool. It takes a single continuous string and breaks it into separate lines at every occurrence of a delimiter — a comma, pipe, space, semicolon, or any custom character or word. Leading and trailing spaces around each item are trimmed automatically, so your output list is clean from the first paste.
How to Split a Comma-Separated List
- Paste your delimited string (e.g.,
apple, banana, orange) into the left text area. - Set the Delimiter box to the character that separates items — comma by default.
- The tool instantly splits the string and places each item on its own line in the right box.
- Click the copy icon to save the vertical list to your clipboard.
Where Can You Use the Split Text Tool?
Extracting Database IDs
When a developer sends a comma-separated ID list like 1204, 1205, 1206, split it into a vertical column to paste into Excel or Google Sheets for further analysis.
Parsing Log Files
Server logs often delimit fields with a pipe (|) or semicolon. Split each log line on that delimiter to isolate individual fields for review or import.
Keyword List Formatting
CMS platforms like WordPress export tags as comma-separated strings. Split them into a vertical list so you can edit, deduplicate, or sort them before re-importing.
Data Pipeline Prep
Split JSON array values or TSV rows into individual lines before passing them into another text tool (like Sort Lines or Add Prefix/Suffix) for further processing.
Delimiter Options
- Comma (
,): The most common delimiter — splits CSV exports, tag lists, and array literals. - Space: Splits text into individual words. Useful for word-frequency analysis or building word lists.
- Pipe (
|): Splits TSV variants, database exports, and Boolean search results. - Semicolon (
;): Common in European CSV formats and some CMS exports where commas appear in data values. - Custom word or phrase: Type any string — including full words like
ANDorOR. The split is case-sensitive. \n/\t: Type the escape sequence directly to split on actual newlines or tab characters.
Best Practices and Limitations
All splitting runs locally in your browser — no data is uploaded, making it safe for API keys, user IDs, or internal data strings.
The tool trims whitespace from each resulting item and removes empty entries. This means apple,,banana split on comma produces two lines, not three — the empty middle entry is dropped. If you need to preserve empty fields (e.g., for fixed-column data), use a spreadsheet tool that supports empty-cell imports instead.
Share This Split Text Tool
Know someone who needs to parse a delimited list? Share this tool!