Leverage templates to manage, merge, calculate and export board items to Excel spreadsheets and email them periodically with automations.
Worksheets
How to use worksheets to embed monday.com boards and prepare them for the export to Excel
Worksheets in Spreadsheet Gorilla work like in Excel or Google Sheets. You can + add up to 6 worksheets to a spreadsheet template. Each worksheet can contain one or more monday.com boards that will be used in your exported Excel spreadsheet. You want to use multiple worksheets to:
- Combine differently structured boards in one spreadsheet
- Add subitems of parent boards in a separate worksheet
- Calculate with advanced formulas across multiple boards
To add or append another board to a worksheet, click the + Add board or + Append board button. Then search for your designated board and click + to add it in your current worksheet. In case you want to add subitems of a specific board, simply search for Subitems of.
