Quick Answer
Text that belongs in columns often arrives as one pasted block. Splitting by the right delimiter turns names, addresses, emails, SKUs, logs, and exported values into spreadsheet-ready columns.
Step-by-Step
- Identify the delimiter that separates each field, such as commas, tabs, pipes, semicolons, spaces, or line breaks.
- Clean extra spaces, empty lines, and inconsistent separators before splitting.
- Choose whether quoted values should stay together when commas appear inside a field.
- Preview the column output and check rows with missing or extra fields.
- Copy the result into Excel, Google Sheets, CSV, or a table tool.
Recommended Workflow
Open the most relevant calculator or utility first, enter a realistic starting point, then use the supporting tools to check assumptions, clean inputs, or prepare the final output.
FAQs
What delimiter should I choose?
Choose the character that consistently separates fields. Tabs and commas are common, but pipes or semicolons can be safer when values contain commas.
Why do some rows split into the wrong number of columns?
Rows may have missing values, extra delimiters, unescaped quotes, or inconsistent formatting.
Should I use Text to Columns or CSV Cleaner?
Use Text to Columns for pasted text. Use CSV Cleaner when you already have a structured CSV file that needs cleanup.