Import Excel to MySQL Using PHP

This topic is entitled Import Excel to MySQL Using PHP, I believe that this source code will be a big help to everyone who wanted to Import the Excel/CSV file to MySQL Database.

In this project, I use twitter bootstrap framework for the themes and MySQL Database for storing the imported data from excel file. 

Screenshot of this project Import Excel to MySQL Using PHP

How to Execute the Project

Step 1: Download the Full Source code here: excel source code 

Step 2: Extract the downloaded source code and put it in the Document root or in your htdocs folder

Step 3: Create a MySQL Database, Name it as “studentdb“.

Step 4: Create a table, use the query below:

[sql]
CREATE TABLE `subject` (
`SUBJ_CODE` varchar(30) NOT NULL,
`SUBJ_DESCRIPTION` varchar(255) NOT NULL,
`UNIT` double NOT NULL,
`PRE_REQUISITE` varchar(30) NOT NULL DEFAULT 'None',
`COURSE_ID` int(11) NOT NULL,
`AY` varchar(30) NOT NULL,
`SEMESTER` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[/sql]

Step 5: Run your project: copy this link to your browser. http://localhost/excel/index.php

Note:

In order for you to import the excel file, make sure that the format of excel file is set to CSV.

You can use the sample csv file located in your main document folder.

Please see the image below for your reference. The file is “subject.csv”.

If you have any questions or suggestion about Import Excel to MySQL Using PHP, please feel free to contact me at our contact page.

If you find this article useful, please a comment below and share this with your friends who loves to do programming.

Technology stack and requirements

To run this PHP project, you need these tools on your development machine:

• XAMPP or WAMP server. Bundles Apache, MySQL, and PHP so you can run PHP on Windows without individual installs. Free from apachefriends.org.
• PHP 8.0 or higher. Included with XAMPP. Older versions (5.x, 7.x) may work but modern PHP features improve security and performance.
• MySQL or MariaDB. Comes with XAMPP. phpMyAdmin manages the database through a browser UI.
• VS Code or PhpStorm. Free code editor with PHP syntax highlighting, IntelliSense, and debugging support.
• Web browser. Chrome, Firefox, or Edge for testing the running app.

Installing the source code

1. Download the archive. Get the ZIP file from the download link on this page and extract it.
2. Move to htdocs. Place the extracted folder inside C:\xampp\htdocs\ so Apache can serve it.
3. Import the database. Open http://localhost/phpmyadmin, click Import, and select the .sql file included in the archive.
4. Update database credentials. Open the config.php or connection.php file and set the correct database name, username, and password (default XAMPP: root / empty password).
5. Run the project. Start Apache + MySQL in XAMPP, then visit http://localhost/your-project-folder/ in a browser.

Using this project for your BSIT capstone

This PHP project maps cleanly to standard BSIT capstone documentation. Suggested chapter alignment:

• Chapter 1 (Introduction). Discuss the problem the system solves in real-world context. Cite Philippine business or academic use cases where a manual process could be replaced.
• Chapter 2 (Review of Related Literature). Compare this system’s features against 5-10 similar published projects. Cite journals like IJERT or IEEE Access for academic-standard sources.
• Chapter 3 (Methodology). Include Use Case Diagram, Data Flow Diagram, Entity Relationship Diagram, and Activity Diagram covering all major workflows.
• Chapter 4 (Results and Discussion). Screenshot each module of the running system with a caption explaining what data it processes and which user role interacts with it.
• Chapter 5 (Conclusion and Recommendations). Identify features that could be added in a Version 2, such as mobile app, REST API export, or AI-powered analytics.

Modules typical of Import Excel to MySQL Using PHP

• Master data. CRUD forms for the primary entities with search and filter.
• Transaction processing. Data entry forms for day-to-day operations the system automates.
• Reports. Formatted printable output summarizing activity per day, user, or category.
• User management. Login with role-based permissions (Admin, Encoder, Viewer).
• Backup and restore. Export database to a .sql file and restore when needed.

Common enhancements for capstone review

• Modernize the UI. Add Bootstrap 5 or Tailwind CSS for a polished appearance.
• Add printable receipts. Use TCPDF or FPDF to generate PDF reports.
• Multi-user concurrency. Ensure database handles simultaneous writes without lost-update errors.
• Rewrite in Laravel. Migrate to Laravel for maintainability and modern development patterns.

Related PHP Projects

• Import CSV File In CodeIgniter With Source Code
• Exporting Data To Excel MySQL Using PHP
• Online Cellphone System Using PHP
• Simple Forum Using Phpmysql
• Simple Login Form With Validation Using MySQL In PHP
• Ticket Reservation System In PHP

Joken E. Villanueva

Founder & Lead Developer at PIES IT Solution

Founder of PIES Information Technology Solutions, a software company building production-grade applications for institutions across the Philippines. Over 8 years of hands-on full-stack development experience, currently leading the development of ClinicAI, an AI-powered clinic management platform.

Expertise: PHP · MySQL · JavaScript · AI Integration · SaaS Architecture · VB.NET · Database Design · Capstone Documentation · Java
 · View all posts by Joken E. Villanueva →