Pengamanan File Excel Berformula dengan Menggunakan Kriptografi Advanced Encryption Standard-256 Dan Encoding Base64
DOI:
https://doi.org/10.17509/ekrm6h82Keywords:
AES-256, Base64, Cryptography, Excel Files, Securing DataAbstract
The rapid development of technology today has digitilized various aspects of human life, including data processing. Using Microsoft Excel, data processing becomes easier as it leverages formulas for automated calculations. However, Excel formulas and file contents often contain sensitive information, posing a security risk if accessed by unauthorized parties. This research aims to implement the Advanced Encryption Standard (AES-256) cryptographic algorithm and Base64 encoding for securing Excel files containing formulas. The security process involves converting plaintext data and keys into hexadecimal format using the ASCII table, followed by encryption using the AES-256 algorithm. The encrypted output is then encoded in Base64, resulting in text that is unreadable to humans and difficult to analyze without the decryption process. A program to implement this process was developed using the Python programming language. This implementation provides a practical solution for securing sensitive data.
References
Astuti, E., Yunita, P., Tambunan, F., Wahyuni, F. S., & Setiyawati, R. I. (2023). Pelatihan pengenalan dan penerapan aplikasi komputer microsoft excel pada SMU Swasta Dharmawangsa Medan. Abdikan: Jurnal Pengabdian Masyarakat Bidang Sains Dan Teknologi, 2(1), 50-57.
Azlin, A., Musadat, F., & Nur, J. (2018). Aplikasi kriptografi keamanan data menggunakan algoritma base64. Jurnal Informatika, 7(2), 1-5.
Efendi, M., Sihombing, V., & Parulian, S. (2021). Implementation and use of base64 algorithm in video file security. Sinkron: Jurnal dan Penelitian Teknik Informatika, 6(1), 243-247.
Halimi, A., Tholib, A., & Yaqin, M. A. (2024). Optimasi keamanan data penerimaan mahasiswa menggunakan aes-256, sha-256, dan base64. JUSTIFY: Jurnal Sistem Informasi Ibrahimy, 3(1), 38-45.
Mahajan, P., & Sachdeva, A. (2013). A study of encryption algorithms AES, DES and RSA for security. Global Journal Of Computer Science And Technology, 13(15), 15-22.
Manikandaprabhu, P., & Samreetha, M. (2024). A review of encryption and decryption of text using the AES algorithm. International Journal of Scientific Research & Engineering Trends, 10(2). 400-404.
Nuari, R., & Ratama, N. (2020). Implementasi algoritma kriptografi AES (Advanced Encryption Standard) 128 bit untuk pengamanan dokumen shipping. Journal Of Artificial Intelligence And Innovative Applications, 1(2), 37-44.
Rahman, A. (2019). Perancangan aplikasi pengamanan file pada memory card handphone menggunakan algoritma kunci asimetris Elgamal. JURIKOM (Jurnal Riset Komputer), 6(5), 531-537.
Utami, W. C., Marwati, R., & Gozali, S. M. (2023). Penggabungan kriptografi Rivest Shamir Adleman (RSA) dan advanced encryption standard (AES) pada aplikasi pengirim e-mail. Interval: Jurnal Ilmiah Matematika, 3(2), 92-101.
Wen, S., & Dang, W. (2018). Research on base64 encoding algorithm and PHP implementation. In 2018 26th International Conference on Geoinformatics (pp. 1-5). IEEE.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 M. Kesha Mauluddy Rachman, Rini Marwati, Imam Nugraha Albania (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
