# Best way to "bring in" data from other spreadsheets **URL:** \ **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:** 1\ **Showing post:** 6
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@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… --- _[View the full topic](https://community.glideapps.com/t/best-way-to-bring-in-data-from-other-spreadsheets/27980)._