See code at Github. https://github.com/brandondrury/XLSX_to_CSV
Problem
A number of tools/scripts require human-editable files such as .csv. We typically worked in .xlsx files. While manually saving a file as .csv file wasn’t exactly labor-intensive, it was an extra step that often broke concentration and generally slowed things down.
Solution
This Python script converts an .xlsx Excel file to a .csv files with two clicks. This is useful in times when our tools are designed for .csv files.
Use
- Place XLSX_to_CSV.cmd in Windows > Run > Shell > Sendto
- Right click on the .xlsx file and select Sendto > XLSX_to_CSV.cmd
- A .csv version will be created in the same directory as the .xlsx file