Download PhpSpreadsheet – PHP Library for Reading and Writing Excel Files

PhpSpreadsheet is a free, open-source PHP library for reading and writing spreadsheet files in a wide variety of formats including XLSX, XLS, ODS, CSV, HTML, and PDF. It is the successor to the popular PHPExcel library and is actively maintained with full support for modern PHP versions.

With PhpSpreadsheet, PHP developers can programmatically create Excel reports, import spreadsheet data into databases, export database records to Excel, generate charts and graphs, apply cell formatting and conditional styles, and protect worksheets — all from within their PHP application without any external dependencies on spreadsheet software.

PhpSpreadsheet is widely used in web applications for generating invoices, financial reports, data exports, and any scenario where structured spreadsheet output is required. It follows PSR standards and integrates cleanly with frameworks like Laravel, Symfony, and Yii.

Key Features

• Read and write XLSX, XLS, ODS, CSV, HTML, Gnumeric, and other spreadsheet formats
• Create charts, apply cell styles, number formats, borders, and conditional formatting
• Formula calculation engine supporting hundreds of Excel-compatible functions
• Merge cells, freeze panes, auto-filter, and data validation support
• Password protection and worksheet/workbook security settings
• PDF and HTML export via Dompdf, TCPDF, or mPDF integrations
• PSR-compliant, composer-installable, and compatible with PHP 7.4 and above

How to Install

1. Click the download button below or install via Composer: composer require phpoffice/phpspreadsheet
2. Include the Composer autoloader in your PHP script: require 'vendor/autoload.php';
3. Create a new spreadsheet: $spreadsheet = new Spreadsheet();
4. Write data to cells: $sheet->setCellValue('A1', 'Hello World');
5. Save to XLSX: (new Xlsx($spreadsheet))->save('output.xlsx');