PHPackages                             akeneo/spreadsheet-parser - 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. akeneo/spreadsheet-parser

Abandoned → [akeneo-labs/spreadsheet-parser](/?search=akeneo-labs%2Fspreadsheet-parser)Library[PDF & Document Generation](/categories/documents)

akeneo/spreadsheet-parser
=========================

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

v1.3.0(7y ago)14521.1k49[13 issues](https://github.com/akeneo/spreadsheet-parser/issues)[5 PRs](https://github.com/akeneo/spreadsheet-parser/pulls)2OSL-3.0PHPPHP >=5.4.0

Since May 24Pushed 4y ago22 watchersCompare

[ Source](https://github.com/akeneo/spreadsheet-parser)[ Packagist](https://packagist.org/packages/akeneo/spreadsheet-parser)[ Docs](http://akeneo.com)[ RSS](/packages/akeneo-spreadsheet-parser/feed)WikiDiscussions master Synced 5d ago

READMEChangelog (4)Dependencies (3)Versions (15)Used By (2)

Akeneo Spreadsheet Parser
=========================

[](#akeneo-spreadsheet-parser)

This component is designed to extract data from spreadsheets, while being easy on resources, even for large files.

The current version of the spreadsheet parser works with csv and xlsx files.

[![Travis Build Status](https://camo.githubusercontent.com/8c8edbccd5122ab68d5282685bc170c21ec15a04fb710383518f44aa894d9c52/68747470733a2f2f7472617669732d63692e6f72672f616b656e656f2d6c6162732f73707265616473686565742d7061727365722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/akeneo-labs/spreadsheet-parser)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/3ab32db6b8725e69c41c493a5f736e1d0cebdcbd2127db10edca228a03555226/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f616b656e656f2d6c6162732f73707265616473686565742d7061727365722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/akeneo-labs/spreadsheet-parser/?branch=master)

Installing the package
----------------------

[](#installing-the-package)

From your application root:

```
    $ php composer.phar require --prefer-dist "akeneo-labs/spreadsheet-parser"
```

Usage
-----

[](#usage)

To extract data from an XLSX spreadsheet, use the following code:

```
    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.xlsx');

    $myWorksheetIndex = $workbook->getWorksheetIndex('myworksheet');

    foreach ($workbook->createRowIterator($myWorksheetIndex) as $rowIndex => $values) {
        var_dump($rowIndex, $values);
    }
```

By using the CSV parser options, you can specify the format of your CSV file :

```
    use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

    $workbook = SpreadsheetParser::open('myfile.csv');

    $iterator = $workbook->createRowIterator(
        0,
        [
            'encoding'  => 'UTF-8',
            'length'    => null,
            'delimiter' => ',',
            'enclosure' => '"',
            'escape'    => '\\'
        ]
    );

    foreach ($workbook->createRowIterator(0) as $rowIndex => $values) {
        var_dump($rowIndex, $values);
    }
```

Running the tests
-----------------

[](#running-the-tests)

To run unit tests, use phpspec:

```
    $ php bin/phpspec run
```

To run integration tests, use phpunit:

```
    $ phpunit
```

###  Health Score

41

—

FairBetter than 89% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity39

Limited adoption so far

Community30

Small or concentrated contributor base

Maturity66

Established project with proven stability

 Bus Factor2

2 contributors hold 50%+ of commits

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 ~127 days

Recently: every ~247 days

Total

14

Last Release

2716d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/307250bdb6545909b128061d967bd724d7174c4ad775390585ac1927c6110747?d=identicon)[akeneo](/maintainers/akeneo)

![](https://www.gravatar.com/avatar/8a3c6d99b1f8e8e14bc08d2fc5c798bc841ade1c4ae443a745b660067a56180f?d=identicon)[Fitn](/maintainers/Fitn)

---

Top Contributors

[![jmleroux](https://avatars.githubusercontent.com/u/1516770?v=4)](https://github.com/jmleroux "jmleroux (16 commits)")[![stof](https://avatars.githubusercontent.com/u/439401?v=4)](https://github.com/stof "stof (15 commits)")[![fitn](https://avatars.githubusercontent.com/u/2131005?v=4)](https://github.com/fitn "fitn (10 commits)")[![damien-carcel](https://avatars.githubusercontent.com/u/5039018?v=4)](https://github.com/damien-carcel "damien-carcel (3 commits)")[![MarieMinasyan](https://avatars.githubusercontent.com/u/1398717?v=4)](https://github.com/MarieMinasyan "MarieMinasyan (2 commits)")[![xakepsoft](https://avatars.githubusercontent.com/u/14543154?v=4)](https://github.com/xakepsoft "xakepsoft (1 commits)")[![harikt](https://avatars.githubusercontent.com/u/120454?v=4)](https://github.com/harikt "harikt (1 commits)")[![bocharsky-bw](https://avatars.githubusercontent.com/u/3317635?v=4)](https://github.com/bocharsky-bw "bocharsky-bw (1 commits)")

---

Tags

parserexcelxlsxreaderspreadsheetakeneo

### Embed Badge

![Health badge](/badges/akeneo-spreadsheet-parser/health.svg)

```
[![Health](https://phpackages.com/badges/akeneo-spreadsheet-parser/health.svg)](https://phpackages.com/packages/akeneo-spreadsheet-parser)
```

###  Alternatives

[phpoffice/phpspreadsheet

PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine

13.9k293.5M1.3k](/packages/phpoffice-phpspreadsheet)[akeneo-labs/spreadsheet-parser

Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office

147598.3k6](/packages/akeneo-labs-spreadsheet-parser)[shuchkin/simplexlsx

Parse and retrieve data from Excel XLSx files. MS Excel 2007 workbooks PHP reader.

1.8k3.8M21](/packages/shuchkin-simplexlsx)[openspout/openspout

PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

1.1k57.6M131](/packages/openspout-openspout)[avadim/fast-excel-reader

Lightweight and very fast XLSX Excel Spreadsheet Reader in PHP

104608.4k6](/packages/avadim-fast-excel-reader)[nuovo/spreadsheet-reader

Spreadsheet reader library for Excel, OpenOffice and structured text files

669863.2k8](/packages/nuovo-spreadsheet-reader)

PHPackages © 2026

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