Export monday.com Subitems to Google Sheets

Subitems sit on their own board behind each parent item, which makes them easy to lose in a flat export. This guide covers getting them into a sheet as rows under their parents.

Why subitems go missing

A subitem is a real item on a hidden subitems board, linked to its parent. An export that reads one board and one row per item does not carry them along cleanly, and a flattened export loses which parent a subitem belonged to. For reporting that usually matters: hours, owners and status often live on the subitems, not the parent.

How the add-on writes them

When a saved export has Include subitems on, every parent item is written as a row, and its subitems follow immediately underneath as their own rows. Two columns are added at the front of the tab:

Item typeParent itemNameStatus
itemWebsite relaunchWorking on it
subitemWebsite relaunchMigrate blog postsDone
subitemWebsite relaunchRedirect mapStuck

The example is invented. The subitem rows use the same columns you selected for the export, read from the subitem's own values.

Step by step

  1. Connect your monday.com personal API token from Extensions › monday.com Exporter › Open exporter. See exporting a board if you have not done this yet.
  2. Add a saved export and pick the parent board.
  3. Choose your columns and turn on Include subitems.
  4. Run the export, then filter the Item type column to subitem or pivot on Parent item.

Troubleshooting

A subitem shows blank cells

Subitems have their own column set. A column you selected that does not exist on the subitem board is blank on subitem rows. That reflects the board structure, not a failed export.

Subitem rows are missing

Check that Include subitems is on for that saved export and that the parent item actually has subitems in monday.com.

Totals double count

A parent and its subitems are all rows. When summing a numeric column, filter on Item type first, or the parent's own figure and its subitems' figures will both be counted.

Subitems as rows under their parents

With subitems switched on, monday.com Exporter writes each subitem directly below its parent item and adds Item type and Parent item columns so you can filter and pivot.

See monday.com Exporter Install from Google Workspace Marketplace

I'm the developer of monday.com Exporter, so weigh this guide accordingly. monday.com and Google Sheets™ are trademarks of their respective owners. This add-on is independent and is not affiliated with or endorsed by either.