Link Spreadsheets and External Data in LibreOffice Calc

LibreOffice Calc allows users to connect multiple spreadsheets and dynamically import external information to keep data synchronized without manual copying. This guide explains how to reference cells from external workbooks, insert entire linked sheets, connect to web or CSV data, and manage existing external links effectively.

Method 1: Direct Cell Referencing Across Workbooks

The simplest way to reference a specific cell or range from another workbook is by pointing and clicking or by typing the file path directly into a formula.

Point-and-Click Method

  1. Open both the destination spreadsheet (where the data will appear) and the source spreadsheet (where the original data is located).
  2. In the destination sheet, select the target cell and type = to begin a formula.
  3. Switch to the source spreadsheet window and click the cell or highlight the range you want to link.
  4. Press Enter. The destination cell will now display the linked value and update whenever the source data changes.

Manual Formula Syntax

You can also manually write the external link formula using the following structure:

='file:///Path/To/Your/Workbook.ods'#$SheetName.CellAddress

Example:

='file:///home/user/Documents/Sales_Q1.ods'#$Summary.B5

Method 2: Inserting an Entire Linked Sheet from Another File

If you need an entire worksheet from another file to appear and dynamically update within your current document:

  1. Open your target spreadsheet.
  2. Go to the menu bar and click Sheet > Insert Sheet from File… (or Insert > Sheet from File… in older versions).
  3. Browse and select the source spreadsheet, then click Open.
  4. In the dialog box that appears, select the specific sheet you want to insert.
  5. Check the box labeled Link.
  6. Click OK. Any changes made to the original sheet will reflect in your current workbook upon reload.

Method 3: Linking to External Data (Web Pages, CSV, or Named Ranges)

Calc enables you to import named ranges, tables from HTML files, or data from remote servers.

  1. In your open spreadsheet, click Sheet > Link to External Data…
  2. In the URL of External Data Source field, type or paste the file path or web URL (e.g., https://example.com/data.html or a local file path).
  3. Press Enter to load the available data tables or named ranges.
  4. Select the desired table or range from the Available Tables/Ranges box.
  5. (Optional) Check the Update every box and specify an interval in seconds to automate data refreshes.
  6. Click OK.

Once links are established, you can update, modify file paths, or break connections at any time.

  1. Click Edit > Links to External Files… in the top menu.
  2. In the dialog window, you will see a list of all external sources referenced by the current workbook.
  3. Select a link to perform any of the following actions:
    • Update: Manually refresh the data from the source file.
    • Modify: Change the file path if the source document was moved or renamed.
    • Break Link: Convert all linked data into static values, removing the external dependency.
  4. Click Close when finished.