# Best way to "bring in" data from other spreadsheets
**URL:** https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980
**Category:** Ask for Help
**Created:** [June 14, 2021, 4:47pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980 "2021-06-14T16:47:18Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Tinjaw](https://community.glideapps.com/u/Tinjaw)
#### Post date: [June 14, 2021, 4:47pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/1 "2021-06-14T16:47:18Z")
I am building an event app. I originally only intended to use the multiple tabs on one google sheet. However, presenters have their own sheets with info I would like to show. What is the best way to use multiple sheets in one app?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [June 14, 2021, 5:26pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/2 "2021-06-14T17:26:00Z")
You could use an IMPORTRANGE formula to create new tabs in your main Sheet that would pull in data from the others’ sheets into their own tabs of your main Sheet. Either that, or provide access to your sheet through the Sharing options in Google Sheets and the others can make their own tabs directly from your main sheet.
---
### Author:  [@Tinjaw](https://community.glideapps.com/u/Tinjaw)
#### Post date: [June 14, 2021, 5:39pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/3 "2021-06-14T17:39:33Z")
I am not sure that would be dynamic. Wouldn’t that just be a snapshot of the data at the time it was taken?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [June 14, 2021, 5:45pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/4 "2021-06-14T17:45:23Z")
An IMPORTRANGE should update itself automatically when used. I don’t know what the delay would be when it’s used in conjunction with a Glide app, but it shouldn’t be any more significant than the usual Google Sheets delay.
---
### Author:  [@Tinjaw](https://community.glideapps.com/u/Tinjaw)
#### Post date: [June 14, 2021, 6:00pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/5 "2021-06-14T18:00:58Z")
Thanks. I’ll try that and report back.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [June 15, 2021, 1:20am UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/6 "2021-06-15T01:20:17Z")
I was just researching the same and came across this…
> [@praypray\>25K rows in GT, or external database. So needed!](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/31):
>
> You list your database in another workbook all together. Then you use vlookup to pull the data. you can use the importrange function directly in the vlookup or set it separately. I recently started using the importrange function directly in the vlookup to save time. It looks like this: =VLOOKUP(A1,(IMPORTRANGE( "sheet url here", SHEET1!A1:B10)), 2, FALSE)) You can do the same with with an arrayformula just widen the range and add the function at the beginning like this: =ARRAYFORMULA(VL…
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 15, 2021, 1:32am UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/7 "2021-06-15T01:32:39Z")
IMPORTRANGE works quite well when your source data has a fixed set of columns that don’t/wont change. If that’s not the case, then it’s risky and subject to breakage.
I use IMPORTRANGE generally only when the source sheets are under my control and so I can guarantee there won’t be any nasty surprises.
For anything else (ie. “untrusted” data sources) I find it safer to write import scripts with appropriate exception handling.
---
### Author:  [@Tinjaw](https://community.glideapps.com/u/Tinjaw)
#### Post date: [June 15, 2021, 2:13am UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/8 "2021-06-15T02:13:12Z")
It did do what I needed it to do.
Thank you.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [June 15, 2021, 2:02pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/9 "2021-06-15T14:02:39Z")
Yeah, it would be easier to find but I’m a no name contributor 🙂
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [June 15, 2021, 2:05pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/10 "2021-06-15T14:05:57Z")
Nah you just changed your icon one too many 😜
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [June 15, 2021, 2:06pm UTC](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980/11 "2021-06-15T14:06:38Z")
lol, the demotion from community expert didn’t help either, lmao.