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

multiple-worksheets.php View article

<?php

require 'vendor/autoload.php';

use \PhpOffice\PhpSpreadsheet\Spreadsheet;
use \PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();

// The workbook already has one sheet — rename it and fill it.
$users = $spreadsheet->getActiveSheet();
$users->setTitle('Users');
$users->fromArray([
    ['id', 'name', 'email'],
    [1, 'John Doe', 'john@example.com'],
    [2, 'Jane Roe', 'jane@example.com'],
]);

// Add a second sheet with createSheet() and give it a name.
$products = $spreadsheet->createSheet();
$products->setTitle('Products');
$products->fromArray([
    ['sku', 'product', 'price'],
    ['A-100', 'Keyboard', 49.90],
    ['A-200', 'Mouse', 24.50],
]);

// Add a third sheet the same way.
$orders = $spreadsheet->createSheet();
$orders->setTitle('Orders');
$orders->fromArray([
    ['order_id', 'sku', 'qty'],
    [5001, 'A-100', 2],
    [5002, 'A-200', 1],
]);

// Choose which sheet is active (selected) when the file opens.
$spreadsheet->setActiveSheetIndex(0);

$writer = new Xlsx($spreadsheet);
$writer->save('workbook.xlsx');

echo "Done. Wrote workbook.xlsx with "
    . $spreadsheet->getSheetCount() . " sheets: "
    . implode(', ', $spreadsheet->getSheetNames()) . "\n";