Converts any xlsx sheet to csv file in utf-8 format. Microsoft excel does not save csv file in utf-8 format which makes it difficult to read charecters which are not english.
We can use other tools for that like google sheets, but it has limits as if the file is big, it won't work.
- python 2.7
Who do I speak with to get the values for configuration files?
Anas Khalil [email protected]
You can use pip to install xlrd.
- xlrd: Library for developers to extract data from Microsoft Excel (tm) spreadsheet files Installation: pip install xlrd
- install python 2.7 and add it to the system path
- install the dependencies
- run the following command: python ConvertToCsv.py
- The tool will give instructions to complete the tasks