ProperText

A simple Python utility to convert text columns in Excel (.xlsx, .xls) and CSV (.csv) files to Title Case (e.g., "SHAHRIAR PARVEZ" -> "Shahriar Parvez").

Features

• Multi-Format Support: Works with .csv, .xlsx, and .xls files.
• Smart Detection: Automatically detects file format and uses the appropriate method to read/write.
• Robust: Handles missing files and permission errors (e.g., if the file is open in Excel).
• Easy to Use: Simply place your file in the directory, configure the script, and run.

Requirements

• Python 3.x
• pandas
• openpyxl (for Excel support)

Installation

1. Clone this repository or download the files.

2. Install the required packages:

   pip install -r requirements.txt

Usage

1. Place your data file (e.g., example.csv) in the project directory.

2. Open main.py and update the INPUT_FILE variable with your filename:

   INPUT_FILE = "example.csv"
   OUTPUT_FILE = "example_proper.csv"

3. Run the script:

   python main.py

4. The script will generate a new file (e.g., example_proper.csv) with all text columns converted to Title Case.

License

This project is open-source and available under the MIT License.