Convert PRN to CSV

A CSV file is needed when a report must be edited in Excel, imported into a database, shared with software that cannot read printer output, or archived as smaller plain data. The correct conversion method depends on whether the PRN contains delimited text, fixed-width text, or printer-control data.

What the PRN format is

PRN is a filename extension, not one standardized data format. Applications commonly use it for a file created by Print to file; the contents may be plain text, fixed-width report output, PostScript, PCL, or another printer language.

Spreadsheet, accounting, and reporting programs can create text-based PRN files containing columns separated by tabs, commas, or spaces. They may also contain page headers, repeated titles, subtotals, footers, form-feed characters, and other layout data. A printer-driver PRN may contain no recoverable table structure.

Open a copy in Notepad, Notepad++, or Visual Studio Code. Readable rows with consistent delimiters or column positions indicate text data. Unreadable characters or sequences associated with PCL or PostScript indicate printer-language output rather than a directly convertible table.

What the CSV format is

CSV stores records as rows and fields separated by a delimiter, usually a comma. A field containing the delimiter, quotation marks, or line breaks must be quoted and escaped according to CSV rules.

Excel, LibreOffice Calc, database tools, statistical applications, and scripts can import CSV without the original reporting program. CSV does not preserve page layout, fonts, printer commands, formulas, or most report formatting, but it is generally smaller and easier to edit than a print file.

How to convert a text-based PRN

1. Make a backup and open the copy through an import dialog rather than double-clicking it.
2. In LibreOffice Calc, select File → Open. In Excel, select Data → From Text/CSV; if the version does not show a fixed-width option, use its legacy text-import wizard or Calc.
3. Select the source encoding, commonly UTF-8 or Windows-1252. Reopen the file with another encoding if accented characters are corrupted.
4. Choose Separated by and select the delimiter visible in the file: comma, tab, semicolon, or another character. Check the preview for correct column boundaries.
5. For account numbers, postal codes, product codes, and other identifiers, set the column type to Text so leading zeroes are retained.
6. Load the data and select File → Save As. Choose Text CSV (.csv), then confirm the delimiter, encoding, and quote settings.

How to convert fixed-width PRN files

Select Fixed width in the import dialog and place breaks at the actual character positions used by the report. Inspect multiple rows, including rows with long names and missing values, before exporting; one incorrect break can shift every later field.

For repeatable conversions, parse known field positions with Python and write the result using a CSV library:

import csv

with open("report.prn", encoding="cp1252", errors="replace") as source, open("report.csv", "w", newline="", encoding="utf-8") as target:
    writer = csv.writer(target)
    for line in source:
        if line.strip():
            writer.writerow([
                line[0:12].strip(),
                line[12:32].strip(),
                line[32:44].strip()
            ])

Replace the slice positions with the real field boundaries. Do not split on spaces when names or descriptions can contain spaces. Add separate logic to remove page headers, form-feed characters, repeated headings, and subtotal lines when necessary.

How to handle printer-language PRN files

Excel, Calc, and general online converters cannot reliably reconstruct a table from arbitrary PCL or PostScript output. Reopen the original document or report in the application that created the PRN and export its underlying data as CSV, XLSX, XML, or a database extract.

If the source application is unavailable, use the relevant printer-language tools to render the file as readable text or PDF, then reconstruct the columns manually. This is data extraction, not a lossless format conversion; values may be missing, split across lines, or mixed with layout commands.

Using an online converter

Reputable services such as Zamzar and CloudConvert can be tested when the PRN is clearly plain text and contains no confidential information, but support for the .prn extension and CSV output varies. Upload only if the service accepts the file, then verify the output row count, delimiters, encoding, identifiers, dates, and totals.

Do not upload payroll, customer, financial, medical, or proprietary reports unless the service has been approved for that data. Desktop Calc, Excel, or a local Python script is preferable for sensitive files and repeatable processing.

Quality and compatibility checks

• Delete or filter page numbers, repeated titles, headers, footers, and subtotals that were imported as ordinary records.
• CSV does not define column types. Spreadsheet software can alter dates, long numbers, scientific notation, and leading-zero values during import.
• Use UTF-8 when the receiving system supports it. Older Windows software may require Windows-1252 or another locale-specific encoding and may expect semicolons instead of commas.
• Use Calc’s CSV export or Python’s csv module for fields containing commas, quotation marks, or line breaks; manual find-and-replace can produce invalid CSV.
• Compare record counts and several totals with the original report. A visually plausible import can still omit wrapped lines, truncate columns, or combine records.