PHPackages                             justiversen/sheetmapper - 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. justiversen/sheetmapper

AbandonedArchivedLibrary

justiversen/sheetmapper
=======================

Excel sheetmapper

0.1(6y ago)23MITPHPPHP ^7.2CI failing

Since Apr 15Pushed 6y ago2 watchersCompare

[ Source](https://github.com/JustIversen/sheetmapper)[ Packagist](https://packagist.org/packages/justiversen/sheetmapper)[ RSS](/packages/justiversen-sheetmapper/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (1)Dependencies (1)Versions (2)Used By (0)

[![Packagist Downloads](https://camo.githubusercontent.com/53524a9dbac1cb38a190364c9047e6f2a5b58d562c414f0f03ae3e6c9a64d376/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f4a7573744976657273656e2f73686565746d6170706572)](https://camo.githubusercontent.com/53524a9dbac1cb38a190364c9047e6f2a5b58d562c414f0f03ae3e6c9a64d376/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f4a7573744976657273656e2f73686565746d6170706572)[![Code size](https://camo.githubusercontent.com/e20b1774d236f94648723bc97960d132e6d124ed2228c368dfbbb4b48322f351/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c616e6775616765732f636f64652d73697a652f4a7573744976657273656e2f73686565746d6170706572)](https://camo.githubusercontent.com/e20b1774d236f94648723bc97960d132e6d124ed2228c368dfbbb4b48322f351/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c616e6775616765732f636f64652d73697a652f4a7573744976657273656e2f73686565746d6170706572)

SheetMapper
===========

[](#sheetmapper)

SheetMapper provides functionality to load data from Excel sheet or plain array and apply a number of different mapper functions to selected columns.

You only need to provide a `SplFileInfo` object as source.

Both `Illuminate\Http\File` and `Symfony\Component\HttpFoundation\File\File` extends this native PHP class.

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

[](#installation)

`composer require justiversen/sheetmapper`

Usage examples
--------------

[](#usage-examples)

Provide a plain PHP array of items to map.

```
    $data = (new \JustIversen\SheetMapper\SheetMapper)
        ->source($inputArray)
        ->modifyHeaders([
            'name in file' => 'component_name',
            'stkpris' => 'component_price',
            'beskrivelse' => 'component_description',
        ])
        ->toLower()
        ->numberToFloat(['measurement_amount'])
        ->get();
```

Or provide a SplFileInfo Excel file to map. Here we use Laravel's default request()->file

```
    $data = (new \JustIversen\SheetMapper\SheetMapper)
        ->source(request()->file)
        ->modifyHeaders([
            'name in file' => 'component_name',
            'stkpris' => 'component_price',
            'beskrivelse' => 'component_description',
        ])
        ->concat(['component_name', 'component_price'], '-', 'concatted_column')
        ->checkForNull()
        ->trim()
        ->get();
```

Contributers
------------

[](#contributers)

- [Kim André Langholz](https://github.com/KimLangholz)
- [Jens Just Iversen](https://github.com/JensJI)

License
-------

[](#license)

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

###  Health Score

21

—

LowBetter than 18% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 88.9% 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

Unknown

Total

1

Last Release

2223d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/42467227?v=4)[Just Iversen](/maintainers/justiversen)[@JustIversen](https://github.com/JustIversen)

---

Top Contributors

[![KristianI](https://avatars.githubusercontent.com/u/1626966?v=4)](https://github.com/KristianI "KristianI (8 commits)")[![JensJI](https://avatars.githubusercontent.com/u/10193394?v=4)](https://github.com/JensJI "JensJI (1 commits)")

### Embed Badge

![Health badge](/badges/justiversen-sheetmapper/health.svg)

```
[![Health](https://phpackages.com/badges/justiversen-sheetmapper/health.svg)](https://phpackages.com/packages/justiversen-sheetmapper)
```

###  Alternatives

[maatwebsite/excel

Supercharged Excel exports and imports in Laravel

12.7k144.3M712](/packages/maatwebsite-excel)[craftcms/cms

Craft CMS

3.6k3.6M2.6k](/packages/craftcms-cms)[prestashop/prestashop

PrestaShop is an Open Source e-commerce platform, committed to providing the best shopping cart experience for both merchants and customers.

9.0k15.4k](/packages/prestashop-prestashop)[kimai/kimai

Kimai - Time Tracking

4.6k7.4k1](/packages/kimai-kimai)[civicrm/civicrm-core

Open source constituent relationship management for non-profits, NGOs and advocacy organizations.

728272.9k20](/packages/civicrm-civicrm-core)[in2code/powermail

Powermail is a well-known, editor-friendly, powerful and easy to use mailform extension for TYPO3 with a lots of features

982.5M38](/packages/in2code-powermail)

PHPackages © 2026

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