CSV library

Writing CSV and TSV Files

Generate atomic, Excel-friendly delimited files with BOM, encoding, dialect, and injection controls.

Level: Intermediate
Reading time: 7 min
Package: mnb/mnb-phpexcel-csv
Updated: August 1, 2026

Csv::write()CsvDialect::resolve()

Write an Excel-friendly CSV#

Csv::write($rows, 'report.csv', [
    'with_header' => true,
    'dialect' => 'excel',
    'encoding' => 'UTF-8',
    'bom' => true,
    'injection_policy' => 'escape',
]);

Choose a dialect preset#

Preset	Delimiter	Line ending	BOM
`excel`	Comma	CRLF	Yes
`excel_tab`	Tab	CRLF	Yes
`semicolon`	Semicolon	CRLF	Yes
`unix`	Comma	LF	No
`pipe`	Pipe	LF	No

Prevent formula injection#

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue