# Export repeating group data to excel

**URL:** <https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659>\
**Category:** Need help\
**Created:** [June 14, 2016, 2:49pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659 "2016-06-14T14:49:47Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryanck](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@ryanck](https://forum.bubble.io/u/ryanck)\
**Post date:** [June 14, 2016, 2:49pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/1 "2016-06-14T14:49:48Z")

</div>

Hello,

I´ve been looking in the forum something about this threat but I could not find anything.

So anyone know how to export a repeating group data to an .xls or .xlsx file that will be download after pressing the “export to xls” button?

Thanks a lot.

---

<div class="post-metadata">

**Author:** ![ChrisL](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/chrisl/32/271_2.png) [@ChrisL](https://forum.bubble.io/u/ChrisL)\
**Post date:** [June 14, 2016, 7:14pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/2 "2016-06-14T19:14:55Z")

</div>

There’s a workflow item called “Download data as CSV”. You can feed it a repeating group in the data source.

![](https://us1.discourse-cdn.com/bubble/original/2X/2/2222f0567c16413d17892f163453c3e073f8fe41.png)

---

<div class="post-metadata">

**Author:** ![ryanck](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@ryanck](https://forum.bubble.io/u/ryanck)\
**Post date:** [June 14, 2016, 7:44pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/3 "2016-06-14T19:44:45Z")

</div>

Thanks @ChrisL

I did not know that. But I was thinking about download a file that is a .xls so the users don’t have to do anything but open the file in excel with no formatting problems.

---

<div class="post-metadata">

**Author:** ![ChrisL](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/chrisl/32/271_2.png) [@ChrisL](https://forum.bubble.io/u/ChrisL)\
**Post date:** [June 14, 2016, 10:16pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/4 "2016-06-14T22:16:12Z")

</div>

Even though it’s downloading as a CSV it should open in Excel. That’s what it’s doing for me right now.

---

<div class="post-metadata">

**Author:** ![ryanck](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@ryanck](https://forum.bubble.io/u/ryanck)\
**Post date:** [June 15, 2016, 8:29am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/5 "2016-06-15T08:29:14Z")

</div>

Thanks @ChrisL

I´ll try and see if it fits our needs.

---

<div class="post-metadata">

**Author:** ![andrewgassen](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/andrewgassen/32/44248_2.png) [@andrewgassen](https://forum.bubble.io/u/andrewgassen)\
**Post date:** [July 19, 2016, 11:35pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/6 "2016-07-19T23:35:21Z")

</div>

Is there any way to get the actual input values instead of the unique identifiers? For example, I want “Benjamin Button” in the CSV instead of “282384792392084759828376”

Is this possible?

---

<div class="post-metadata">

**Author:** ![ryanck](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@ryanck](https://forum.bubble.io/u/ryanck)\
**Post date:** [July 20, 2016, 7:03am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/7 "2016-07-20T07:03:16Z")

</div>

Hi,

I´m interested in this also since I cannot export what I actually see in the repeating group.

Thanks a lot.

---

<div class="post-metadata">

**Author:** ![andrewgassen](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/andrewgassen/32/44248_2.png) [@andrewgassen](https://forum.bubble.io/u/andrewgassen)\
**Post date:** [July 24, 2016, 4:00am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/8 "2016-07-24T04:00:38Z")

</div>

I wanted to answer my own stupid question here. The reason I wasn’t getting human readable entries is because the cell was referring to an object in the DB, not a field of the object. Moral of the story: the computer does exactly what you tell it to, so give it good instructions. If you ask for a Student, you’ll get the reference to the Student. If I wanted the Student First Name, I should’ve asked for it explicitly!

---

<div class="post-metadata">

**Author:** ![chris7](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@chris7](https://forum.bubble.io/u/chris7)\
**Post date:** [June 7, 2017, 5:21am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/9 "2017-06-07T05:21:54Z")

</div>

Is there a way to merge different tables? What I mean is each invoice I have has a unique company and every company has a unique Tax reference, but the tax info is in a separate table. I want to export my invoices with their company name and their “looked-up” tax identifier…is there a way to do this? Thanks!

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [June 7, 2017, 7:09am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/10 "2017-06-07T07:09:28Z")

</div>

Yes, create a temporary table with all the values you need, and export that. That way you avoid all the bubble UID fields as well (apart from one).

Have a button that appears when the temporary table (for a particular user) is complete (I think I did it on count, but will check).

---

<div class="post-metadata">

**Author:** ![chris7](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@chris7](https://forum.bubble.io/u/chris7)\
**Post date:** [June 7, 2017, 8:10am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/11 "2017-06-07T08:10:57Z")

</div>

Thanks for you time Nigel. When you say temporary table do you mean a whole new database set of fields which gets rewritten everytime as needed? Is there a way to create a display only table, as in a repeated group with nested tables and export that?

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [June 7, 2017, 10:09am UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/12 "2017-06-07T10:09:42Z")

</div>

A new table. It gets a bit tricky to create the RG otherwise.

You could then base the RG on the new data structure of course.

---

<div class="post-metadata">

**Author:** ![sandeep.bondre](https://avatars.discourse-cdn.com/v4/letter/s/13edae/32.png) [@sandeep.bondre](https://forum.bubble.io/u/sandeep.bondre)\
**Post date:** [July 5, 2021, 4:46pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/13 "2021-07-05T16:46:53Z")

</div>

Is the reverse possible i.e. I want to Import data into a TYPE ( Table ) based on an Excel or CSV

---

<div class="post-metadata">

**Author:** ![nick.lockley](https://avatars.discourse-cdn.com/v4/letter/n/e99b99/32.png) [@nick.lockley](https://forum.bubble.io/u/nick.lockley)\
**Post date:** [May 8, 2024, 4:08pm UTC](https://forum.bubble.io/t/export-repeating-group-data-to-excel/3659/14 "2024-05-08T16:08:43Z")

</div>

Just adding my own question here guys… When exporting from a repeating group, I notice we select the repeating groups list of items.

Does this mean the list within the database that its pulling from or is it specifically the list of items i am displaying in the table subject to constraints, any api calls etc?

I ask as we pull alot of data from API endpoints and would really like to just export it to csv lol.

Thanks,  
Nick
