ImportRange not Working? – let’s fix it

ImportRange parse error

QUERY parameter 2: NO_COLUMNCol2

That string I got after I had copied my perfectly working sheet to a New Google Spreadsheet.

Googling made suggestion that New Google Sheets don’t work correctly with ImportRange Function.

However, here is a simple workaround how to fix it.

There was an original string in a cell ( ___- is a hidden chunk by me):

=query(ImportRange("11dz______Li1BLqoV77OelEq431pajE2_5434";"unic!A:G");"select * where Col2 contains '____'")

You have to rewrite it in this way first:

ImportRange("11dz______Li1BLqoV77OelEq431pajE2_5434";"unic!A:G")

After that you’ll be prompted to Allow Access which you have to allow .

And only then you can write an original string:

In my example it is still:

=query(ImportRange("11dz______Li1BLqoV77OelEq431pajE2_5434";"unic!A:G");"select * where Col2 contains '____'")

Enjoy ImportRange in New Google Sheets!