Subitems
Export items and subitems with parent project details
Build an Excel report that keeps each task connected to its project. With Spreadsheet Gorilla, standard monday.com subitems are added as a separate Subitems of… board. Put parent items and subitems on separate worksheets, then use Parent ID to bring project details into each task row.
Standard subitems and multi-level boards
This guide covers standard boards with one level of subitems. Spreadsheet Gorilla currently warns that multi-level boards are not supported and their data may be incomplete or wrong. Exported Excel Cleaner is a different app with its own supported formats; its format support does not imply support in Spreadsheet Gorilla.
Example report
Two projects, three tasks, one row per task
Our fictional Projects board contains Website launch and Quarterly report. Each project has its own subitems. The finished report shows every task beside its parent project and client, even when one project has several tasks.
Download the example workbook. It contains Sheet1 with the parent items and Sheet2 with the task report and working Excel lookup formulas. It is a learning example of the output, rather than an importable app configuration. Spreadsheet Gorilla's custom formulas calculate exported values; the download retains Excel formulas so you can inspect how the lookup works.
Step 1
Create the parent-items worksheet
- Create or open a spreadsheet template.
- Name the first worksheet Sheet1 and add your Projects board.
- Keep Item ID in column A, the project name in B, and the client in C. Add Item ID through the column picker if it is not already present.
- Preview the worksheet and confirm it contains your two parent projects.
The lookup matches identifiers. Keep Item ID, even if the project names seem unique, and keep one row per parent item. Replace the fictional IDs in the example with the IDs exported from your own board.
Step 2
Add the subitems as their own board
- Add a second worksheet and name it Sheet2.
- Click Add board or Append board and search for Subitems of followed by your parent board's name.
- Select Subitems of Projects.
- Add Item ID, Parent ID, task name, status and hours, in that order.
- Preview Sheet2. Each subitem should have its own row and a Parent ID matching an Item ID on Sheet1.
The parent and subitem boards can have different columns, so configure both explicitly. Adding the Projects board alone does not automatically add its subitems.

Finding the subitems board
If the parent board is called Monthly Projects, search for Subitems of Monthly Projects. Check that you chose the subitems board belonging to the correct parent board.
Step 3
Look up the project and client for every task
On Sheet2, add two Custom formula columns after Hours: Project in F and Client in G. In this example, Parent ID is column B, and the parent data on Sheet1 occupies A2:C3, with headers in row 1.
Use this formula for Project:
=VLOOKUP(B$$,Sheet1!$A$2:$C$3,2,FALSE)
Use this formula for Client:
=VLOOKUP(B$$,Sheet1!$A$2:$C$3,3,FALSE)
B$$ uses the Parent ID on the current task row. The second argument is the parent lookup range, the third selects Project or Client, and FALSE requires an exact ID match. The dollar signs in $A$2:$C$3 keep the lookup range fixed. Read the custom formula syntax.
Adapt the worksheet name, column letters and range to your own preview. Extend the lookup range as your project list grows. Keep every parent referenced by a task in that range. A parent filtered out of Sheet1 cannot be found by this formula.
Look up a unique parent for each task. Looking up a task by Parent ID from the parent worksheet would return only the first matching task, so it would lose additional tasks when a project has several subitems.
Step 4
Verify the preview and download the report
- Preview the spreadsheet and open Sheet2.
- Check that both Design review and Final approval show Website launch / Client A, while Check figures shows Quarterly report / Client B.
- Confirm that there is one row for every expected task and that the IDs match the source boards.
- Download the Excel file. If you need a recurring report, set up an export and email automation.
When doing the lookup in Excel after downloading, use the actual row number instead of $$, for example B2 in the first task row. The example workbook demonstrates this version.
Troubleshooting
Missing tasks, parent details or formula results
Add the Subitems of… board to the template. Parent boards and standard subitem boards are configured separately.
The subitems worksheet only shows headers
Check the selected subitems board and its filters. Filters are configured on each board in the template and can exclude all tasks. Check that task columns were added to the worksheet.
The lookup shows #N/A
Find that task's Parent ID in the Item ID column on Sheet1. Check that the parent was not filtered out and that the lookup range includes its row. Use matching ID values and types in both sheets. Avoid replacing missing matches with zero, which hides the missing parent.
Can I filter subitems by their parent's group or status?
Filters on the standard subitems board apply to subitem columns. They do not automatically inherit the parent's group or status. If you need those values, include them on the parent sheet and look them up in the task report, then filter the downloaded Excel report.
Is this the same as exporting monday.com Formula columns?
No. These are custom spreadsheet formulas added to the template. Native monday.com Formula columns use separate, experimental support with Legacy and API modes.




