PHPackages                             frantzley/excel-to-mysql-web - 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. [Database & ORM](/categories/database)
4. /
5. frantzley/excel-to-mysql-web

ActiveLibrary[Database & ORM](/categories/database)

frantzley/excel-to-mysql-web
============================

Professional PHP package to import Excel files into MySQL with validation and upsert

v1.1.0(8mo ago)10MITPHPPHP >=8.0CI passing

Since Sep 13Pushed 7mo agoCompare

[ Source](https://github.com/frantzleyadolphe/excel-to-mysql-php)[ Packagist](https://packagist.org/packages/frantzley/excel-to-mysql-web)[ RSS](/packages/frantzley-excel-to-mysql-web/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (1)Versions (2)Used By (0)

Excel to MySQL Web Importer
---------------------------

[](#excel-to-mysql-web-importer)

```
Yon pake PHP ki pèmèt ou enpòte done soti nan fichye Excel (`.xls` / `.xlsx`)
nan yon baz done MySQL avèk tout opsyon sa yo ki nan pwen kle
Li fèt pou devlopè ak itilizatè ki bezwen yon travay rapid, epi li ofri
yon UI senp ak fonctionnalités avanse tankou live logs,
progress bar, ak filtre logs.

```

🛠 Features
----------

[](#-features)

```
- Kreye baz done otomatik si li pa egziste.
- Kreye tab otomatik selon headers nan Excel.
- Li sipote fichye ki gen plizye sheets
- Insert / Update done otomatik.
- Kle inik pou evite doublon.
- Logs dinamik ak filtraj (`insert`, `update`, `exists`, `error`, `info`).
- Progress bar pou montre pwogrè.
- Mesaj erè koneksyon nan logs UI.
- Responsiv UI ak Tailwind CSS ak glassmorphism effect pou logs.

---

```

💻 Installation
--------------

[](#-installation)

```

```

Enstale via Composer:

```
composer require frantzley/excel-to-mysql

```

Estrikti Projet an
------------------

[](#estrikti-projet-an)

```

project-root/
├─ public/
│  ├─ index.php # Upload form ak UI
   ├─ app.js     #js file
│  ├─ process.php    # Backend processing (pre-bati)
├─ src/
│  └─ ExcelToMySQL.php
├─ uploads/          # Folder pou fichye upload (kreye otomatik si li pa egziste)
├─ vendor/           # Composer dependencies

```

Asire w gen PhpSpreadsheet enstale:

```
composer require phpoffice/phpspreadsheet

```

⚡ Usage
-------

[](#-usage)

```
Louvri browser ou sou public/index.php.

Chwazi fichye Excel ou a, antre non tab la nan DB, ak kle inik si ou vle.

Klike Upload & Import.

Log yo ap parèt vivan ak koulè selon aksyon yo:

Ble → nouvo insert

Jòn → deja egziste

Wouj → erè

```

🔧 Column Mapping
----------------

[](#-column-mapping)

```
Otomatik: Premye ranje nan Excel la sèvi kòm header; kolòn DB yo pran menm non.

Manyèl: Ou ka chanje kolòn DB yo si bezwen:

$importer->setMapping([
    "Excel Name"  => "db_name",
    "Excel Email" => "db_email"
]);

Tab la kreye otomatikman selon mapping lan.

```

📦 Example pou test PHP Usage
----------------------------

[](#-example-pou-test-php-usage)

```