Google Sheet Error while importing

Options

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

"An error occurred while importing from Google Sheets"

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers
    Options

    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.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN