How to Transfer Excel Sheets to Open Office. In addition to opening its own native .ODF file format, OpenOffice Calc can also open worksheets from other spreadsheet software such as Excel.