PHPackages rupeshgondaliya/laravel-csv-studio - 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. [File & Storage](/categories/file-storage) 4. / 5. rupeshgondaliya/laravel-csv-studio ActiveLibrary[File & Storage](/categories/file-storage) rupeshgondaliya/laravel-csv-studio ================================== A beautiful, premium Laravel package for interactive multi-step CSV importing and exporting with live preview and inline editing. 1.0.0(2mo ago)01MITBladePHP ^8.0 Since May 23Pushed 2mo agoCompare [ Source](https://github.com/gondaliyarupesh/laravel-csv-studio)[ Packagist](https://packagist.org/packages/rupeshgondaliya/laravel-csv-studio)[ RSS](/packages/rupeshgondaliya-laravel-csv-studio/feed)WikiDiscussions main Synced 3w ago READMEChangelog (2)Dependencies (3)Versions (4)Used By (0) Laravel CSV Studio ๐ŸŽฌ ==================== [](#laravel-csv-studio-) [![Latest Version on Packagist](https://camo.githubusercontent.com/e2bb191ce3c8c41bba60acc59c73e8c63beff7a3878b2d1ac034f909494b6ff5/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f727570657368676f6e64616c6979612f6c61726176656c2d6373762d73747564696f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/rupeshgondaliya/laravel-csv-studio)[![Total Downloads](https://camo.githubusercontent.com/7cb633d2037a6be304d491b688ce780e98b1205ae12cb953bdae97fd94f211e7/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f727570657368676f6e64616c6979612f6c61726176656c2d6373762d73747564696f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/rupeshgondaliya/laravel-csv-studio)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![PHP Version](https://camo.githubusercontent.com/23d185d525f163fc848f019029815f96e8ef3ff225f3db81b14a9ed18339e74d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253545382e302d626c75652e7376673f7374796c653d666c61742d737175617265)](https://php.net)[![Laravel Version](https://camo.githubusercontent.com/42359fc7aff2f71e8ca5b0a9e0c8ab40a8cc272030f23e7043713cd78989029e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c61726176656c2d253545392e3025323025374325323025354531302e3025323025374325323025354531312e3025323025374325323025354531322e302d7265642e7376673f7374796c653d666c61742d737175617265)](https://laravel.com) **Laravel CSV Studio** is a beautiful, premium, and feature-rich Laravel package that converts a basic CSV importer/exporter into a high-fidelity visual workspace. Built with modern glassmorphic designs, micro-animations, and Excel-like editing, it provides an immersive, single-page application (SPA) style dashboard for developers and end-users to import and export database records interactively. --- ๐ŸŒŸ Key Features -------------- [](#-key-features) ### 1. Dual-Workflow Welcome Dashboard [](#1-dual-workflow-welcome-dashboard) - Seamlessly select between **Importing CSV Data** or **Exporting Database Tables** via modern interactive glassmorphic cards with responsive hover transitions. ### 2. Interactive Import Workspace (CSV $\\rightarrow$ DB) [](#2-interactive-import-workspace-csv-rightarrow-db) - **Smart Auto-Mapping**: Automatically pairs CSV headers with database columns using smart synonym matching (e.g. `Full Name` $\\rightarrow$ `name`, `E-mail Address` $\\rightarrow$ `email`). - **Excel-Like Grid**: Double-click any cell in the table grid to edit content inline before importing. - **Flexible Validation**: Real-time format checks (emails, phone numbers, numeric prices, required columns) with distinct visual warnings and interactive CSS hover tooltips. - **Dynamic Grid Controls**: Add or delete records on the fly instantly from the visual grid interface. - **Insert vs Update Modes**: - **Insert Mode**: Generates new records and hides database auto-incrementing ID fields to prevent collisions. - **Update Mode**: Requires mapping a unique ID column, validates that every row has an ID, checks database existence, and performs transactional in-place updates. - **Safe Transactions**: Executes import operations within database transactions, performing clean rollbacks if any row fails database-level insertion constraints. ### 3. Live Preview Exporter Workspace (DB $\\rightarrow$ CSV) [](#3-live-preview-exporter-workspace-db-rightarrow-csv) - **Real-Time Data Preview**: Once a target database table is selected, a secure background JSON query fetches live table schemas and actual database entries. - **Live preview Grid**: Renders a read-only preview grid of database table entries (up to 100 rows) with counts, table structure, and column headers. - **Memory-Safe Streaming**: Features streamed CSV downloads from the database, allowing memory-safe exports of large datasets using Laravel streamed responses. --- ๐Ÿš€ Installation -------------- [](#-installation) Install the package via Composer: ``` composer require rupeshgondaliya/laravel-csv-studio ``` Optional: Publish the configuration file to customize allowed tables, route prefixes, and middleware: ``` php artisan vendor:publish --tag=laravel-csv-studio-config ``` --- โš™๏ธ Configuration ---------------- [](#๏ธ-configuration) The published configuration file is located at `config/csv-importer.php`. Customize the settings as needed: ``` return [ /* |-------------------------------------------------------------------------- | Route Configurations |-------------------------------------------------------------------------- */ 'route_prefix' => 'csv-importer', 'middleware' => ['web'], /* |-------------------------------------------------------------------------- | Allowed Tables |-------------------------------------------------------------------------- | Specify an array of table names that are allowed for import/export. | Leave empty to allow all tables except the excluded tables below. */ 'allowed_tables' => [], /* |-------------------------------------------------------------------------- | Excluded Tables |-------------------------------------------------------------------------- */ 'excluded_tables' => [ 'migrations', 'password_resets', 'password_reset_tokens', 'failed_jobs', 'personal_access_tokens', 'sessions', 'jobs', 'job_batches', 'cache', 'cache_locks' ], ]; ``` --- ๐ŸŽจ Walkthrough & Usage ------------------------- [](#-walkthrough--usage) ### Launching the Studio [](#launching-the-studio) Navigate to the configured route in your web browser: ``` http://your-app.test/csv-importer ``` ### Flow 1: Importing CSV Data [](#flow-1-importing-csv-data) 1. Select **Import CSV Data** from the landing dashboard. 2. Select your destination database table and choose the **Import Mode** (Insert vs Update). 3. Drag & drop or browse your `.csv` or `.txt` file, then click **Analyze & Map Columns**. 4. Review the auto-mapped headers, double-click cells to modify values directly in the interactive grid, correct validation tooltips, and click **Verify & Import Data**. ### Flow 2: Exporting Database Tables [](#flow-2-exporting-database-tables) 1. Select **Export Table Data** from the landing dashboard. 2. Choose your target database table from the select list. 3. Review columns and actual records in the **Live Database Record Preview** grid. 4. Click **Export Data to CSV** to stream and download a clean CSV copy. --- ๐Ÿงช Testing --------- [](#-testing) Run the automated integration and unit test suite to verify everything functions properly: ``` vendor/bin/phpunit ``` --- ๐Ÿ‘ฅ Authors & Credits ----------------------- [](#-authors--credits) - **Rupesh Gondaliya** - - Created with a dedication to premium user experiences and robust web development practices. --- ๐Ÿ“„ License --------- [](#-license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 36 โ€” LowBetter than 79% of packages Maintenance87 Actively maintained with recent releases Popularity1 Limited adoption so far Community8 Small or concentrated contributor base Maturity41 Maturing project, gaining track record Bus Factor1 Top contributor holds 50% 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 Every ~0 days Total 2 Last Release 63d ago Major Versions v0.2.0-alpha โ†’ 1.0.02026-05-23 ### Community Maintainers ![](https://www.gravatar.com/avatar/ddc2446600944b37559e6c592035751cdf4cdf5a81b8173fe570c3ec0f8fa4b2?d=identicon)[gondaliyarupesh](/maintainers/gondaliyarupesh) --- Top Contributors [![gondaliyarupesh](https://avatars.githubusercontent.com/u/44920831?v=4)](https://github.com/gondaliyarupesh "gondaliyarupesh (2 commits)")[![ShreeSoftech-Rupesh](https://avatars.githubusercontent.com/u/92097236?v=4)](https://github.com/ShreeSoftech-Rupesh "ShreeSoftech-Rupesh (2 commits)") ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/rupeshgondaliya-laravel-csv-studio/health.svg) ``` [![Health](https://phpackages.com/badges/rupeshgondaliya-laravel-csv-studio/health.svg)](https://phpackages.com/packages/rupeshgondaliya-laravel-csv-studio) ``` ### Alternatives [illuminate/filesystem The Illuminate Filesystem package. 15265.2M3.3k](/packages/illuminate-filesystem) PHPackages ยฉ 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)