Excel Cleaner: A Web-Based Application for Automated Data Cleaning

Abstract

Data cleaning is a crucial stage in data analysis because the quality of input data directly affects the accuracy of results and decision-making. Real-world Excel datasets often contain missing values, duplicate records, inconsistent formatting, and incomplete entries, which make preprocessing difficult and time-consuming when performed manually. Traditional cleaning methods using spreadsheets or scripts are often repetitive, error-prone, and unsuitable for non-technical users. This paper presents Excel Cleaner, a web-based application designed to automate the preprocessing of Excel datasets in an efficient and user-friendly manner. The system follows a client–server architecture in which users upload Excel files through a web interface and receive cleaned outputs in real time. The application performs key cleaning operations such as removal of empty rows, duplicate elimination, and column normalization. It is implemented using React for the frontend, Node.js and Express for backend processing, and the XLSX (SheetJS) library for Excel file handling. Experimental results show that the system provides high accuracy and fast processing for small to medium-sized datasets. The proposed solution reduces manual effort, improves data quality, and offers a scalable foundation for future enhancements such as intelligent data cleaning and visualization.

Introduction

1. Agriculture AI-based Weed Detection System (Summary)

Agriculture faces challenges from weeds that reduce crop yield, while traditional weed control methods are labor-intensive and environmentally harmful. The proposed solution uses an AI-powered robotic system that combines computer vision and machine learning to detect weeds and apply herbicide only where needed. The robot uses cameras, sensors, and embedded AI models (like CNN/YOLO) to identify weeds in real time and spray selectively, reducing chemical usage and improving efficiency. The system promotes sustainable farming by increasing productivity, lowering costs, and minimizing environmental damage.

2. EMI and Household Financial Behaviour Study (Summary)

The study explores how EMI-based credit affects spending and saving habits in Indian households. While EMIs make purchases easier and improve affordability, they also tend to increase consumption and reduce savings. Existing research shows mixed outcomes, but most agree that easy credit access encourages higher spending. However, there is limited understanding of the psychological and behavioral reasons behind EMI usage. The study aims to examine how people decide safe EMI limits and how credit influences financial behavior beyond numerical impacts.

3. Excel Cleaner System (Summary)

Data preprocessing is essential because raw Excel datasets often contain missing values, duplicates, and inconsistent formatting. Manual cleaning is time-consuming and error-prone, while existing tools require technical skills. The proposed Excel Cleaner is a web-based system that automates data cleaning using React, Node.js, and SheetJS. It allows users to upload Excel files and automatically removes errors, duplicates, and inconsistencies, producing clean structured data. The system simplifies preprocessing for non-technical users and improves efficiency and accuracy.

4. EMI Impact Research (Large Survey Study) (Summary)

The study examines how EMI credit influences Indian spending and savings behavior. With rising fintech adoption, EMIs make purchases more accessible but often reduce savings. Survey results show most respondents are aware of EMIs and use them mainly for affordability. While EMIs help manage expenses, many users also report increased unnecessary spending and reduced savings. The study highlights that easy credit access significantly shapes financial behavior, especially among young adults, and raises concerns about long-term financial stability.

5. AI-based Weed Detection Robot (Methods & System Summary)

The system integrates AI, robotics, and IoT to automate weed detection and herbicide spraying in agriculture. It uses a camera, embedded processing unit, sensors, and a spraying mechanism mounted on a mobile robot. A deep learning model (CNN/YOLO) processes images in real time to identify weeds and trigger targeted spraying. The system reduces herbicide usage, improves accuracy, lowers labor costs, and supports sustainable farming. Performance is evaluated using accuracy, precision, recall, and response time.

6. Excel Cleaner System (Methodology + Architecture Summary)

The system automates Excel data cleaning using a web-based client-server architecture. Users upload files via a React frontend, which are processed by a Node.js backend using SheetJS. The system converts Excel data into JSON, removes duplicates, empty rows, and inconsistent formatting, then converts it back to Excel. It also generates cleaned data and error reports for transparency. The architecture ensures scalability, fast processing, and easy usability for non-technical users.

7. EMI Behaviour Research (Methodology + Survey Summary)

This study analyzes how EMI usage affects financial behavior using a survey of 53 respondents, mostly young adults and students. Results show high EMI awareness and usage, mainly due to affordability and easy access. Many respondents believe EMIs help manage expenses but also contribute to increased spending and reduced savings. The study highlights that EMI-driven consumption is strongly linked to lifestyle and accessibility factors, especially among younger populations.

Conclusion

In conclusion, the Excel Cleaner system successfully addresses the challenges associated with manual data cleaning by providing an automated, efficient, and user-friendly solution. It simplifies the process of handling raw and unstructured Excel datasets by performing essential preprocessing operations such as removing duplicates, handling missing values, and standardizing data formats. The system significantly reduces the time and effort required for data preparation, which is often one of the most time-consuming tasks in data analysis. By minimizing human intervention, it also improves the accuracy and consistency of the cleaned data. The intuitive interface ensures that users from both technical and non-technical backgrounds can easily use the application without requiring programming knowledge. Another key strength of the system is its ability to provide transparency through features such as data preview and invalid data detection. Instead of permanently removing incorrect records, the system separates them, allowing users to review and understand errors. This enhances trust and usability. Overall, the Excel Cleaner system proves to be a practical and reliable tool for data preprocessing. It can be effectively used in academic projects, business environments, and research applications where clean and structured data is essential for accurate analysis and decision-making.

References

[1] Microsoft Corporation, Microsoft Excel Documentation, Available at: https://support.microsoft.com/excel [2] SheetJS, XLSX JavaScript Library Documentation, Available at: https://docs.sheetjs.com [3] Node.js Foundation, Node.js Documentation, Available at: https://nodejs.org/en/docs [4] Express.js, Express Framework Documentation, Available at: https://expressjs.com [5] React Documentation, React – A JavaScript Library for Building User Interfaces, Available at: https://react.dev [6] W3Schools, HTML, CSS, and JavaScript Tutorials, Available at: https://www.w3schools.com [7] Kelleher, J. D., & Tierney, B., Data Science Fundamentals for Python and MongoDB, O’Reilly Media, 2018 [8] Rahm, E., & Do, H. H., “Data Cleaning: Problems and Current Approaches,” IEEE Data Engineering Bulletin, Vol. 23, No. 4, 2000 [9] Kimball, R., & Caserta, J., The Data Warehouse ETL Toolkit, Wiley Publishing, 2004 [10] Han, J., Kamber, M., & Pei, J., Data Mining: Concepts and Techniques, Morgan Kaufmann, 2011

Copyright

Copyright © 2026 Prof. Shital Gujar, Dhruv Shikhare, Harshal Dalvi, Mayur Sanap, Abhishek Jadhav. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.