A simple GUI application to process spreadsheet files.
- Load Excel (
.xlsx
,.xls
) and CSV (.csv
) files. - Select which columns to keep.
- Specify the header row.
- Select the sheet to process from multi-sheet Excel files.
- Clean the data by removing empty rows based on selected columns.
- Save the processed data to a new Excel or CSV file.
- Automatically renames unnamed columns to Excel-style column names (A, B, C...).
- Make sure you have Python 3 installed.
- Install the required dependencies:
pip install -r requirements.txt
- Run the application:
- On Windows, you can simply double-click the
run.bat
file. - Alternatively, you can run from the command line:
python main.py
- On Windows, you can simply double-click the