# Import data into a relationship field

**URL:** <https://forum.adalo.com/t/import-data-into-a-relationship-field/54693>\
**Category:** Database\
**Created:** [March 15, 2025, 7:31pm UTC](https://forum.adalo.com/t/import-data-into-a-relationship-field/54693 "2025-03-15T19:31:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![andreasxalbrecht](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@andreasxalbrecht](https://forum.adalo.com/u/andreasxalbrecht)\
**Post date:** [March 15, 2025, 7:31pm UTC](https://forum.adalo.com/t/import-data-into-a-relationship-field/54693/1 "2025-03-15T19:31:57Z")

</div>

Dear Adalo Support,

I have seen many forum questions around the above topic but unfortunately no clear answer. The situation seems quite straightforward: For my event calendar app, I have a collection called “events”, which includes a relationship field with the unique ID linking to a sub collection called “eventDetails”. My screen gets the event date from the events collection and the event details, such as description and a picture, from the eventDetails collection.

This works fine, as long as I populate the relationship field manually, selecting the correct ID from a drop-down list. However, I have thousands of records, and a manual data entry for all records is impossible! I need to make make a bulk upload into that field.

Here is the issue: I have no problem to populate all text or number fields via csv upload but that relationship field does not accept any upload. The field just stays empty, see below screenshot. I do know the required values, in fact they are the ones written in number field “EventDetail\_ID” but I can neither import, nor copy them into the relationship field.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/0/6/060f7722ad7de1e73c95d4bb59c29470c23f46a4.png)

Can you please help me? How can I make a bulk upload to the above “EventDetail” field, or alternatively copy the values from the number field to the relationship field? I am desperate.  
Thank you!

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [March 25, 2025, 7:11am UTC](https://forum.adalo.com/t/import-data-into-a-relationship-field/54693/2 "2025-03-25T07:11:18Z")

</div>

Hi Andreas @andreasxalbrecht,

For one to many this is possible.

Please have a look here [Importing Records from a CSV File | Adalo Resources](https://help.adalo.com/database/importing-records-from-a-csv-file), select the “In Depth” explanation, paragraph 3:  
`One-to-Many: Can be matched up as long as the first property of the records of the other collections are identical. For instance, if importing Trips with a relationship to a user john@test.com, the Users collection must have a user with this email and have Email set as the first property in the collection.`

Of course “EventDetail” collection values in the 1st column should be unique so that import works correctly.

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![andreasxalbrecht](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@andreasxalbrecht](https://forum.adalo.com/u/andreasxalbrecht)\
**Post date:** [March 25, 2025, 9:54am UTC](https://forum.adalo.com/t/import-data-into-a-relationship-field/54693/3 "2025-03-25T09:54:10Z")

</div>

Hi Victor,

thank you for answering my enquiry.

I was aware of the instruction you quoted, but it is not working, no matter what I do: Pls see my setup:

 ![](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/1/e/1e04297ca8ddd4c1f4d0c30ae4e5136504eaa387.png)

No matter, what I do, the .csv import will not populate the relationship field “EventDetail”.

Question: How can I get the above Events\_Adalo collection to accept my values for the realtionship field? Alternatively, how can I copy accross the values from the adjacent number field?

Yet another possibility might be to link the two collections NOT using a relationship field, but via any other matching fields. Is that possible? Is it this, what your quoted instruction is referring to?

Note: I know how to populate the relationship field manually, selecting a value from the drop-down list. This works perfectly for a limited selection of test data, but for 2000+ records, it is not an option.

Thank you for helping me with this, it is crucial for the functioning of this app.  
With best regards

**Andreas Albrecht**  
Amministratore Delegato  
Mobil: +39 327 499 6435

**Venezia Catamaran s.r.l.**  
Via Jacopo da Riva 5/D, 30126 Venezia  
P.IVA: IT 04628150270

**[www.venezia-cat.it](http://www.venezia-cat.it/)**  
instagram @veneziacatamaran