CSV
CSV Data manipulation
made easy in PHP
composer require league/csv:^9.24.1
Love this package ? Sponsor its development
Highlights
The library was designed for developers who want to deal with CSV data using modern code and without the high levels of bootstrap and low-levels of usefulness provided by existing core functions or third-party code.
Simple and straightforward API
Read from and Write to CSV documents
in a memory efficient and scalable way
Flexible and powerful query features
and array to object mapping.
Transform CSV documents into JSON, XML or HTML
Framework-agnostic
!
Once a new major version is released, the previous stable release remains supported for six more months with patches and security fixes.
Features
Accessing CSV documents records
Reader, the read only connection object enables accessing CSV records easily
use League\Csv\Reader; //load the CSV document from a file path $csv = Reader::createFromPath('/path/to/your/csv/file.csv', 'r'); $csv->setHeaderOffset(0); $header = $csv->getHeader(); //returns the CSV header record //returns all the records as $records = $csv->getRecords(); // an Iterator object containing arrays $records = $csv->getRecordsAsObject(MyDTO::class); //an Iterator object containing MyDTO objects echo $csv->toString(); //returns the CSV document as a string Adding new CSV records is made simple
Writer, the write only connection object enables adding one or more records in one call.
use League\Csv\Writer; $header = ['first name', 'last name', 'email']; $records = [ [1, 2, 3], ['foo', 'bar', 'baz'], ['john', 'doe', 'john.doe@example.com'], ]; //load the CSV document from a string $csv = Writer::createFromString(); //insert the header $csv->insertOne($header); //insert all the records $csv->insertAll($records); echo $csv->toString(); //returns the CSV document as a string Advanced CSV records selection
Statement, the constraint builder object ease CSV records selection
use League\Csv\Reader; use League\Csv\Statement; //load the CSV document from a stream $stream = fopen('/path/to/your/csv/file.csv', 'r'); $csv = Reader::createFromStream($stream); $csv->setDelimiter(';'); $csv->setHeaderOffset(0); //build a statement $stmt = new Statement() ->select('firstname', 'lastname', 'email') ->andWhere('firstname', 'starts with', 'A') ->orderByAsc('email') ->offset(10) ->limit(25); //query your records from the document $records = $stmt->process($csv); foreach ($records as $record) { //do something here } CSV documents converters
Different converters objects ease transforming your CSV documents into other popular formats
use League\Csv\Reader; use League\Csv\XMLConverter; //load the CSV document from a SplFileObject $file = new SplFileObject('/path/to/your/csv/file.csv', 'r'); $csv = Reader::createFromFileObject($file); $converter = new XMLConverter() ->rootElement('csv') ->recordElement('record', 'offset') ->fieldElement(null); $dom = $converter->convert($csv); $dom->formatOutput = true; $dom->encoding = 'iso-8859-15'; echo '<pre>', PHP_EOL; echo htmlentities($dom->saveXML()); // <?xml version="1.0" encoding="iso-8859-15"?> // <csv> // ... // <record offset="71"> // <prenoms>Anaïs</prenoms> // <nombre>137</nombre> // <sexe>F</sexe> // <annee>2004</annee> // </record> // ... // <record offset="1099"> // <prenoms>Anaïs</prenoms> // <nombre>124</nombre> // <sexe>F</sexe> // <annee>2005</annee> // </record> // </csv> Supports PHP Stream filter API
PHP stream filters can directly be used to ease manipulating CSV document
use League\Csv\Reader; use League\Csv\Bom; $csv = Reader::createFromPath('/path/to/your/csv/file.csv', 'r'); $csv->setHeaderOffset(0); if (Bom::tryFromSequence($csv)?->isUtf16() ?? false) { $csv->appendStreamFilterOnRead('convert.iconv.UTF-16/UTF-8'); } foreach ($csv as $record) { //all fields from the record are converted from UTF-16 into UTF-8 charset //and the BOM sequence is removed } 