# How to get all all data in all sheets using node-red-contrib-spreadsheet-in?

**URL:** <https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820>\
**Category:** General\
**Created:** [28 July 2020 10:53 UTC](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820 "2020-07-28T10:53:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AK51](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ak51/32/8438_2.png) [@AK51](https://discourse.nodered.org/u/AK51)\
**Post date:** [28 July 2020 10:53 UTC](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820/1 "2020-07-28T10:53:05Z")

</div>

Hi. After I have downloaded the spreadsheet-in and run the built-in example, it works fine except that I need to specify the sheet name (e.g. sheet1), how can I read all data in all sheets?

Thanks.

 ![sheet1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/0/f08ef00fe3ba1cf414910c2b6710e060cb1a9b0a.jpeg)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [28 July 2020 12:13 UTC](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820/2 "2020-07-28T12:13:00Z")

</div>

The `Book` node returns an array of the sheet names in msg.payload.SheetNames

You will need to loop thru the array and pass each sheet name to the `sheet to json` node

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [26 September 2020 12:13 UTC](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820/3 "2020-09-26T12:13:02Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.