# How to import lists within lists?

**URL:** <https://community.novulo.com/t/how-to-import-lists-within-lists/71>\
**Category:** \[Q&A\] Components, Datasets and Plug-ins\
**Created:** [April 3, 2024, 7:56am UTC](https://community.novulo.com/t/how-to-import-lists-within-lists/71 "2024-04-03T07:56:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bas](https://avatars.discourse-cdn.com/v4/letter/b/a587f6/32.png) [@Bas](https://community.novulo.com/u/Bas)\
**Post date:** [April 3, 2024, 7:56am UTC](https://community.novulo.com/t/how-to-import-lists-within-lists/71/1 "2024-04-03T07:56:19Z")

</div>

Hey Novulo, how do I import a list that contains a secondary list?  
In this case, I’ve got product data, and a field with individual pros and cons for each product. So how can I import this as a list?  
The other data can be mapped quite neatly on specific products

 ![afbeelding](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/8aa673b13f2c1e8373e9099729172bf9e4d2c7b0.png)

---

<div class="post-metadata">

**Author:** ![j.batzke](https://yyz2.discourse-cdn.com/flex008/user_avatar/community.novulo.com/j.batzke/32/9_2.png) [@j.batzke](https://community.novulo.com/u/j.batzke)\
**Post date:** [April 3, 2024, 9:47am UTC](https://community.novulo.com/t/how-to-import-lists-within-lists/71/2 "2024-04-03T09:47:37Z")

</div>

Hey Bas,

I don’t see a way to import your Excel list in one go because of its formatting.  
As a rule of thumb: Every row in an Excel list refers to a record, and every column to a field of that record.  
So if you want to import the pros and cons you would first need to transform the data to the following format:  
**Product reference (SKU) | pro\_con |**  
CSLUDX-0000C-01 | Comfortabele professionele training  
CSLUDX-0000C-01 | Minimale belsting op de gewrichten  
CSLUDX-0000C-01 | Breed scala aan trainingen

I would then recommend either using sequential imports (M3624) to trigger 2 import definitions or to just manually start two imports.  
So in your case, you would first import all products, and then you would import the pros/cons that would be linked to the products that have been imported earlier.

I hope this helps!  
Regards  
Joachim
