CsvConverter - Python CSV to Excel tool

Why ?

I wanted to develop my own tool to be able to blur-out parts of documents without having to rely on web tools or specific softwares that require subscription or payments to access “an Entire World of possibilities” where actually I just needed one specific feature.

How ?

To achieve my Csv converter tool I used Python’s

• sys & io
• pathlib
• pandas
• PyQt5.

Despite the normal Input/Output logic and some GUI features implemented with PyQt.
The core principle of this tools is to use pandas to read files with:

pd.read_csv(csv_file)

Pathlib to deal with file paths

# Create output path for individual file
csv_path = Path(csv_file)
output_file = Path(self.output_path) / f"{csv_path.stem}.xlsx"

and finally use pandas again to write a new file with

df.to_excel(output_file, index=False)

Result

The result is the following.
The interface on its own:

The inferface with a .csv selected:

And finally, once it is treated:

Try it yourself !

If you want to try it, you can download it directly from here, unzip, and launch the .exe

Please note that this .exe might fire security warnings. This is a normal behaviour since this little app hasn’t been signed through a Certificate Authority (CA).