Laravel CSV Import

A Laravel package to import large CSV files efficiently using chunked memory processing, on-the-fly UTF-8 conversion, and no temporary storage overhead.

📦 Installation

Install via Composer:

composer require rashiqulrony/laravel-csv-import

If you're using Laravel <5.5 or your Laravel version doesn't support package auto-discovery, add the service provider manually:

// config/app.php
'providers' => [
    Rashiqulrony\CSVImport\Providers\AppServiceProvider::class,
];

⚙️ Configuration

Publish the config file (optional):

php artisan vendor:publish --provider="Rashiqulrony\CSVImport\Providers\AppServiceProvider" --tag=config

This creates a file: config/csvimport.php

return [
    'chunk_size' => 200, // Number of rows to return per batch
];

🚀 Usage

✅ Basic Example

use Rashiqulrony\CSVImport;

public function upload(Request $request)
{
    $request->validate([
        'file' => 'required|file|mimes:csv',
    ]);

    $result = CSVImport::upload($request->file('file'));
    
    if (!empty($result) && is_array($result)) {
         foreach ($result as $key => $value) {
              foreach ($result[$key] as $data) {
                 // Process or save the row (e.g. DB::table(...)->insert($row))
              }
         }
    } else {
         return back()->with('error', 'Data not found or invalid file.');
    }
        
    return back()->with('success', 'CSV imported successfully!');
}

📥 Method: CSVImport::upload($file)

✅ Features

• Detects and converts multiple encodings to UTF-8
• Skips invalid rows (missing fields, malformed headers)
• Efficient memory usage with chunking
• No need to manually store or manage temp files

🧪 Supported Encodings

• UTF-8
• UTF-16LE / UTF-16BE
• Windows-1252
• ISO-8859-1

📂 Directory Structure

laravel-csv-import/
├── src/
│   ├── CSVImport.php
│   └── Providers/
│       └── AppServiceProvider.php
├── config/
│   └── csvimport.php
├── composer.json
└── README.md

📝 License

This package is open-sourced software licensed under the MIT license.

👤 Author

Rashiqul Rony
📧 rashiqulrony@gmail.com
🔗 github.com/rashiqulrony