Import data from other spreadsheets (IMPORTRANGE / workbook links)

[ni-ka]

Is your feature request related to a problem? Please describe. Sometimes it is very useful to be able to import data from another spreadsheet. For example, I have used this in the past to keep some base information (freelancer rates) in one file or to keep lists separate (with different access rights) but having an overview list that merges data from several lists.

Describe the solution you'd like Google sheets has the function IMPORTRANGE (https://support.google.com/docs/answer/3093340) while microsoft excel online has workbook links (https://techcommunity.microsoft.com/t5/excel-blog/workbook-link-support-coming-to-excel-for-the-web/ba-p/1590314)

Describe alternatives you've considered A solution would be an external app that is used to register links between spreadsheets and knows which range to copy, but I haven't seen something like this.

Additional context i found several feature requests on the forums and other places:

• https://forum.collaboraonline.com/t/insert-data-from-other-spreadsheets/93

• https://forum.onlyoffice.com/t/import-data-from-different-spreadsheet-files/369/8

• https://help.nextcloud.com/t/how-to-manage-link-between-cells-inside-spreasheets-with-collabora/45472

• https://www.reddit.com/r/selfhosted/comments/jj55lt/looking_for_online_database_spreadsheet_software/

• demo of importrange https://www.youtube.com/watch?v=DO0eacge-Cg

[carbontracking]

I support this enhancement request According to https://forum.onlyoffice.com/t/import-data-from-different-spreadsheet-files/369/8 it has been implemented in Document server v.7.3 and Community server v.12.5.

Any ideas when Collabora will be updated to include this ?

[ElRodal]

I also support this enhacement. We need it to get rid of gsuite

Looks as if in ONLYOFFICE has been done

https://forum.onlyoffice.com/t/import-data-from-different-spreadsheet-files/369/18 Tks

[Tex2002ans]

Here's some more helpful info explaining how this works within Google Docs:

• Google Docs Help: “IMPORTRANGE”

This IMPORTRANGE feature was also requested by a user (EtagiBI) in the Collabora Forums:

• https://forum.collaboraonline.com/t/referencing-ranges-in-other-sheets/2019

[bartvanpoll]

This feature missing is the online reason I can't work with Collabora Online yet... I use it in Google Sheets to create different files for my clients, with access only for them.

[MrRinkana]

So this does not work in collabora online I reckon?