Centralize Google Sheets tables (QUERY + IMPORTRANGE)

Here is a not so complicated way to gather data from diferent tables and put it into a single one. All we need is to mix a QUERY function with several IMPORTANGE functions.

[redripper]

Thank you very much, this helped me troubleshoot some problems I was having on a project. Much appreciated!

[TheHeatingEngineer]

A very useful and well presented tutorial. Thank you.

[hpapasutube]

So simple and good explanation! good job!

[adminmangjaja]

Great video with simple explanation, good job

[mkt_]

Thank you for the lesson!

I have a question..I create a model for documents with hundreds of cell intervals (ex.B2:B2) linked between 1 sheet (imput) and other 4 sheets (ouputs) and I want to use it all with different data.

If a create a copy it will create a new link and it should be update for every cell. Is there any way to update the link on the sheets, maybe with a multiple selection? I can't find an answer but I think it should be possible!


Thnks in advance..

[sergheyzaporojanu]

Hey! thank you so much for the deepdive about this beautiful function. I am curios if it is possible crosslink 2 files between eachother in the same table. I hope I'm not confusing you too much. Basically I have 2 tables: Questions and Answers. And I just want to connect them together. But the challenge is when the row is inserted in Questions table, I am having misaligned response rows from Question table.

I'm really curious about this idea since it would allow me a data exchange without oversharing the file where the Experts are answering the questions.

I really appreciate your support!

[HemantVerma-yurn]

Can we consolidate more 8 tan ins single sheet how to consolidate these because more then two query is stop working

[MsElish]

Hi, I am using query + importrange to get data from different file, but for few of cells are getting blank. Can you please help me on this

[RevimerCCunanan]

Hi! Thank you for this very helpful information. May I know how many files i can combine? is it limited?

[apoorvsom]

hi! amazing video man. Thanks a ton. what if the columns are in different order in table 1 & 2, or if there are extra columns that are not common in one or the other sheet?

[PROMOTIONSATSPORTSL]

Not working showing Error IN ARRAY_LITERAL, an Array literal was missing Values for one or more rows.

[ninadpawar]

Hello how to change data from master sheet when I tried to change, i got an error.

[Salta-ktnh]

Thanks for the explanation. It only seems to work if i do a single cell. When i try to do all cells I require, it gives me the following message "Error
Array result was not expanded because it would overwrite data in E2"

Do you know what may be the reason?

[chefibu]

Thanks alot, very informative, how can i sum the value from 2 different spreadsheet into 1 master sheet.
For ex: sales of branches in different spreadsheet and sum total of sales in 1 master sheet

[Moonwalker]

I did exactly the same but if I start to combine the Sheets closer with "Select * where Col1>0", 0) ... Google tells me that there is an "Issue while parsing" the Files. It's such a easy code... but what I'm doing wrong??
🤔

[jhfnspo]

Hi, very useful formula. I have one query though, "col3>0" didn't work on my file, if you could please explain this one please. thank you

[Lil-ymsn]

Thank you, I have a question. If I want pull some cells from the sheet and different sheets into summary?

I got a huge data contains 100 sheets and all are same in design but the content is different.
I would like to summarize these sheets into one page

Example: sheet one
Sheet1: total of Sells, purchase, cost, transportation
Sheet2:total of sells, purchase, cost, transportation

How to pull some cells into summary? I want for each sheet one row.

Thank you again 💓

[qqizzvh]

hey! will be there anyone who tells how to select not all collumns like "*", bute certain collumns like A, B, and E???

[birlodeanu]

Dear Radu,
Must add... sorting on query... show to the people entire think....

[feketealexandru]

Mult stimate Radu !!! Am dar oarecum întâmpător de canalul tău de youtube, nu am dorit cu ardoare să învăţ excel deoarece eu sun de creo 8-9 ani doar pe linux iar acolo nu este microsoft office (adevărul că şi acolo s-ar putea folosi officeul de la microsoft) dar eu nu-l folosesc din aversitate faţă de orice de la microsoft. Dar bineânţeles există ţi open source pentru excel sub linuc de ex. free office sau mai ales libre office dar mi sunt şi altele . Adevărul că acesre softuri aşa numit deschise şi gratuite diferă de office ul de la microsoft pentru că sunt adaptate oarecum dar eu aş zice că nu este nici o problemă. Eu aş sugera dacă se poate de a face un video cu diferenţele pentru calcul tabelar dintre ele. Ştiu că se poate argumenta că nu are nici un rost pentru că eceste softuri nu sunt bune nu constitue nici o pondere in folosirea lor şi aşa mai departe dar pe de altă parte de ce să nu încurajăm oarecum prin acesta folosirea lor pentru ca lumea să nu folosescă ilicit programe plătite gratis. Mulţumrsc mult pentru înţelegere cer scuze pentru că m-am băgat unde nu-mi fierbe oala. Cu deosebite respecte şi cu mare simpatie Fekete Alexandru din Oradea.