Import items into subitem from Excel

Feature requests
1

Description

Ability to import items into subitem in native monday.com

What are you trying to achieve

ability to add multiple products to subitem from excel

2

Hi Aaryan,

If you’re looking to import multiple products from Excel directly into subitems, we’ve built an app that supports exactly that — creating items and subitems (including multi-level structures) from Excel or Google Sheets.

It’s currently in the process of being submitted to the monday.com marketplace, but we’re offering early access to users who need this functionality now.

Happy to share access if this would help your workflow.

— Janré

3

Thanks Janre. Do you have demo video I can look to see if it works for me?

4

Hi Aaryan,

Yes — I’ve recorded a short demo showing the app importing items and multi-level subitems from an Excel into a subitem board.

Here’s the walkthrough:

If it looks like it would work for your use case, feel free to DM me and I’ll share early access details while we finalize the marketplace submission.

— Janré

5

Hey Aaryan :waving_hand:

Subitem import from Excel is one of the most requested features in these forums, and for good reason. monday.com’s native importer just doesn’t support it.

A few things worth knowing as you evaluate options:

The tricky part with subitem imports isn’t just getting data into subitems, it’s correctly detecting which rows are parents and which are children. Depending on how your Excel is structured, hierarchy might be indicated by indentation, a parent column, WBS numbering (1.0, 1.1, 1.2), or something else entirely. Worth checking that whatever tool you use can handle your specific format.

Also, if your subitem board has different columns than the parent board (which it sounds like it might, since you’re importing products), make sure the column mapping handles that. monday.com subitems have their own column structure, so the mapping needs to work for both levels.

I’m building an app called TaskLoops that handles this. It auto-detects parent/child hierarchy from your spreadsheet structure and maps columns separately for items and subitems. The CSV/Excel import is free and unlimited, including AI-powered column mapping that suggests matches with confidence scores. Still in marketplace review, but if you want to try it, sign up at taskloops.com and I’ll send you an install link.

What does your Excel structure look like? Happy to help you think through the best approach regardless.

6

Thanks Nick for the clarity. We realize we can not do much with the sub items so we have changed our approach to item boards basically connecting two boards

7

Hi @aaryan.gupta
You can achieve this using Make.

A common approach is to upload the Excel file to Google Sheets or another accessible source, then use a Make scenario to read each row and automatically create subitems under the correct parent item in monday.

For example:

  • Make reads the Excel rows (each row = one product).

  • It identifies the parent item the products belong to.

  • Then it creates subitems for each row with the product details.

This way you can bulk add multiple products as subitems without manually entering them one by one.

As a complimentary, here is our magic link to get 1 Month Pro plan free (10,000 operations)
https://www.make.com/en/register?pc=msquare

If you need any implementation support kindly contact us

MSquare Support
Visit us here
Youtube Channel