Import Data from another Synology Spreadsheet
Posted: Wed Mar 18, 2026 7:59 pm
OMG it is possible... 
This is the game changer!
Import Data from another Synology Spreadsheet
You can import data from another Synology Spreadsheet with the IMPORTRANGE function.
To import data from another Synology Spreadsheet:
Open your spreadsheet.
Enter =IMPORTRANGE into a cell.
Add the following parameters in quotation marks and separated by a comma. Wrap all parameters in parentheses.
Spreadsheet URL (e.g., https://example.com/oo/r/abc123abc123)
Sheet name and cell range (e.g., Sheet1!A1:C3)
The function should look like =IMPORTRANGE("https://example.com/oo/r/abc123abc123","Sheet1!A1:C3")
Press Enter.
Click Connect Content to authorize the import.
To refresh external data links:
Click Data > Manage Links.
Choose one of the following:
Auto refresh: Automatically update external data regularly.
Refresh all: Manually update all linked data.
Refresh specific links: Click the ⋮ icon and select Refresh.
To break links:
Click Data > Manage Links.
Choose one of the following:
Break all links: Converts all imported data to values.
Break a specific link: Click the ⋮ icon and select Break link.
Group Data in a Synology Spreadsheet
Spreadsheet supports up to eight levels of grouping.
To create a group:
Select the rows or columns to group.
Right-click and group.
To remove a group:
Select the the rows or columns to ungroup.
Right-click and ungroup.
This is the game changer!Import Data from another Synology Spreadsheet
You can import data from another Synology Spreadsheet with the IMPORTRANGE function.
To import data from another Synology Spreadsheet:
Open your spreadsheet.
Enter =IMPORTRANGE into a cell.
Add the following parameters in quotation marks and separated by a comma. Wrap all parameters in parentheses.
Spreadsheet URL (e.g., https://example.com/oo/r/abc123abc123)
Sheet name and cell range (e.g., Sheet1!A1:C3)
The function should look like =IMPORTRANGE("https://example.com/oo/r/abc123abc123","Sheet1!A1:C3")
Press Enter.
Click Connect Content to authorize the import.
To refresh external data links:
Click Data > Manage Links.
Choose one of the following:
Auto refresh: Automatically update external data regularly.
Refresh all: Manually update all linked data.
Refresh specific links: Click the ⋮ icon and select Refresh.
To break links:
Click Data > Manage Links.
Choose one of the following:
Break all links: Converts all imported data to values.
Break a specific link: Click the ⋮ icon and select Break link.
Group Data in a Synology Spreadsheet
Spreadsheet supports up to eight levels of grouping.
To create a group:
Select the rows or columns to group.
Right-click and group.
To remove a group:
Select the the rows or columns to ungroup.
Right-click and ungroup.