PHPSpreadsheet · Google Sheets API · Excel
Spreadsheets, driven by code.
Hands-on PHP tutorials for working with Excel and Google Sheets — read and
write .xlsx, convert files to JSON, stream downloads in the
browser, and insert images, formulas, and styling. Every guide ships with
code you can copy, run, and adapt.
Latest complete code
<?php require 'vendor/autoload.php'; use \PhpOffice\PhpSpreadsheet\Spreadsheet; use \PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $worksheet = $spreadsheet->getActiveSheet(); $worksheet->fromArray([ ['id', 'name', 'email'], [1, 'John Doe', 'john@example.com'], [2, 'Jane Roe', 'jane@example.com'], [3, 'Sam Poe', 'sam@example.com'], ], null, 'A1'); $filename = 'users.xlsx'; header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment; filename="' . $filename . '"'); header('Cache-Control: max-age=0'); while (ob_get_level() > 0) { ob_end_clean(); } $writer = new Xlsx($spreadsheet); $writer->save('php://output'); exit;
The full script from Download Excel Files In The Browser In PHP Using PHPSpreadSheet — copy, run, adapt.
Key methods
IOFactory::load()
PhpSpreadsheet
getActiveSheet()
PhpSpreadsheet
fromArray()
PhpSpreadsheet
getCalculatedValue()
PhpSpreadsheet
save('php://output')
PhpSpreadsheet
spreadsheets_values->get()
Google Sheets
spreadsheets_values->update()
Google Sheets
spreadsheets->create()
Google Sheets
json_encode()
PHP
header()
PHP
Latest articles
Download Excel Files In The Browser In PHP Using PHPSpreadSheet
July 18, 2026
How to Convert an Excel File to JSON Using PhpSpreadsheet
July 17, 2026
Convert HTML Table Into Excel
July 16, 2023
Create a Grocery List Template in Excel
May 14, 2023
Insert Pictures In Excel Files In PHP Using PHPSpreadSheet
May 6, 2023
Add Header Logo In Excel Files In PHP Using PHPSpreadSheet
May 3, 2023
Add Cell Borders
May 1, 2023
Unmerge Cells
May 1, 2023
Count Google SpreadSheets Cells With Text In PHP Using Google Sheets API PHP Client
April 29, 2023
Browse by technique