Spreadsheet Conversion Guides & Tutorials

A CSV file opens entirely in Column A when Excel does not match the file's separator character. By default, Excel relies on your operating system's regional list separator: US English systems look for commas (,), while European systems look for semicolons (;). If your file uses semicolons, tabs, or pipes on a comma-based system, Excel dumps each line into a single cell. You can fix this immediately by opening Excel, navigating to Data → From Text/CSV to explicitly pick the delimiter, or by pasting the data through TextToTable to auto-detect and copy as Excel-ready columns.

To convert TXT to Excel without losing data, avoid double-clicking or standard copy-pasting. Plain text imports frequently suffer from 4 data loss traps: stripping leading zeros from IDs (e.g. 00123 becomes 123), rounding large numbers into scientific notation (e.g. 16-digit credit cards truncated past 15 digits), mangling dates (converting 1-2 into 02-Jan), and garbling accented characters. The safest approach is to use Excel's Data → From Text/CSV wizard with column data types explicitly set to "Text", or to convert via TextToTable where values are preserved exactly in browser memory.

Excel strips leading zeros because its default parser treats any string of digits as a numerical quantity, where a leading zero has no mathematical value (e.g. 00452 becomes 452). To preserve leading zeros: 1) Prepend an apostrophe before the value in text ('00452), 2) Import via Excel's Data → From Text/CSV and specify the column type as "Text", or 3) Use TextToTable to convert your text into an XLSX file with raw text cell formatting enabled automatically.

The core difference between CSV and TSV is their delimiter character: CSV uses a comma (,) while TSV uses a tab (\t). While CSV is more widely recognized by non-technical users, TSV is technically superior for data containing human prose, addresses, and currency amounts because commas frequently occur naturally in text, requiring complex quotation escaping. Crucially, TSV is the native clipboard language of Microsoft Excel, Google Sheets, and LibreOffice Calc — pasting tab-separated text automatically splits into columns on Ctrl+V without any import wizard.

To split text into columns in Excel: Select the column containing your data, go to the Data tab on the ribbon, and click "Text to Columns". Choose "Delimited" (for commas, tabs, spaces, or semicolons) or "Fixed width" (for character-aligned reports). In step 2, check the box matching your separator. In step 3, select destination cells and set column data formats (choose "Text" for IDs with leading zeros). Finally, click "Finish". Alternatively, in modern Microsoft 365, you can use the formula `=TEXTSPLIT(A1, ",")` to split text dynamically.

A broken CSV delimiter occurs when separator characters appear inconsistently across lines, unescaped commas exist inside text fields, or files mix commas and semicolons. To repair a broken CSV: 1) Open the file in TextToTable to view row column-count warnings, 2) Use the Quick Delimiter chips to test whether Semicolon or Tab resolves the alignment, 3) Use "Normalize Columns" to pad uneven rows, and 4) Re-export as a clean, properly quoted RFC 4180 CSV.

To convert pipe-delimited text (|) into Excel: 1) Paste your pipe data into TextToTable. The tool automatically detects the pipe delimiter, strips Markdown dividers (like |---|---|), and displays a clean table grid. Click "Copy to Excel" to paste directly into your worksheet. 2) In Excel, you can also use Data → From Text/CSV, click the Delimiter dropdown, choose "Custom", and enter the vertical bar character (|).

Under the official IETF RFC 4180 standard, any CSV field that contains a comma must be enclosed in double quotation marks (e.g., "Smith, John"). Furthermore, if the field itself contains literal double quotes, each quotation mark must be escaped by preceding it with another double quote (e.g., "John ""The Boss"" Smith"). If a CSV exports unquoted commas in names, addresses, or prices, parsers have no way of knowing whether the comma is data or a column separator, resulting in misplaced columns.

Fixed-width text formats align columns using space characters at predetermined character positions rather than delimiters like commas or tabs. To convert fixed-width text into a spreadsheet: 1) Paste the text into TextToTable, which detects multiple-space column boundaries automatically while preserving single spaces inside words (e.g. "New York"). Click "Copy to Excel" to paste directly into columns. 2) In Excel, use Data → From Text/CSV or the legacy Text to Columns wizard and select "Fixed width" to manually place column break lines on a character ruler.

When you copy a table from a PDF file, the cell borders and grid coordinates are lost because PDFs store visual glyph positions rather than semantic table structures. Copied PDF text usually pastes as space-padded strings or vertical single-line lists. To convert copied PDF text to Excel: Paste the copied text into TextToTable. The tool detects the space alignment boundaries, reconstructs the grid, ignores soft line breaks, and allows you to edit or normalize rows before clicking "Copy to Excel". Note: This workflow is designed for selectable digital PDF text; scanned paper documents require OCR software first.

Strange characters like "München" or "Café" appear in Excel because the CSV file was saved in UTF-8 without a Byte Order Mark (BOM). When you double-click a CSV, legacy versions of Excel assume the file uses your computer's local ANSI/Windows-1252 code page rather than UTF-8. The multi-byte UTF-8 sequence for accented letters is misinterpreted as two separate ANSI characters (a phenomenon called Mojibake). You can fix this by saving the file as "CSV UTF-8 (Comma delimited) (*.csv)" in Excel, adding the UTF-8 BOM (`EF BB BF`) in Notepad, or importing via Data → From Text/CSV with File Origin set to 65001: Unicode (UTF-8).

Excel changes long numbers and dates because its calculation engine enforces two hardwired rules: 1) The IEEE 754 floating-point standard limits numerical precision to 15 significant digits. Any 16-digit number (like a credit card or barcode) is converted to scientific notation (e.g. 4.53211E+15) and all digits after the 15th are permanently replaced with zeros. 2) Excel's auto-detection heuristics aggressively convert any string matching common date formats (e.g. 1-2, 10/12, MAR-15) into serial date numbers. To prevent this, never open raw CSVs by double-clicking; import via Data → From Text/CSV and specify the column format as "Text", or convert via TextToTable where raw string values are preserved.

To convert bank statement text to Excel without scrambling columns or exposing confidential financial records to third-party servers, copy the transaction lines from your online banking portal or plain text export, paste them into TextToTable's free browser converter, and let the parser auto-detect whether your columns are separated by tabs, commas, or multiple spaces. Verify the preview table, click "Copy to Excel", and press Ctrl+V in your active spreadsheet. Because conversion runs 100% in client-side memory, your account numbers, payee details, and balances never leave your device.