# Import Data From Excel & Sheets into Glide Table

**URL:** <https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184>\
**Category:** Feature Requests\
**Created:** [December 22, 2020, 5:25pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184 "2020-12-22T17:25:20Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 22, 2020, 5:25pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/1 "2020-12-22T17:25:20Z")

</div>

I would love to be able to take a workbook and import the data directly into Glide Sheets. Is there a roadmap for this feature. It makes sense with us migrating to Glide Sheets.

---

<div class="post-metadata">

**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\
**Post date:** [December 22, 2020, 6:47pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/2 "2020-12-22T18:47:55Z")

</div>

Copy and paste?

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 22, 2020, 6:50pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/3 "2020-12-22T18:50:00Z")

</div>

Doesn’t work, it pastes it all into 1 cell.I’m not refering to the Google Sheets, but the Glide Sheets we create in Glide, it just pastes to whatever cell is selected.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 1, 2021, 3:23pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/4 "2021-02-01T15:23:43Z")

</div>

@david is there currently a “in the works” for importing data directly into glide sheets? It would make us want to use the glide sheets a lot more if we could import directly to them, otherwise some of our spreadsheets just have too much data to retype.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 2:56pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/5 "2021-02-04T14:56:14Z")

</div>

He only replies to the ones he wants to…☹

---

<div class="post-metadata">

**Author:** ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)\
**Post date:** [February 7, 2021, 2:34am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/6 "2021-02-07T02:34:52Z")

</div>

I’d love to have this as well

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [February 7, 2021, 4:57am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/7 "2021-02-07T04:57:38Z")

</div>

It’s in the original post? 👇

> [@new Glide Tables](https://community.glideapps.com/t/glide-tables/15597):
>
> Introducing Glide Tables Glide Tables are like Google Sheets, but they live in Glide and have some exciting properties: They can hold much more data than a Google Sheet. You can share tables between apps. They don’t cause sheet edits/sheet reloads. There are also some limitations They are not yet as easy to edit as your Google Sheet. You cannot import or export data in bulk, but we are working on that. Only basic columns and user-specific columns are shared when you share a Glide …

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44c180954dc91d081be430196c35dfc6427cd252.jpeg)

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 8, 2021, 7:09pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/8 "2021-02-08T19:09:51Z")

</div>

I know they ar working on it. My questions is when 🙂

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [February 8, 2021, 8:05pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/9 "2021-02-08T20:05:01Z")

</div>

Ahh I see, 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 8, 2021, 8:05pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/10 "2021-02-08T20:05:45Z")

</div>

If they want us to rely more on Glide Sheets this should be in the fore front of development. They are quicker and cleaner. I would like this greatly.

---

<div class="post-metadata">

**Author:** ![Fabio\_Leanzi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio_leanzi/32/6838_2.png) [@Fabio\_Leanzi](https://community.glideapps.com/u/Fabio_Leanzi)\
**Post date:** [February 12, 2021, 6:44pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/11 "2021-02-12T18:44:11Z")

</div>

I’m developing an e-commerce with over 30,000 products, and the only way I can bypass the 25,000 row limit is through glide tables.  
Being able to Bulk Copy / Paste a whole table would be really handy.

---

<div class="post-metadata">

**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\
**Post date:** [February 12, 2021, 6:46pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/12 "2021-02-12T18:46:09Z")

</div>

YES! Let’s upvote this!!!

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [February 12, 2021, 6:49pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/13 "2021-02-12T18:49:36Z")

</div>

Probably most needed feature👍

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 12, 2021, 7:58pm UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/14 "2021-02-12T19:58:55Z")

</div>

With this it would be nice to have something similar to what Power Bi has where the data is linked like it is now but we pull it into glide sheets as a bulk. So if the excel sheet or google sheet has values that get updated it will still reflect in the glide tables. That would probably be the easiest way to implement it for Glide since they already have the majority of that system worked out.

---

<div class="post-metadata">

**Author:** ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)\
**Post date:** [February 14, 2021, 5:59am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/15 "2021-02-14T05:59:22Z")

</div>

This should also include a “convert to glide sheets” option. Copying or importing into a glide sheet is nice, but I’d rather not have to rebuild all of the relations and lookups, which are pretty complex in my app

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [February 18, 2021, 8:25am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/16 "2021-02-18T08:25:23Z")

</div>

I can’t find any decent info on glide tables. Has the tables project been abandoned?  
There has to be a way to either copy and paste data onto the table or ideally link the table to a google sheet so that it updates automatically. Unlimited data would open up a whole new world of possibilities for Glide Apps. Please give us more feedback for glide tables.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 18, 2021, 8:52am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/17 "2021-02-18T08:52:34Z")

</div>

> [@ToOFa\_Apps](#):
>
> I can’t find any decent info on glide tables. Has the tables project been abandoned?

Far from it, as I understand.

> [@ToOFa\_Apps](#):
>
> There has to be a way to either copy and paste data onto the table or ideally link the table to a google sheet so that it updates automatically.

Unfortunately, not yet. But there have been hints of it being in the pipeline.

There is a whole thread on Glide Tables - I assume you’ve seen that?

> [@new Glide Tables](https://community.glideapps.com/t/glide-tables/15597):
>
> Introducing Glide Tables Glide Tables are like Google Sheets, but they live in Glide and have some exciting properties: They can hold much more data than a Google Sheet. You can share tables between apps. They don’t cause sheet edits/sheet reloads. There are also some limitations They are not yet as easy to edit as your Google Sheet. You cannot import or export data in bulk, but we are working on that. Only basic columns and user-specific columns are shared when you share a Glide …

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [February 18, 2021, 9:15am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/18 "2021-02-18T09:15:14Z")

</div>

Hello,  
Failing to have an import function.

I used a fairly simple method to import 3 tables of around 400 rows each, it’s not ideal, but it’s better than editing everything.

For simplicity

- You have a Sheet Source table and a Glide Destination table.

1. Add a column to your Sheet Source “Copy ok” of type boolean.

2. Create a List style tab with the Sheet Source as the source.  
And as filter “Copy ok is not 1”

3. Then use a custom action

- ADD row, with as Sheet “Glide Destination” then match the fields.
- Set Columns “This Item” row : “Copy Ok” column with the value 1.

So when you click on an item in the list you copy.

The “Copy Ok” column is just to avoid duplicates.

Okay, you probably need a spare mouse with a large number of copies !!

But, I agree with you, this is an important function to transfer from Google Sheet to Glide Sheet.

(sorry for my english)

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [February 18, 2021, 9:38am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/19 "2021-02-18T09:38:48Z")

</div>

Haven’t yet. Thanks, I’ll check it out.👌👍

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [February 18, 2021, 9:44am UTC](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/20 "2021-02-18T09:44:49Z")

</div>

Wow, sounds complex, but if it works would still be worth learning your method. Are you able to show a video of how you do that? Would be much appreciated.🙏

[Next page](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184.md?page=2)
