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 3w 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 87% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity40

Moderate usage in the ecosystem

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

2762d 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

14.3k318.2M1.5k](/packages/phpoffice-phpspreadsheet)[akeneo-labs/spreadsheet-parser

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

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

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

1.8k4.2M30](/packages/shuchkin-simplexlsx)[openspout/openspout

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

1.2k70.2M237](/packages/openspout-openspout)[avadim/fast-excel-reader

Lightweight and very fast XLSX Excel Spreadsheet and CSV Reader in PHP

107737.8k11](/packages/avadim-fast-excel-reader)[nuovo/spreadsheet-reader

Spreadsheet reader library for Excel, OpenOffice and structured text files

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

PHPackages © 2026

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