Simple Python tool to clean Excel/CSV files:
- Remove duplicate rows (optionally by specific columns)
- Remove completely empty rows
- Save a cleaned Excel/CSV file named
cleaned_<original>
- Install dependencies:
pip install pandas openpyxl- Run:
python excel_cleaner.py- Enter the file name (e.g.
test.xlsx) and follow prompts.
Input test.xlsx with duplicates and empty rows.
Output: cleaned_test.xlsx.