Spreadsheet Data Quality Checker
Measure blanks, outer whitespace, repeated values and case inconsistencies that can interfere with matching and reporting.
Cleanup
Split Delimited Text into Spreadsheet Columns
Convert delimited lines into a structured table and downloadable CSV using comma, tab, semicolon or pipe separators.
Processing boundary: text and files are handled only for this request. Original files are not overwritten. Generated CSV downloads use expiring private tokens.
What this tool does
Text copied from logs, emails and legacy systems often arrives as repeated lines separated by commas, tabs, semicolons or pipes. This utility separates every line into consistent spreadsheet columns, pads shorter rows with blanks and produces a UTF-8 CSV export. The preview makes uneven rows visible before download, which helps catch a wrong delimiter or malformed source. The operation is deliberately literal: quoted-field CSV rules are better handled by the file-based CSV reader, while this tool is intended for raw pasted text.
How to use it
- Paste the delimited lines.
- Select the separator used in the source.
- Review the generated columns and download the CSV.
Limitations and review points
The pasted-text splitter uses a literal delimiter and does not parse escaped delimiters inside quoted fields. Upload a CSV file for standards-aware CSV parsing.
Frequently asked questions
Can it split tab-separated text copied from Excel?
Yes. Choose Tab as the delimiter.
What happens to shorter rows?
They are padded with blank cells to match the widest row.
Will it guess the delimiter?
No. You select the delimiter so the transformation remains predictable.
Related spreadsheet tools
Merge and Combine CSV Files
Append two CSV, TSV or XLSX datasets and align their fields by header name in a downloadable CSV export.
Spreadsheet Column Profiler
Profile column types, blanks, uniqueness, maximum text length and sample values before mapping or importing a dataset.