Google Sheets – How to Import a Column from One Sheet to Another

google sheetsimportrange

I don't look for ImportRange because I want to stay within the same Google Sheets spreadsheet. Instead, I want to import a column from one sheet into a column of another sheet within the same spreadsheet.

Best Answer

One way to do this is with ArrayFormula. If the sheet you want to import from is named Sheet1 and you want to select the entirety of column A, you can do the following:

=ArrayFormula('Sheet1'!A:A)

You can see an example of this in action here: https://docs.google.com/spreadsheets/d/1kJraNDzrLF8-W_BxbL8pU6e_QuoMqFcl_sgyzT14L2Y/edit?usp=sharing

In general you can use the form [SheetName]![Range] to pull in data from another sheet from within the same spreadsheet. In this case, ArrayFormula is needed to expand the entire range instead of just importing the first cell in the range.

post edited

Consideration

The IMPORTRANGE function requires two parameters (strings):
- spreadsheet key
- data range
  The data range needs to correspond to the number of columns you're about to use. In your case, you selected only column B and column C. Therefore, going beyond col2 will end up in failure.
There are two distinct ways to use a parameter:
- numbers
- strings

Data

enter image description here

Number

=QUERY(                                                // data
  IMPORTRANGE(
    "0AluAYY6ZHeWYdE5XampzQVl4dVpxZ3FoVW9mUkdwQkE",    // spreadsheet key 
    "DATA!A:C"                                         // datarange
  ), 
  "SELECT Col1 WHERE Col3=" & C2, 0)                   // query
)

enter image description here

String

=QUERY(                                                // data
  IMPORTRANGE(
    "0AluAYY6ZHeWYdE5XampzQVl4dVpxZ3FoVW9mUkdwQkE",    // spreadsheet key 
    "DATA!A:C"                                         // datarange
  ), 
  "SELECT Col1 WHERE Col2=" & "'" & B2 & "'"           // query
)

enter image description here

Example

I've created an example file for you:

Test data for QUERY
Result for QUERY

Google Sheets IMPORTRANGE – How to Import a Range from One Spreadsheet to Another

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:
enter image description here

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.

Best Answer

Related Solutions

Google-sheets – Import Google Spreadsheet range if a column contains a particular value

Consideration

Data

Number

String

Example

Google Sheets IMPORTRANGE – How to Import a Range from One Spreadsheet to Another

References

Related Topic