I'd like to use another spreadsheet's data as the data range for a pivot table.

In order to import data from another spreadsheet, one can use the impotrange function.

But can it be imported directly into a pivot table?

Such an attempt states it's not a valid range:

No import for Pivot

  • I had a déjà vu: I'm pretty sure that somewhere I read and answer a very similar question.
    – Rubén
    Jan 22, 2020 at 23:04
  • I remember now. The same question was posted in the Google Docs Help Community in Spanish.
    – Rubén
    Jan 22, 2020 at 23:09

1 Answer 1


It's not possible to import range by adding a formula in the Pivot Table editor, you have to add there a reference to a range in the current spreadsheet.

If you don't want that the sheet with the imported data be visible you could hide it.

Another alternative is to use Google Data Studio. Depending on the purpose of your pivot table, you could use GDS to "explore" a data connection to the source spreadsheet or to create a report.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.