Google Sheet Error while importing

forman_dale

I am trying to import from a google sheet and keep getting the message that:

"An error occurred while importing from Google Sheets"

Brian_Richardson

I find this usually happens when the Google Sheet has multiple tabs. Import only works on the first tab. Or if the sheet has a lot of formulas on it and you've checked "include formulas".

I can often get it to work fine by taking a copy of the tab I'm trying to import into a new sheet (right click tab…copy to new sheet). Then import that.