This script reads an Excel file and converts it into a CSV format with a semicolon delimiter. It uses the pandas
library to load the Excel file and export the data to a CSV file.
Before running the script, make sure you have the necessary libraries installed. You can install them via pip
:
pip install pandas
-
Ensure you have Python installed on your system.
-
Modify the
excel
variable in the script to point to the file you want to process. -
Modify the
csv
variable in the script with the name you want. -
Place your Excel file in the same directory as the script or specify the full path to the file.
-
Run (where is located) the script using:
python CsvScript.py
- The script creates the CSV in the same location as the Excel file.
- Backup your file before running the script if necessary.