---
url: https://docs.laravel-excel.com/4.x/imports/mapped-cells.md
---

# Mapped Cells

In case you have a more custom spreadsheet and only want to access specific **cells**, you can implement the `WithMappedCells` concern.

You might have a speadsheet looking like this:

|name | Patrick Brouwers|
|---- |----|
| email | patrick@spartner.nl |

We can now map `name` to `B1` and `email` to `B2`. The value of those coordinates will then be available under the given array key.

```php
namespace App\Imports;

use App\User;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithMappedCells;

class UsersImport implements WithMappedCells, ToModel
{
    public function mapping(): array
    {
        return [
            'name'  => 'B1',
            'email' => 'B2',
        ];
    }

    public function model(array $row): User|null
    {
        return new User([
            'name' => $row['name'],
            'email' => $row['email'],
        ]);
    }
}
```

::: warning
This concern is not meant to map **columns**, only specific **cell** reference are allowed.
:::

## Multi-demensional Mapping

In case you have repeating data in your table, e. g. a spreadsheet looking like this:

| Team 1 | | Team 2| |
|-|-|-|-|
| Max | 2 | Peter | 3 |
| Annie | 0 | Alex | 1 |

you are also able to define cell coordinates in a nested array:

````php
public function mapping(): array
{
    return [
        'team1' => [
            [
                'name' => 'A2',
                'score' => 'B2',
            ],
            [
                'name' => 'A3',
                'score' => 'B3',
            ],
        ],
        'team2' => [
            [
                'name' => 'C2',
                'score' => 'D2',
            ],
            [
                'name' => 'C3',
                'score' => 'D3',
            ],
        ],
    ];
}```

Note that an array of the same form will be returned.
````