Is there a way to create a chart based on an ever-growing folder of sheets?

For instance, if I want to graph the running average of some value always found in cell A1 across all sheets within a certain folder or from date x to date y or with the same file name prefix of "ABCDE", is this possible? If so, how?

  • It's possible with a script that accesses a bunch of files in the folder and gathers data in one place, to plot there. But it's unclear whan the X-axis would be (what's the order of the spreadsheets?), and the whole thing seems hardly worth the effort. Better to invest the time into a saner data storage model.
    – user79865
    Commented May 12, 2016 at 0:00

1 Answer 1


You can by using the ImportRange() function, and then reference the first cell. You will just need to reference every sheet that you need the information from.


Column A                  Column B     Column C

unique Spreadsheet key    A1           =importRange(A1,b1)
unique Spreadsheet key    A1           =importRange(A1,b1)

You will also need permissions from every sheet that you want to import from.


It might be better to look at another way to output the data, maybe look to save it in a database.

Your Answer

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

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