How to convert a .ods file to .csv?

Question

I've used xlrd for .xlsx files, but I haven't been able to find an equivalent for .ods files. How can I convert some_file.ods to some_file.csv using python?

Answer 1

pip install odspy

pandas uses it to read ods files.

To convert to cvs w/pandas:

python

import pandas as pd
df = pd.read_excel('my_excel.ods')
df.to_csv('my_excel.csv')