Abstract
The increasing use of Excel spreadsheets for storing and exchanging structured information creates challenges
in maintaining data consistency across multiple versions of the same dataset. Manual comparison of large Excel
files is time-consuming, error-prone, and inefficient, especially when datasets contain numerous fields or undergo
frequent updates. This paper presents an Excel Sheets Comparison and Reconciliation System, a web based
solution that automates the identification and analysis of differences between two Excel spreadsheets.
The proposed system allows users to upload source and target Excel files and select a unique key field, such as
Roll Number, Name, or Email, for record-level comparison. The system identifies matching and mismatched
records, records missing from either file, and specific fields containing discrepancies. It also provides search and
filtering facilities, summary information, persistent storage of previous comparison activities, and downloadable
reconciliation reports. The system is implemented using Java, Spring Boot, Spring Data JPA, MySQL, Thymeleaf,
and Apache POI. An attendance dataset is used as a representative example, although the system can be applied
to various structured Excel datasets. The proposed solution reduces manual verification effort, improves
discrepancy detection reliability, and supports efficient data reconciliation in educational, administrative,
organizational, and business applications.
References
[1] R. R. Panko, “What We Know About Spreadsheet Errors,” Journal of Organizational and End
User Computing, vol. 10, no. 2, pp. 15–21, 1998.
[2] E. Rahm and H. H. Do, “Data Cleaning: Problems and Current Approaches,” IEEE Data
Engineering Bulletin, vol. 23, no. 4, 2000.
[3] I. P. Fellegi and A. B. Sunter, “A Theory for Record Linkage,” Journal of the American
Statistical Association, vol. 64, no. 328, pp. 1183–1210, 1969.
[4] D. G. Brizan and A. U. Tansel, “A Survey of Entity Resolution and Record Linkage
Methodologies,” Communications of the IIMA, vol. 6, no. 3, 2006.
[5] E. Rahm and P. A. Bernstein, “A Survey of Approaches to Automatic Schema Matching,” The
VLDB Journal, vol. 10, no. 4, pp. 334–350, 2001.
[6] A. Halevy, A. Rajaraman, and J. Ordille, “Data Integration: The Teenage Years,” Proceedings of the
32nd International Conference on Very Large Data Bases (VLDB), pp. 9–16, 2006.
[7] P. Christen, Data Matching: Concepts and Techniques for Record Linkage, Entity Resolution, and
Duplicate Detection, Springer, 2012.
[8] S. Aurigemma and R. R. Panko, “The Detection of Human Spreadsheet Errors by Humans versus
Inspection (Auditing) Software,” 2010.
[9] OpenRefine, “Reconciliation,” OpenRefine Documentation. The documentation describes reconciliation as
matching a dataset with an external source and relates it to record linkage, data matching, entity resolution,
field matching, and duplicate detection.
[10] M. A. Hernández and S. J. Stolfo, “The Merge/Purge Problem for Large Databases,” Proceedings of
the 1995 ACM SIGMOD International Conference on Management of Data, pp. 127–138, 1995.
[11] P. Christen, “Febrl: An Open Source Data Cleaning, Deduplication and Record Linkage System with a
Graphical User Interface,” Proceedings of the 14th ACM SIGKDD International Conference on Knowledge
Discovery and Data Mining, pp. 1065–1068, 2008.
[12] P. Christen, T. Churches, and M. Hegland, “Febrl – A Parallel Open Source Data Linkage
System,” Proceedings of the 8th International Conference on Computational Science, 2004.
[13] A. K. Elmagarmid, P. G. Ipeirotis, and V. S. Verykios, “Duplicate Record Detection: A Survey,”
IEEE Transactions on Knowledge and Data Engineering, vol. 19, no. 1, pp. 1–16, 2007.
[14] Du Plessis, C., & Wa Nkongolo, M. (2026). Detecting reconciliation discrepancies in tabular data
using transformers. Frontiers in Artificial Intelligence, 9, Article 1840051.
[15] Heterogeneity in entity matching: A survey and experimental analysis. (2026). Data &
Knowledge Engineering, 164, Article 102575.