Why is this IMPORTRANGE formula not working?

Question

I keep getting an error while using the IMPORTRANGE formula:

=importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”, “Sheet1!A:B”)

I changed the name of my sheets several times to make sure everything matches but see a:

Formula parse error

and I am not sure what I am doing wrong. The original sheet has several tabs as well.

Can you see where the error is?

Solution 1

This worked for me:

=importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”; “Sheet1!A:B”)

Maybe try it with a semicolon

Solution 2

Add the link format eg =importrange("https://docs.google.com/spreadsheets/d/1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc","Sheet1!A:B") this should fix it

Solution 3

One other issue that can prevent import range from working is leading or trailing space in your sheet name. Make you check the sheet tab and clean out any leading or trailing spaces or your formula won't work. :-)

I burned an hour reading this thread and recreating my formula over and over again before I finally found the issue.

Solution 4

Make sure the sheet you're trying to import from is saved as a google sheet. I was trying to import an .xls file into a google sheet, and it wouldn't work. I re-saved the sheet as a google sheet and it fixed the problem immediately.

Solution 5

Problem

This formula does not work

=importrange(“1uUbz2HAzgwBwY3zMXqLJM_Z8qVQZHNP0aNHceTc”,“Sheet1!A:B”)

Reason why

You use curly double quotes “ ” instead of straight double quotes " "

SOLUTION

Change the quotes from curly to straight
=importrange("1uUbz2HAzgwBwY3zMXqLJM_Z8qVQZHNP0aNHceTc","Sheet1!A:B")

Be careful
If you have different locale you must also change , to ;

View more solutions

Comments

[Anders Östman]

Semicolon worked! To bad Google themself does not say anything about this solution

[CalamitousCode]

Just a note: quotes are only required if the sheet name has a space in it.

[CalamitousCode]

The link format is not required but can be used if desired.

[CalamitousCode]

This is a regional thing. Some regions use commas and some use semicolons in formulas.