# Excel spreadsheet upload for merchants

**URL:** <https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [December 20, 2020, 11:52pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210 "2020-12-20T23:52:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![adalouser500](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adalouser500/32/5363_2.png) [@adalouser500](https://forum.adalo.com/u/adalouser500)\
**Post date:** [December 20, 2020, 11:52pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/1 "2020-12-20T23:52:09Z")

</div>

I want merchants to be able to upload a list of items using an excel spreadsheet so they don’t have to add items/services individually. Is this possible?

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [December 21, 2020, 2:15pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/2 "2020-12-21T14:15:49Z")

</div>

This is not currently possible natively in Adalo but I’m certain you could find an external service that you could feed the file through and then the collections API to create those records in Adalo.

---

<div class="post-metadata">

**Author:** ![adalouser500](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adalouser500/32/5363_2.png) [@adalouser500](https://forum.adalo.com/u/adalouser500)\
**Post date:** [December 21, 2020, 3:59pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/3 "2020-12-21T15:59:40Z")

</div>

Do you think Zapier would be able help?

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.adalo.com/u/NigelG)\
**Post date:** [December 21, 2020, 6:17pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/4 "2020-12-21T18:17:16Z")

</div>

Email them to Parabola. Give each user a code or something to put in the subject. Read that in from Adalo (or airtable etc) to find what the merchant is.

Then use the Adalo API to add the records.

---

<div class="post-metadata">

**Author:** ![adalouser500](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adalouser500/32/5363_2.png) [@adalouser500](https://forum.adalo.com/u/adalouser500)\
**Post date:** [December 21, 2020, 7:14pm UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/5 "2020-12-21T19:14:22Z")

</div>

I’m sorry I don’t completely understand, what do you mean "read that in from "

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.adalo.com/u/NigelG)\
**Post date:** [December 22, 2020, 7:44am UTC](https://forum.adalo.com/t/excel-spreadsheet-upload-for-merchants/7210/6 "2020-12-22T07:44:06Z")

</div>

Parabola has the ability to do API calls to Adalo.

So as long as you have a column in the csv that you can use to look up the merchant record in Adalo then you should be able to take each row on the input, look up the id of the record and insert the row and update the merchant table as well.

That would be the way to associate the items with the merchant that has sent the csv.

Not super easy. And you might burn through some credits, but that is one solution.