# CSV Import Help **URL:** \ **Category:** Get Help\ **Created:** [June 9, 2020, 6:21pm UTC](https://forum.adalo.com/t/csv-import-help/1791 "2020-06-09T18:21:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![cmitton](https://avatars.discourse-cdn.com/v4/letter/c/e47774/32.png) [@cmitton](https://forum.adalo.com/u/cmitton)\ **Post date:** [June 9, 2020, 6:21pm UTC](https://forum.adalo.com/t/csv-import-help/1791/1 "2020-06-09T18:21:35Z")
I can only get the CSV import to import new items into the collection. I want the import to update the data in my collection. Any way that a CSV can overwrite what is in the collection? ---
**Author:** ![ashley](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ashley/32/1635_2.png) [@ashley](https://forum.adalo.com/u/ashley)\ **Post date:** [June 11, 2020, 5:36pm UTC](https://forum.adalo.com/t/csv-import-help/1791/2 "2020-06-11T17:36:21Z")
This feature is not available at this time. CSV’s only add new records. ---
**Author:** ![TORCH](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/torch/32/12331_2.png) [@TORCH](https://forum.adalo.com/u/TORCH)\ **Post date:** [June 12, 2020, 1:30pm UTC](https://forum.adalo.com/t/csv-import-help/1791/3 "2020-06-12T13:30:50Z")
There’s a way to do this but it is not readily available in Adalo. You will need Zapier. Zapier is widely used here in Adalo to automate some processes. Are you just updating part of rows or entirely replacing the collection? Either way Zapier is the way to go. @cmitton ---
**Author:** ![DPS](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@DPS](https://forum.adalo.com/u/DPS)\ **Post date:** [June 22, 2020, 10:05am UTC](https://forum.adalo.com/t/csv-import-help/1791/4 "2020-06-22T10:05:18Z")
Hi, I am trying to do this but am breaking my head on a wall, maybe you can help me! I simply want to have a collection that syncs 2 ways with either airtable or google sheets. The collection has relational data but that can stay in adalo. How would I do this, zapier + airtable doesn’t seem to have update function, and google sheets update function appears to be broken! Thanks ---
**Author:** ![ldyer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ldyer/32/1249_2.png) [@ldyer](https://forum.adalo.com/u/ldyer)\ **Post date:** [June 25, 2020, 9:56pm UTC](https://forum.adalo.com/t/csv-import-help/1791/5 "2020-06-25T21:56:08Z")
AHHH, I thought I was going crazy. The is rather disappointing. We should be able to export the collection, update, and then re-import the exact same file. ---
**Author:** ![DPS](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@DPS](https://forum.adalo.com/u/DPS)\ **Post date:** [June 27, 2020, 3:56am UTC](https://forum.adalo.com/t/csv-import-help/1791/6 "2020-06-27T03:56:23Z")
Hi Torch, I am trying to do this but am breaking my head on a wall, maybe you can help me! I simply want to have a collection that syncs 2 ways with either airtable or google sheets. The collection has relational data but that aspect can stay in adalo. How would I do this, zapier + airtable doesn’t seem to have update function, and google sheets update function appears to be broken! Thanks ---
**Author:** ![TORCH](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/torch/32/12331_2.png) [@TORCH](https://forum.adalo.com/u/TORCH)\ **Post date:** [June 27, 2020, 9:35am UTC](https://forum.adalo.com/t/csv-import-help/1791/7 "2020-06-27T09:35:27Z")
I have been away. I will do a video tutorial how to do this when im back from my trip. My Question: How many data is existing in acollection and how many you want to import? Is it updating existing rows or totally deleting all rows? ---
**Author:** ![Sopmac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sopmac/32/1540_2.png) [@Sopmac](https://forum.adalo.com/u/Sopmac)\ **Post date:** [August 24, 2020, 2:46pm UTC](https://forum.adalo.com/t/csv-import-help/1791/8 "2020-08-24T14:46:22Z")
How you manage to import new items, for me doesn’t work. I created my collections and then export the csv file and fill that up with my date. When I import it nothing happens. Regards ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [August 25, 2020, 8:40am UTC](https://forum.adalo.com/t/csv-import-help/1791/9 "2020-08-25T08:40:40Z")
Can you provide a screenshot of the csv data you are trying to import and another screenshot of the collection you are importing to. ---
**Author:** ![Sopmac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sopmac/32/1540_2.png) [@Sopmac](https://forum.adalo.com/u/Sopmac)\ **Post date:** [August 25, 2020, 11:20am UTC](https://forum.adalo.com/t/csv-import-help/1791/10 "2020-08-25T11:20:36Z")
Hello Colin Here is a couple fo screenshots I am not sure what is wrong there! Regards ![Screenshot 2020-08-25 at 08.13.31](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/badfd4408e4c3e29cd191c6233bd7fcf621dfb7c.png) ! ![Screenshot 2020-08-25 at 08.10.03](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/9b3967143ea905e772b8e34803eec513cb6203b5.png) ! ![Screenshot 2020-08-25 at 08.10.08](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/252bddcaf8d31c1547d08eb67d4ca963656759f0.png) ! ![Screenshot 2020-08-25 at 08.13.58](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/894b4029bdba22023451be7fe2677270799551cc.png) ! ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [August 25, 2020, 12:24pm UTC](https://forum.adalo.com/t/csv-import-help/1791/11 "2020-08-25T12:24:15Z")
Please make sure that for any relational property in that Products collection, that you have matching records existing in the primary field of the related collection. So for example, if Merchants is a relational property to a merchants collection that there are records in that collection and they match with what you are uploading. Same for any other relationship set up. ---
**Author:** ![Sopmac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sopmac/32/1540_2.png) [@Sopmac](https://forum.adalo.com/u/Sopmac)\ **Post date:** [August 25, 2020, 12:33pm UTC](https://forum.adalo.com/t/csv-import-help/1791/12 "2020-08-25T12:33:59Z")
> [@anon78309838](#): > > collection Hello Colin, I don’t have any data on that Merchants Collection the only relational property I have data is the Main Categories. Do you think is better to delete the empty columns on the CSV file? Regards ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [August 25, 2020, 12:38pm UTC](https://forum.adalo.com/t/csv-import-help/1791/13 "2020-08-25T12:38:21Z")
You can either delete the empty columns or you can choose in the import option just not to include them by not matching them to a column from the csv. ---
**Author:** ![Sopmac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sopmac/32/1540_2.png) [@Sopmac](https://forum.adalo.com/u/Sopmac)\ **Post date:** [August 25, 2020, 12:51pm UTC](https://forum.adalo.com/t/csv-import-help/1791/14 "2020-08-25T12:51:51Z")
Hello I got the some problem! ![Screenshot 2020-08-25 at 09.44.15](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/6d1f7008a4332dbebcdda7b6f48adda8d893e099.png) ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [August 25, 2020, 1:45pm UTC](https://forum.adalo.com/t/csv-import-help/1791/15 "2020-08-25T13:45:19Z")
Can you DM me a link to the CSV please. ---
**Author:** ![LiFox](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@LiFox](https://forum.adalo.com/u/LiFox)\ **Post date:** [October 15, 2020, 4:32pm UTC](https://forum.adalo.com/t/csv-import-help/1791/16 "2020-10-15T16:32:43Z")
Hi everyone, I have a similar issue with the csv import. Somehow adalo does not recognize the columns within my data correctly. Am I doing something wrong? I already tried using “;” instead of “,” but didn’t work either. Thank you very much in advance! ![grafik](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/6c4a6f8ec71224d67ae311218de81c7bbd0c25c5.png) ![grafik](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/09f18d17b57d0ef7d67959cf24673ef1bf430d74.png) ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [October 19, 2020, 3:30pm UTC](https://forum.adalo.com/t/csv-import-help/1791/17 "2020-10-19T15:30:02Z")
If you have Google Sheets, try creating it in there and downloading the spreadsheet as a csv then importing it. I’m not sure what the difference is in Excel and Google Sheets, but I’ve never had any problems when doing it through GS. ---
**Author:** ![LiFox](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@LiFox](https://forum.adalo.com/u/LiFox)\ **Post date:** [October 19, 2020, 3:54pm UTC](https://forum.adalo.com/t/csv-import-help/1791/18 "2020-10-19T15:54:55Z")
Hi Colin, thank you very much! It worked perfectly with google sheets. ---
**Author:** ![hannahandio](https://avatars.discourse-cdn.com/v4/letter/h/f17d59/32.png) [@hannahandio](https://forum.adalo.com/u/hannahandio)\ **Post date:** [October 28, 2020, 4:51am UTC](https://forum.adalo.com/t/csv-import-help/1791/19 "2020-10-28T04:51:25Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/8be082b918d6236bc5ecbc0c22ac6aa0b639b1d5.png) i have similar problems in the output… why is it like this? ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [October 28, 2020, 10:20am UTC](https://forum.adalo.com/t/csv-import-help/1791/20 "2020-10-28T10:20:14Z")
Can you give some details please. I have no idea what I’m looking at without any context. [Next page](https://forum.adalo.com/t/csv-import-help/1791.md?page=2)