All answers I have reviewed say use IMPORTRANGE by referencing the "KEY=" in the URL of the source cell. I find no "KEY=" in the source URL. So I always receive a "parse error."
Google-sheets – How to import cell data from one workbook to a different workbook
google sheetsimportrange
Related Solutions
Only after having requested that the documents were to be shared with us, was I able to determine what's going on.
The response sheet is new Google Sheet proof:
The sheet, in which you want to pull the data in, doesn't have this mark.
You are trying to import the data via the complete URL (new Sheets style) from within an old Google Spreadsheet. This is where Google says: No Can Do !!
If you use the key instead, it works just fine:
=IMPORTRANGE("1zRHatplJ6AVUSWr1HXoycUrvtK05dw4-ZqeEYN1xJ4Y", "B:B")
See references for more information on this topic.
References
Spreadsheet functions cannot access the content of other spreadsheets, other than by invoking importrange.
But you can have importrange inside other functions. For example,
=join(",", importrange("...", "Sheet1!A1:A5"))
returns the content of cells A1:A5 in the other spreadsheet, comma-separated within one cell. Another command often nested is query, which allows you to do a lot of processing of another spreadsheet's data without getting intermediate results in. For example:
=query(importrange("...", "Sheet1!A1:B9"), "select Col1, sum(Col2) group by Col1 order by Col1")
returns the totals of the second column split by the values of the first column, and sorts by the first column.
Related Topic
- Google-sheets – Reverse lookup from Google Spreadsheets key
- Google-sheets – How to use IMPORTRANGE with a variable range-string pulled from a cell
- Google-sheets – Problem with IMPORTRANGE function in Google Sheets
- Google-sheets – What spreadsheets import from the spreadsheet
- Google-sheets – Using a single cell serving as an ID source for formulas to import data from
- Google-sheets – I am having trouble using indirect to access a cell in a different Google Spreadsheet
- Google-sheets – Problem with results of filter function from tabs that have no data yet
Best Answer
You can use the entire url:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1QDCf2MDkN7eopuTT-EieQI39Bpc_Y6D-3EWefimpk/edit#gid=0", "A:A")But just the spreadsheet id should also work:
=IMPORTRANGE("1QDCf2MDkN7eopuTT-EieQI39Bpc_Y6D-3EWefimpk", "A:A")More generally the google sheets url is structured like this:
https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=sheetIdThe spreadsheet id's used in this answer don't exist and are only included as examples.
Documentation Spreadsheet id
Documentation importrange.