How To Convert CSV File To Pipe Delimited Text File?

Read CSV with a CSV parser and write the same records with the delimiter set to a pipe character. Replacing commas in the raw text corrupts quoted commas, so delimiter conversion must operate on parsed fields.

Set up the conversion

Use the standard csv module with separate reader and writer settings. newline="" delegates record-newline handling to the module. The output remains a delimited text format with CSV-style quoting: a value containing a pipe, quote or newline is quoted according to the writer’s dialect. Confirm that the destination actually supports those rules.

A reproducible conversion example

import csv

with open("input.csv", encoding="utf-8-sig", newline="") as source, \
     open("output.txt", "w", encoding="utf-8", newline="") as target:
    reader = csv.reader(source, delimiter=",")
    writer = csv.writer(target, delimiter="|", lineterminator="\n")
    for record in reader:
        writer.writerow(record)

The code is an illustrative conversion core. Run it in an isolated working folder with the named test files, install only the dependencies used by the example, and handle its reported errors before applying it to a larger dataset. It does not contact a remote conversion service.

Check the expected result

For the input record 00123,"Lee, Ana","A|B", expect the same three fields when output.txt is parsed using delimiter="|". The comma inside the name must remain a comma, and A|B must remain one field. Add a quoted multiline note and confirm that its content survives. Record counts must come from a parser because physical line counts differ when fields contain newlines.

Format-specific limits

Some older import systems use an unquoted pipe format and forbid pipes or newlines inside values. That is a different specification: reject prohibited characters or follow a documented escape convention instead of assuming CSV quoting will work. A .txt or .dat extension does not define the delimiter, encoding or field layout.

Verify the file contract before using the result

Write down the delimiter, encoding, header names, field order and treatment of empty values. Keep the original file unchanged and write the converted output to a different path. Conversion is successful when a parser for the destination format recovers the intended values; a familiar filename extension or a successful save message is not enough.

Start with a small fixture that contains the cases your real data can contain. Include a leading-zero identifier, a quoted comma, an embedded quotation mark, a blank field and a non-ASCII character. Add a multiline field only if both formats and the receiving system support it. Verify the fixture first, then run a bounded sample from the real input. Record parsed row counts and check the first and last records so truncation or an accidental duplicate header is visible.

Keep identifiers separate from quantities. An account-like or product identifier may contain digits while still being text; converting it to a floating-point number can remove leading zeros or precision. Dates also need an agreed format. When a conversion produces an unexpected blank, investigate whether it came from an empty source cell, a missing field, an invalid value or an automatic missing-value rule. Those conditions can require different downstream handling.

Do not resolve malformed records by silently skipping them unless that behavior is an explicit requirement and the skipped records are reported. Use a failure message that identifies the record or field, retain enough context to correct the input, and avoid exposing sensitive contents in public logs. For production automation, write to a temporary destination and promote it only after validation so a failed run cannot replace a previously good export.

Where the browser tool fits

Convert Text to CSV helps with already extracted plain text. It does not replace a workbook reader, a JSON parser, an XML schema validator or a Parquet engine. Use it only when its input structure and delimiter choices match your actual data. For structured source files, perform the format-aware conversion above and check the result with an independent reader.

Primary reference

Official format and API documentation

Related guides

Convert Pipe-Delimited Text to CSV with a Parser

Convert Pipe-Delimited Text to CSV with a Parser. Preserve field values with explicit parsing, encoding and a checked output round trip.

How To Convert Pipe Delimited CSV File To Excel?

How To Convert Pipe Delimited CSV File To Excel. Check delimiters, column types and the saved file using a small example.

Convert CSV to Comma-Delimited Text Without Breaking Fields

Check whether CSV already contains comma-delimited text, then normalize a known input dialect while preserving quoted commas, empty fields and multiline values.