Create, Save, Open and Close a Workbook in LibreOffice Calc

This beginner tutorial would show you how to Create, Save, Open and Close a Workbook in LibreOffice Calc.


Workbook is nothing but the Calc file itself. Typically, a workbook contains multiple worksheets. Worksheets are the “tabs” named “Sheet1”, “Sheet2” etc.
To create a workbook follow below steps:

Click File -> New -> Spreadsheet OR press key – CTRL+N


A new spreadsheet would open which you can use for your purpose.


Save options are present in File menu.

Save option saves the file with updated content.
Save As option can save the file in desired path with a new file name.
Save a copy saves a copy of the current open workbook in a desired path.

Save to a Remote Server option saves to a remote disk/storage/cloud storage such as Google Drive. Once you click this option, below dialog would open:


Click on the Add Service button. In the next dialog, choose your desired remote destination and provide credentials.


Currently below are the services available in LibreOffice Calc 5+.

  • Google Drive
  • Alfresco 4/5
  • IBM FileNet P8
  • Lotus Live Files
  • Lotus Quickr Domino
  • Nuxeo 5.4
  • OpenDataSpace
  • OpenText ELS 10.2.0
  • SharePoint 2010
  • SharePoint 2013
  • WebDav
  • FTP
  • SSH
  • Windows Share



Open option opens a Calc workbook file. You can choose the path with open file dialog and choose a file to be opened.



Close option closes the currently opened Calc file.


Next Chapter   Worksheets