Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get data from ODS files (OpenOffice/StarOffice spreadsheet)

I tried to Get data from folder with ODS files ( OpenOffice/StarOffice spreadsheets that are easily opened by Excel). However PowerBI does not recognize this format, which frankly speaking is strange, as MS Excel can easily read these files.


Could you please advise why PowerBI does not recognize this format?

Are there any plans for PBI to recognize ODS files?


I would like to avoid step with converting ODS to excel.



Community Support
Community Support

Re: Get data from ODS files (OpenOffice/StarOffice spreadsheet)

Hi @KasiaK 

There is a workaround: convert ods file to excel file using online tool, then connect to excel files with Power BI.


Best Regards


Frequent Visitor

Re: Get data from ODS files (OpenOffice/StarOffice spreadsheet)

Hi Maggie,


Thanks, but this actually does not answer my question and to be honest I would not recommend the solution you proposed.

Sharing any company reports online bears great risk of data leak. Secondy, using this tool takes longer than saving .ods file as .xlsx in Excel. Or saving .ods file as .xls. 


I would really appreciate if anyone could share information whether there are plans for PBI to recognize .ods files in the future.


Helpful resources


August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors