# Create New Glide Table by Importing from Google Sheet

**URL:** <https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156>\
**Category:** Ask for Help\
**Created:** [March 29, 2024, 10:17am UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156 "2024-03-29T10:17:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [March 29, 2024, 10:17am UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156/1 "2024-03-29T10:17:26Z")

</div>

Dear Community,

We are upgrading one of our app from Classic.

When trying to change one of the Google Sheet Tab into a Glide table, we are facing huge issues.

 ![a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3fe6f985cb0325ca3c9a0d603ea9baf05a6e339.jpeg)

One of the table PoolDB has 1600 over rows. We have copied this sheet to a stand alone Google Sheet with only 1 tab, and try to import to a Glide Table

 ![Import 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84efb2330dc4444767bed654d858c9d8aee3208f.jpeg)

The imported data has only less than 1/3 of the actual dat i.e 490 out of 1600 row.s

 ![Imported only one-third](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/655db75509ae95dc0ca395c093d29bd471a143b0.jpeg)

This is the actual rows number:

 ![Imported only one-third 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5d658d561d93f1e4d9dedb0c10bc157d12dd955.jpeg)

Kindly advise if there’s a better and more effective way to perform the data import seamlessly?

---

<div class="post-metadata">

**Author:** ![etienneduper](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/etienneduper/32/67963_2.png) [@etienneduper](https://community.glideapps.com/u/etienneduper)\
**Post date:** [March 29, 2024, 12:59pm UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156/2 "2024-03-29T12:59:38Z")

</div>

Try exporting your Google Sheet table in CSV and doing the import from the CSV options instead.

Let me know how this goes !

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [March 30, 2024, 7:28am UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156/3 "2024-03-30T07:28:21Z")

</div>

DId that as well. Couldn’t work. Same outcome.

---

<div class="post-metadata">

**Author:** ![etienneduper](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/etienneduper/32/67963_2.png) [@etienneduper](https://community.glideapps.com/u/etienneduper)\
**Post date:** [March 30, 2024, 12:16pm UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156/4 "2024-03-30T12:16:31Z")

</div>

Depending on how many columns you have, I’ve had a lot of success with copy/paste in Glide. Just make sure your column structure is the same.

That’s not the recommended way to go, but it gets the job done. I’m not sure how you are not getting 100% of your rows. I’ve never seen that.

---

<div class="post-metadata">

**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\
**Post date:** [June 12, 2024, 2:30pm UTC](https://community.glideapps.com/t/create-new-glide-table-by-importing-from-google-sheet/72156/5 "2024-06-12T14:30:58Z")

</div>

I’ve seen this multiple times and have an open support ticket about it. Copy/paste is an interesting alternative. I’ve seen so much flakiness around export import I’m willing to try anything!
