Practical spreadsheet guide

How to split copied data into columns

Text copied from an email, PDF, website, or report can look like a table while behaving like one long spreadsheet cell. The safest repair is to identify the real separator, preview every row, and check values that contain commas before importing the result.

First identify what separates the columns

A spreadsheet needs a consistent boundary between fields. Common boundaries are commas, tab characters, semicolons, or two or more spaces. A table copied from a PDF may contain visual spacing without a true delimiter.

Date        Order_ID    Amount      Region
09/15/2026  ORD-1042    $1,200.50   North East
09/16/2026  ORD-1043    $45.00      South

Date,Order_ID,Amount,Region
09/15/2026,ORD-1042,"$1,200.50",North East
09/16/2026,ORD-1043,$45.00,South

Why selecting “comma” can still break the table

A comma can be both a field separator and part of a value. The amount $1,200.50 must be quoted in a CSV file so its comma remains inside one cell. Names such as Smith, Jordan require the same treatment. Splitting every comma without parsing quotation marks creates extra columns.

Tabs can be safer for copied spreadsheet ranges because ordinary text rarely contains a tab. Semicolons are also common when a computer’s regional settings use commas for decimal values.

Preview the table before exporting

1. Paste the copied data into the TextGleam CSV and table cleaner.
2. Select Convert to interactive table.
3. Check that each header has the right values beneath it.
4. Scroll sideways on a phone to inspect every column.
5. Edit shifted cells before downloading CSV or Excel.

Preview and split copied data →

Use Excel or Google Sheets when the separator is already reliable

Excel’s Text to Columns wizard supports delimited input and lets you choose delimiters such as commas or spaces while previewing the result. See Microsoft’s Text to Columns instructions.

Google Sheets provides Data → Split text to columns and can detect a separator automatically. It also includes separate cleanup commands for duplicate rows and extra spaces. See Google’s spreadsheet cleanup instructions.

Use TextGleam first when the source mixes repeated spaces with comma-containing values, comes from a PDF, or needs a visual check before it reaches a spreadsheet.

Check values that spreadsheets may reinterpret

• Leading zeros: ZIP codes, account IDs, and product codes may need a text column type.
• Dates: 09/10/2026 can mean different dates under different regional conventions.
• Large identifiers: Long numbers can be displayed in scientific notation or rounded.
• Currency: Confirm decimal and thousands separators after import.
• Line breaks: A quoted multiline value should remain one cell rather than becoming another row.

Final column checklist

• Every header describes the values below it.
• Every row has the expected number of cells.
• Comma-containing values remain in one column.
• Blank columns are truly empty before removal.
• Duplicate removal did not erase valid repeated activity.
• Record counts and totals still match the source.

TextGleam’s cleanup and table preview run in the browser. The tool can repair structure, but you should still compare important records and totals with the original document.