PHPackages                             spatie/simple-excel - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. spatie/simple-excel

ActiveLibrary[PDF & Document Generation](/categories/documents)

spatie/simple-excel
===================

Read and write simple Excel and CSV files

3.9.0(3mo ago)1.4k11.0M↓24.7%13820MITPHPPHP ^8.3CI passing

Since Oct 22Pushed 1w ago20 watchersCompare

[ Source](https://github.com/spatie/simple-excel)[ Packagist](https://packagist.org/packages/spatie/simple-excel)[ Docs](https://github.com/spatie/simple-excel)[ GitHub Sponsors](https://github.com/spatie)[ RSS](/packages/spatie-simple-excel/feed)WikiDiscussions main Synced 1w ago

READMEChangelog (10)Dependencies (6)Versions (56)Used By (20)

Read and write simple Excel and CSV files
=========================================

[](#read-and-write-simple-excel-and-csv-files)

[![Latest Version on Packagist](https://camo.githubusercontent.com/097ba6f87ff82880ee473c40c8deb8e9b844405f6ac44c8af11788e7b5f2604a/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f7370617469652f73696d706c652d657863656c2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/spatie/simple-excel)[![GitHub Workflow Status](https://github.com/spatie/simple-excel/actions/workflows/run-tests.yml/badge.svg)](https://github.com/spatie/simple-excel/actions/workflows/run-tests.yml/badge.svg)[![Total Downloads](https://camo.githubusercontent.com/c6043d7cb3d33414e3d515be7acc7eb907ddae5084cff572045af35ce550644d/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f7370617469652f73696d706c652d657863656c2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/spatie/simple-excel)

This package allows you to easily read and write simple Excel and CSV files. Behind the scenes generators are used to ensure low memory usage, even when working with large files.

Here's an example on how to read an Excel or CSV.

```
use Spatie\SimpleExcel\SimpleExcelReader;

SimpleExcelReader::create($pathToFile)->getRows()
   ->each(function(array $rowProperties) {
        // process the row
    });
```

If `$pathToFile` ends with `.csv` a CSV file is assumed. If it ends with `.xlsx`, an Excel file is assumed.

Support us
----------

[](#support-us)

[![](https://camo.githubusercontent.com/f3efd1451f72de086bb12512dc259a52ef86fc5f08f7743e29883d7a40bec47d/68747470733a2f2f6769746875622d6164732e73332e65752d63656e7472616c2d312e616d617a6f6e6177732e636f6d2f73696d706c652d657863656c2e6a70673f743d31)](https://spatie.be/github-ad-click/simple-excel)

We invest a lot of resources into creating [best in class open source packages](https://spatie.be/open-source). You can support us by [buying one of our paid products](https://spatie.be/open-source/support-us).

We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on [our contact page](https://spatie.be/about-us). We publish all received postcards on [our virtual postcard wall](https://spatie.be/open-source/postcards).

Installation
------------

[](#installation)

You can install the package via composer:

```
composer require spatie/simple-excel
```

Usage
-----

[](#usage)

### Reading a CSV

[](#reading-a-csv)

Imagine you have a CSV with this content.

```
email,first_name
john@example.com,john
jane@example.com,jane
```

```
use Spatie\SimpleExcel\SimpleExcelReader;

// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)->getRows();

$rows->each(function(array $rowProperties) {
   // in the first pass $rowProperties will contain
   // ['email' => 'john@example.com', 'first_name' => 'john']
});
```

#### Reading an Excel file

[](#reading-an-excel-file)

Reading an Excel file is identical to reading a CSV file. Just make sure that the path given to the `create` method of `SimpleExcelReader` ends with `xlsx`.

#### Working with LazyCollections

[](#working-with-lazycollections)

`getRows` will return an instance of [`Illuminate\Support\LazyCollection`](https://laravel.com/docs/master/collections#lazy-collections). This class is part of the Laravel framework. Behind the scenes generators are used, so memory usage will be low, even for large files.

You'll find a list of methods you can use on a `LazyCollection` [in the Laravel documentation](https://laravel.com/docs/master/collections#the-enumerable-contract).

Here's a quick, silly example where we only want to process rows that have a `first_name` that contains more than 5 characters.

```
SimpleExcelReader::create($pathToCsv)->getRows()
    ->filter(function(array $rowProperties) {
       return strlen($rowProperties['first_name']) > 5;
    })
    ->each(function(array $rowProperties) {
        // processing rows
    });
```

#### Reading a file without headers

[](#reading-a-file-without-headers)

If the file you are reading does not contain a header row, then you should use the `noHeaderRow()` method.

```
// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)
    ->noHeaderRow()
    ->getRows()
    ->each(function(array $rowProperties) {
       // in the first pass $rowProperties will contain
       // [0 => 'john@example', 1 => 'john']
});
```

#### Manually setting the headers

[](#manually-setting-the-headers)

If you would like to use a specific array of values for the headers, you can use the `useHeaders()` method.

```
// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)
    ->useHeaders(['email_address', 'given_name'])
    ->getRows()
    ->each(function(array $rowProperties) {
       // in the first pass $rowProperties will contain
       // ['email_address' => 'john@example', 'given_name' => 'john']
});
```

If your file already contains a header row, it will be ignored and replaced with your custom headers.

If your file does not contain a header row, you should also use `noHeaderRow()`, and your headers will be used instead of numeric keys, as above.

#### Working with multiple sheet documents

[](#working-with-multiple-sheet-documents)

Excel files can include multiple spreadsheets. You can select the sheet you want to use with the `fromSheet()` method to select by index.

```
$rows = SimpleExcelReader::create($pathToXlsx)
    ->fromSheet(3)
    ->getRows();
```

You can also retrieve all sheet names in a document using the `getSheetNames()` method.

```
$sheets = SimpleExcelReader::create($pathToXlsx)
    ->getSheetNames();
```

With multiple spreadsheets, you can too select the sheet you want to use with the `fromSheetName()` method to select by name.

```
$rows = SimpleExcelReader::create($pathToXlsx)
    ->fromSheetName("sheet1")
    ->getRows();
```

If you want to check if a sheet exists, use the `hasSheet()` method.

```
$hasSheet = SimpleExcelReader::create($pathToXlsx)
    ->hasSheet("sheet1");
```

#### Retrieving header row values

[](#retrieving-header-row-values)

If you would like to retrieve the header row as an array, you can use the `getHeaders()` method.

If you have used `useHeaders()` to set custom headers, these will be returned instead of the actual headers in the file. To get the original headers from the file, use `getOriginalHeaders()`.

```
$headers = SimpleExcelReader::create($pathToCsv)->getHeaders();

// $headers will contain
// [ 'email', 'first_name' ]
```

#### Dealing with headers that are not on the first line

[](#dealing-with-headers-that-are-not-on-the-first-line)

If your file has headers that are not on the first line, you can use the `headerOnRow()` method to indicate the line at which the headers are present. Any data above this line will be discarded from the result.

`headerOnRow` accepts the line number as an argument, starting at 0. Blank lines are not counted.

Since blank lines will not be counted, this method is mostly useful for files that include formatting above the actual dataset, which can be the case with Excel files.

```
This is my data sheet
See worksheet 1 for the data, worksheet 2 for the graphs.

email , firstname
john@example.com,john
jane@example.com,jane
```

```
// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)
    ->trimHeaderRow()
    ->headerOnRow(3)
    ->getRows()
    ->each(function(array $rowProperties) {
       // in the first pass $rowProperties will contain
       // ['email' => 'john@example', 'first_name' => 'john']
});
```

#### Trimming headers

[](#trimming-headers)

If the file you are reading contains a title row, but you need to trim additional characters on the title values, then you should use the `trimHeaderRow()` method. This functionality mimics the `trim` method, and the default characters it trims, matches that function.

Imagine you have a csv file with this content.

```
email , first_name
john@example.com,john
jane@example.com,jane
```

```
// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)
    ->trimHeaderRow()
    ->getRows()
    ->each(function(array $rowProperties) {
       // in the first pass $rowProperties will contain
       // ['email' => 'john@example', 'first_name' => 'john']
});
```

`trimHeaderRow()` additionally accepts a param to specify what characters to trim. This param can utilize the same functionality allowed by the trim function's `$characters` definition including a range of characters.

#### Convert headers to snake\_case

[](#convert-headers-to-snake_case)

If you would like all the headers to be converted to snake\_case, use the the `headersToSnakeCase()` method.

```
Email,First Name,Last Name
john@example.com,john,doe
mary-jane@example.com,mary jane,doe
```

```
$rows = SimpleExcelReader::create($pathToCsv)
    ->headersToSnakeCase()
    ->getRows()
    ->each(function(array $rowProperties) {
        // rowProperties converted to snake_case
        // ['email' => 'john@example', 'first_name' => 'John', 'last_name' => 'doe']
    });
```

#### Manually formatting headers

[](#manually-formatting-headers)

You can use a custom formatter to change the headers using the `formatHeadersUsing` method and passing a closure.

```
email,first_name,last_name
john@example.com,john,doe
mary-jane@example.com,mary jane,doe
```

```
$rows = SimpleExcelReader::create($pathToCsv)
    ->formatHeadersUsing(fn($header) => "{$header}_simple_excel")
    ->getRows()
    ->each(function(array $rowProperties) {
        // ['email_simple_excel' => 'john@example', 'first_name_simple_excel' => 'John', 'last_name_simple_excel' => 'doe']
    });
```

#### Manually working with the reader object

[](#manually-working-with-the-reader-object)

Under the hood this package uses the [openspout/spout](https://github.com/openspout/openspout) package. You can get to the underlying reader that implements `\OpenSpout\Reader\ReaderInterface` by calling the `getReader` method.

```
$reader = SimpleExcelReader::create($pathToCsv)->getReader();
```

#### Limiting the result set

[](#limiting-the-result-set)

The `take` method allows you to specify a limit on how many rows should be returned.

```
// $rows is an instance of Illuminate\Support\LazyCollection
$rows = SimpleExcelReader::create($pathToCsv)
    ->take(5)
    ->getRows();
```

The `skip` method allows you to define which row to start reading data from. In this example we get rows 11 to 16.

```
$rows = SimpleExcelReader::create($pathToCsv)
    ->skip(10)
    ->take(5)
    ->getRows();
```

#### Reading cells that contain formulas

[](#reading-cells-that-contain-formulas)

Normally, cells containing formulas are parsed and their computed value will be returned. If you want to keep the actual formula as a string, you can use the `keepFormulas` method.

```
$rows = SimpleExcelReader::create($pathToXlsx)
    ->keepFormulas()
    ->getRows();
```

#### Preserve date formatting

[](#preserve-date-formatting)

By default, when reading a spreadsheet with dates or times, the values are returned as `DateTimeImmutable` objects. To return a formatted date (e.g., “9/20/2024”) instead, use the `preserveDateTimeFormatting` method. The date format will match what’s specified in the spreadsheet.

```
$rows = SimpleExcelReader::create($pathToXlsx)
    ->preserveDateTimeFormatting()
    ->getRows();
```

#### Preserve empty rows

[](#preserve-empty-rows)

You can preserve empty rows by using the `preserveEmptyRows` method.

```
$rows = SimpleExcelReader::create($pathToXlsx)
    ->preserveEmptyRows()
    ->getRows();
```

### Writing files

[](#writing-files)

Here's how you can write a CSV file:

```
use Spatie\SimpleExcel\SimpleExcelWriter;

$writer = SimpleExcelWriter::create($pathToCsv)
     ->addRow([
        'first_name' => 'John',
        'last_name' => 'Doe',
    ])
    ->addRow([
        'first_name' => 'Jane',
        'last_name' => 'Doe',
    ]);
```

The file at `pathToCsv` will contain:

```
first_name,last_name
John,Doe
Jane,Doe
```

#### Manually set the header from array

[](#manually-set-the-header-from-array)

Instead of letting the package automatically detect a header row, you can set it manually.

```
use Spatie\SimpleExcel\SimpleExcelWriter;

$writer = SimpleExcelWriter::create($pathToCsv)
    ->addHeader(['first_name', 'last_name'])
    ->addRow(['John', 'Doe'])
    ->addRow(['Jane', 'Doe'])
```

#### Writing an Excel file

[](#writing-an-excel-file)

Writing an Excel file is identical to writing a csv. Just make sure that the path given to the `create` method of `SimpleExcelWriter` ends with `xlsx`. One other thing to be aware of when writing an Excel file is that the file doesn't get written until the instance of `SimpleExcelWriter` is garbage collected. That's when the `close` method is called. The `close` method is what finalizes writing the file to disk. If you need to access the file before the instance is garbage collected you will need to call the `close` method first.

```
$writer->close();
```

#### Streaming an Excel file to the browser

[](#streaming-an-excel-file-to-the-browser)

Instead of writing a file to disk, you can stream it directly to the browser.

```
$writer = SimpleExcelWriter::streamDownload('your-export.xlsx')
     ->addRow([
        'first_name' => 'John',
        'last_name' => 'Doe',
    ])
    ->addRow([
        'first_name' => 'Jane',
        'last_name' => 'Doe',
    ])
    ->toBrowser();
```

Make sure to call `flush()` if you're sending large streams to the browser

```
$writer = SimpleExcelWriter::streamDownload('your-export.xlsx');

foreach (range(1, 10_000) as $i) {
    $writer->addRow([
        'first_name' => 'John',
        'last_name' => 'Doe',
    ]);

    if ($i % 1000 === 0) {
        flush(); // Flush the buffer every 1000 rows
    }
}

$writer->toBrowser();
```

You could also use a callback.

```
use Spatie\SimpleExcel\SimpleExcelWriter;
use OpenSpout\Common\Entity\Row;

$writer = SimpleExcelWriter::streamDownload('user-list.xlsx', function ($writerCallback, $downloadName) {

    $writerCallback->openToBrowser($downloadName);

    $writerCallback->addRow(Row::fromValues([
        'first_name' => 'First Name',
        'last_name' => 'Last Name',
    ]));

    $writerCallback->addRow(Row::fromValues([
        'first_name' => 'Rakib',
        'last_name' => 'Hossain',
    ]));

    foreach (range(1, 10_000) as $i) {
        $writerCallback->addRow(Row::fromValues([
            'first_name' => 'Rakib',
            'last_name' => 'Hossain',
        ]));

        if ($i % 1000 === 0) {
            flush();
        }
    }
});

$writer->toBrowser();
```

### Writing multiple rows at once

[](#writing-multiple-rows-at-once)

You can use `addRows` instead of `addRow` to add multiple rows at once.

```
$writer = SimpleExcelWriter::streamDownload('your-export.xlsx')
     ->addRows([
        [
            'first_name' => 'John',
            'last_name' => 'Doe',
        ],
        [
            'first_name' => 'Jane',
            'last_name' => 'Doe',
        ],
    ]);
```

#### Writing a file without titles

[](#writing-a-file-without-titles)

If the file you are writing should not have a title row added automatically, then you should use the `noHeaderRow()` method.

```
$writer = SimpleExcelWriter::create($pathToCsv)
    ->noHeaderRow()
    ->addRow([
        'first_name' => 'Jane',
        'last_name' => 'Doe',
    ]);
```

This will output:

```
Jane,Doe
```

#### Adding layout

[](#adding-layout)

Under the hood this package uses the [openspout/openspout](https://github.com/openspout/openspout) package. That package contains a `Style` builder that you can use to format rows. Styles can only be used on excel documents.

```
use OpenSpout\Common\Entity\Style\Color;
use OpenSpout\Common\Entity\Style\CellAlignment;
use OpenSpout\Common\Entity\Style\Style;
use OpenSpout\Common\Entity\Style\Border;
use OpenSpout\Common\Entity\Style\BorderPart;

/* Create a border around a cell */
$border = new Border(
        new BorderPart(Border::BOTTOM, Color::LIGHT_BLUE, Border::WIDTH_THIN, Border::STYLE_SOLID),
        new BorderPart(Border::LEFT, Color::LIGHT_BLUE, Border::WIDTH_THIN, Border::STYLE_SOLID),
        new BorderPart(Border::RIGHT, Color::LIGHT_BLUE, Border::WIDTH_THIN, Border::STYLE_SOLID),
        new BorderPart(Border::TOP, Color::LIGHT_BLUE, Border::WIDTH_THIN, Border::STYLE_SOLID)
    );

$style = (new Style())
   ->setFontBold()
   ->setFontSize(15)
   ->setFontColor(Color::BLUE)
   ->setShouldWrapText()
   ->setBackgroundColor(Color::YELLOW)
   ->setBorder($border);

$writer->addRow(['values', 'of', 'the', 'row'], $style);
```

To style your HeaderRow simply call the `setHeaderStyle($style)` Method.

```
$writer->setHeaderStyle($style);
```

For more information on styles head over to [the Spout docs](https://github.com/openspout/openspout/tree/4.x/docs).

#### Setting column widths and row heights

[](#setting-column-widths-and-row-heights)

By accessing the underlying OpenSpout Writer you can set default column widths and row heights and change the width of specific columns.

```
SimpleExcelWriter::create(
    file: 'document.xlsx',
    configureWriter: function ($writer) {
        $options = $writer->getOptions();
        $options->DEFAULT_COLUMN_WIDTH=25; // set default width
        $options->DEFAULT_ROW_HEIGHT=15; // set default height
        // set columns 1, 3 and 8 to width 40
        $options->setColumnWidth(40, 1, 3, 8);
        // set columns 9 through 12 to width 10
        $options->setColumnWidthForRange(10, 9, 12);
    }
)
```

#### Creating an additional sheets

[](#creating-an-additional-sheets)

By default, the writer will write to the first sheet. If you want to write to an additional sheet, you can use the `addNewSheetAndMakeItCurrent` method.

```
$writer = SimpleExcelWriter::create($pathToXlsx);

Posts::all()->each(function (Post $post) use ($writer) {
    $writer->nameCurrentSheet($post->title);

    $post->comments->each(function (Comment $comment) use ($writer) {
        $writer->addRow([
            'comment' => $comment->comment,
            'author' => $comment->author,
        ]);
    });

    if(!$post->is($posts->last())) {
        $writer->addNewSheetAndMakeItCurrent();
    }
});
```

#### Using an alternative delimiter

[](#using-an-alternative-delimiter)

By default the `SimpleExcelReader` will assume that the delimiter is a `,`.

This is how you can use an alternative delimiter:

```
SimpleExcelWriter::create($pathToCsv)->useDelimiter(';');
```

#### Getting the number of rows written

[](#getting-the-number-of-rows-written)

You can get the number of rows that are written. This number includes the automatically added header row.

```
$writerWithAutomaticHeader = SimpleExcelWriter::create($this->pathToCsv)
    ->addRow([
        'first_name' => 'John',
        'last_name' => 'Doe',
    ]);

$writerWithAutomaticHeader->getNumberOfRows(); // returns 2
```

#### Disable BOM

[](#disable-bom)

You can also disable adding a BOM to the start of the file. BOM must be disabled on create and cannot be disabled after creation of the writer.

A BOM, or byte order mark, indicates a number of things for the file being written including the file being unicode as well as it's UTF encoding type.

```
SimpleExcelWriter::createWithoutBom($this->pathToCsv, $type);
```

Additional information about BOM can be found [here](https://en.wikipedia.org/wiki/Byte_order_mark).

#### Manually working with the writer object

[](#manually-working-with-the-writer-object)

Under the hood this package uses the [openspout/openspout](https://github.com/openspout/openspout) package. You can get to the underlying writer that implements `\OpenSpout\Reader\WriterInterface` by calling the `getWriter` method.

```
$writer = SimpleExcelWriter::create($pathToCsv)->getWriter();
```

### Testing

[](#testing)

```
composer test
```

### Changelog

[](#changelog)

Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently.

Contributing
------------

[](#contributing)

Please see [CONTRIBUTING](https://github.com/spatie/.github/blob/main/CONTRIBUTING.md) for details.

### Security

[](#security)

If you've found a bug regarding security please mail  instead of using the issue tracker.

Postcardware
------------

[](#postcardware)

You're free to use this package, but if it makes it to your production environment we highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using.

Our address is: Spatie, Kruikstraat 22, 2018 Antwerp, Belgium.

We publish all received postcards [on our company website](https://spatie.be/en/opensource/postcards).

Credits
-------

[](#credits)

- [Freek Van der Herten](https://github.com/freekmurze)
- [All Contributors](../../contributors)

Alternatives
------------

[](#alternatives)

- [PhpSpreadsheet](https://phpspreadsheet.readthedocs.io/en/latest/)
- [laravel-excel](https://laravel-excel.com)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

###  Health Score

77

—

ExcellentBetter than 100% of packages

Maintenance90

Actively maintained with recent releases

Popularity72

Solid adoption and visibility

Community47

Growing community involvement

Maturity86

Battle-tested with a long release history

 Bus Factor1

Top contributor holds 60.5% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~43 days

Recently: every ~93 days

Total

54

Last Release

107d ago

Major Versions

0.0.3 → 1.0.02019-10-26

1.15.1 → 2.0.02022-06-06

2.1.0 → v3.x-dev2022-08-04

2.5.0 → 3.0.02022-12-09

PHP version history (7 changes)0.0.1PHP ^7.3

0.0.2PHP ^7.2

1.3.0PHP ^7.4

1.9.1PHP ^7.4|^8.0

1.14.0PHP ^8.0

3.2.1PHP ^8.1

3.8.0PHP ^8.3

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/7535935?v=4)[Spatie](/maintainers/spatie)[@spatie](https://github.com/spatie)

---

Top Contributors

[![freekmurze](https://avatars.githubusercontent.com/u/483853?v=4)](https://github.com/freekmurze "freekmurze (210 commits)")[![Nielsvanpach](https://avatars.githubusercontent.com/u/10651054?v=4)](https://github.com/Nielsvanpach "Nielsvanpach (35 commits)")[![AdrianMrn](https://avatars.githubusercontent.com/u/12762044?v=4)](https://github.com/AdrianMrn "AdrianMrn (8 commits)")[![AdamGaskins](https://avatars.githubusercontent.com/u/1180782?v=4)](https://github.com/AdamGaskins "AdamGaskins (7 commits)")[![alexmanase](https://avatars.githubusercontent.com/u/10696975?v=4)](https://github.com/alexmanase "alexmanase (7 commits)")[![red-freak](https://avatars.githubusercontent.com/u/66564761?v=4)](https://github.com/red-freak "red-freak (7 commits)")[![dakira](https://avatars.githubusercontent.com/u/576555?v=4)](https://github.com/dakira "dakira (6 commits)")[![jobins-bedram](https://avatars.githubusercontent.com/u/221937772?v=4)](https://github.com/jobins-bedram "jobins-bedram (5 commits)")[![paulandroshchuk](https://avatars.githubusercontent.com/u/13240539?v=4)](https://github.com/paulandroshchuk "paulandroshchuk (5 commits)")[![brodos](https://avatars.githubusercontent.com/u/1268322?v=4)](https://github.com/brodos "brodos (5 commits)")[![ahallhognason](https://avatars.githubusercontent.com/u/56840000?v=4)](https://github.com/ahallhognason "ahallhognason (4 commits)")[![laravel-shift](https://avatars.githubusercontent.com/u/15991828?v=4)](https://github.com/laravel-shift "laravel-shift (4 commits)")[![bruno-fernandes](https://avatars.githubusercontent.com/u/1558329?v=4)](https://github.com/bruno-fernandes "bruno-fernandes (4 commits)")[![buismaarten](https://avatars.githubusercontent.com/u/16333228?v=4)](https://github.com/buismaarten "buismaarten (4 commits)")[![arondeparon](https://avatars.githubusercontent.com/u/7697?v=4)](https://github.com/arondeparon "arondeparon (4 commits)")[![riasvdv](https://avatars.githubusercontent.com/u/3626559?v=4)](https://github.com/riasvdv "riasvdv (3 commits)")[![amit-roy1999](https://avatars.githubusercontent.com/u/54204674?v=4)](https://github.com/amit-roy1999 "amit-roy1999 (3 commits)")[![brendt](https://avatars.githubusercontent.com/u/6905297?v=4)](https://github.com/brendt "brendt (3 commits)")[![jeremysalmon](https://avatars.githubusercontent.com/u/2249236?v=4)](https://github.com/jeremysalmon "jeremysalmon (3 commits)")[![ragingdave](https://avatars.githubusercontent.com/u/1168344?v=4)](https://github.com/ragingdave "ragingdave (3 commits)")

---

Tags

csvexcelexportgeneratorimportlazycollectionreadwritespatiesimple-excel

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/spatie-simple-excel/health.svg)

```
[![Health](https://phpackages.com/badges/spatie-simple-excel/health.svg)](https://phpackages.com/packages/spatie-simple-excel)
```

###  Alternatives

[maatwebsite/excel

Supercharged Excel exports and imports in Laravel

12.7k152.8M844](/packages/maatwebsite-excel)[rap2hpoutre/fast-excel

Fast Excel import/export for Laravel

2.3k26.3M50](/packages/rap2hpoutre-fast-excel)[spatie/laravel-responsecache

Speed up a Laravel application by caching the entire response

2.8k8.7M64](/packages/spatie-laravel-responsecache)[spatie/laravel-health

Monitor the health of a Laravel application

88011.3M149](/packages/spatie-laravel-health)[spatie/laravel-export

Create a static site bundle from a Laravel app

670139.5k6](/packages/spatie-laravel-export)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)