This is to be able to connect these sheets and allow access to the sheets (to which we have the access rights anyway):Īfter giving permission for all spreadsheets, we can use the above query. We have to do this even if we refer to the same spreadsheet in which we write this formula, but for every spreadsheet it is enough to do it once. In order to use the above constructed query, we first need to call a single IMPORTRANGE() method for each of the spreadsheets we want to refer: =IMPORTRANGE('key-or-url-of-spreadsheet-1', ''sheet-name-1'!A2:Z100') This will open a dropdown menu containing a list of options. Of course, we can also arrange any other criteria, or omit them displaying everything without modification: 'SELECT * ' Here are the steps you need to follow to convert Google Sheets to Excel: Open the spreadsheet you wish to download to your computer.

The above query removes blank lines from imported ranges: SELECT * WHERE Col1 IS NOT NULLĪnd sorts ascending all data collected together in relation to the third column: ORDER BY Col3 ASCįor descending, just use DESC in place of ASC. 'SELECT * WHERE Col1 IS NOT NULL ORDER BY Col3 ASC' Of course, it is also possible to combine several IMPORTRANGE() functions with the QUERY() function, which gives us a greater control over the results we import.įor example, we can use such a construction: =QUERY(

Import google sheets to excel