TextToTable
Paste & Convert
Conversion Tutorial5 min read• Updated 2026-11-01

How to Convert Pipe-Delimited (|) Text Into Excel

Pipe-delimited text (also called vertical bar or PSV) is common in database dumps, mainframe exports, and Markdown documentation, but Excel does not recognize pipes as a default separator on double-click.

Quick Resolution (Direct Answer)

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 (|).

In This Guide

1. Why Does This Problem Happen? (Root Causes)

Non-Standard Default Delimiter: Operating systems and spreadsheet applications support commas and tabs by default; pipes require manual configuration.

Markdown Table Syntax: Markdown tables include leading and trailing pipes (`| Col1 | Col2 |`) and divider rows (`|---|---|`) that must be stripped before spreadsheet calculation.

Database Shell Exports: Command line tools (psql, mysql, sqlite3) output query results with pipe boundaries that include trailing spaces.

2. How to Fix It (Step-by-Step Methods)

1

Step 1: Paste Pipe Text into TextToTable

Copy your pipe data directly from your terminal, SQL editor, or Markdown document and paste it into TextToTable.

2

Step 2: Auto-Detection & Markdown Cleaning

TextToTable detects the pipe (`|`) delimiter with high confidence. It automatically recognizes and removes Markdown alignment rows (`|---|---|`) and trims extra spaces around cell contents.

3

Step 3: Export Clean Table

Click "Copy to Excel" to paste directly into your open spreadsheet, or click "Download XLSX" for a styled workbook.

3. Verified Test Fixture & Output

Reproducible test input and the verified multi-column result.

Test in Tool→
Raw Input TextUnformatted Data
| AccountID | ClientName | Region | MonthlySpend |
|---|---|---|---|
| ACT-101 | Horizon Media | North America | $12,400 |
| ACT-102 | Summit Retail | Europe | $8,950 |
| ACT-103 | Nexus Cloud | Asia-Pacific | $15,200 |
Expected Structured Output✓ Clean Excel Grid
AccountIDClientNameRegionMonthlySpend
ACT-101Horizon MediaNorth America$12,400
ACT-102Summit RetailEurope$8,950
ACT-103Nexus CloudAsia-Pacific$15,200

4. Common Pitfalls to Avoid

⚠️ Caution:Leaving the Markdown header separator row (`|---|---|`) in the data, which creates an invalid second row in Excel.
⚠️ Caution:Pasting pipes into Excel without pre-converting, leaving all values in Column A separated by visible bars.

5. Frequently Asked Questions

Why do database administrators prefer pipe delimiters over commas?

Pipes (|) rarely appear in human text, company names, or addresses, minimizing the risk of delimiter collisions without requiring complex quote-wrapping rules.

Can Excel save a spreadsheet as pipe-delimited?

Not directly through "Save As". You must save as CSV and change your Windows list separator in Control Panel, or paste your Excel table into TextToTable and select Pipe as your custom export delimiter.

Related Guides & Tutorials

Technical Comparison

CSV vs TSV: Differences, Structure, Pros & Cons, and Use Cases

Detailed technical comparison between CSV (Comma-Separated Values) and TSV (Tab-Separated Values). Learn why TSV is the clipboard language of spreadsheets.

Step-by-Step Tutorial

How to Split Text Into Columns in Excel (Step-by-Step Guide)

Complete tutorial on splitting plain text into multiple columns in Excel. Covers the Text to Columns wizard, TEXTSPLIT formulas, Flash Fill, and common mistakes.

Authoritative Technical References & Standards