OKTAL : Jurnal Ilmu Komputer dan Sains
Vol 5 No 06 (2026): OKTAL : Jurnal Ilmu Komputer Dan Sains

Sistem Konversi Data Excel Menjadi MySQL untuk Efisiensi Pengolahan Data pada PT. Afra Indo Safety

Anggie Syahputra (Universitas Pamulang)
Farizi Ilham (Universitas Pamulang)
Barren Al Faridzi (Universitas Pamulang)
Thio Mandala Putra (Universitas Pamulang)



Article Info

Publish Date
18 Jun 2026

Abstract

Microsoft Excel is still widely utilized by organizations for data management activities due to its user-friendly and flexible nature. Nevertheless, spreadsheet-based data storage faces several challenges, including duplicate records, input inaccuracies, inefficient information retrieval, and limitations in data integration. This study aims to develop a system capable of converting and integrating data from Excel files into a MySQL database in order to improve the effectiveness and accuracy of data management processes. The research methods include observation, interviews, literature review, and software development using the Waterfall approach, which consists of requirements analysis, system design, implementation, testing, and maintenance stages. The system was developed using PHP and MySQL and is equipped with features such as Excel file uploading, data mapping, data validation, and automated data migration into the database. The implementation results demonstrate that the system can accelerate data processing activities, minimize recording errors, maintain data consistency, and facilitate users in accessing and managing information in a more organized manner. Therefore, the developed system can serve as an effective solution for supporting more efficient, accurate, and integrated organizational data management.  

Copyrights © 2026






Journal Info

Abbrev

oktal

Publisher

Subject

Astronomy Chemistry Computer Science & IT Electrical & Electronics Engineering Social Sciences

Description

1. Komputasi Lunak, 2. Sistem Cerdas Terdistribusi, Manajemen Basis Data, dan Pengambilan Informasi, 3. Komputasi evolusioner dan komputasi DNA/seluler/molekuler, 4. Deteksi kesalahan, 5. Sistem Energi Hijau dan Terbarukan, 6. Antarmuka Manusia, 7. Interaksi Manusia-Komputer, 8. Hibrida dan ...