Python script for importing data from an Excel file into a MySQL database with progress tracking.
This script utilizes pandas to read data from an Excel file and mysql.connector to interact with a MySQL database. It creates a table in the specified database and inserts the data from the Excel file into the table.
- Reads data from an Excel file.
- Handles NaN values, replacing them with 'None'.
- Creates a table in a MySQL database based on specified schema.
- Inserts data into the MySQL database table with a progress bar.
- Python 3.x
- pandas
- mysql-connector-python
- tqdm
-
Clone the repository:
git clone https://github.com/muamal2/excel-to-mysql-importer.git
-
Install the required dependencies:
pip install pandas mysql-connector-python tqdm
-
Place your Excel file (
example.xls
) in the same directory as the script. -
Modify the
db_config
dictionary in the script with your MySQL database connection details. -
Run the script:
python excel-to-mysql-importer.py
-
Monitor the progress bar as data is inserted into the database.
Contributions are welcome! If you have suggestions or improvements, feel free to open an issue or submit a pull request.
This project is licensed under the MIT License - see the LICENSE file for details.