> For the complete documentation index, see [llms.txt](https://php-etl.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://php-etl.gitbook.io/docs/master.md).

# Introduction

PHP ETL provides the Extract, Transform and Load capabilities that streamline the process of data manipulation.

You can, for example, extract data from a csv file, trim white spaces from specific columns and then load the values into a database table:

```php
use Marquine\Etl\Etl;

$etl = new Etl;

$etl->extract('csv', '/path/to/users.csv')
    ->transform('trim', ['columns' => ['name', 'email']])
    ->load('insert', 'users')
    ->run();
```