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 '20 at 23:04
  • I remember now. The same question was posted in the Google Docs Help Community in Spanish. – Rubén Jan 22 '20 at 23:09

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, privacy policy and cookie policy

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