# Add Row | Copy / Paste
**URL:** https://community.glideapps.com/t/add-row-copy-paste/70562
**Category:** Ask for Help
**Created:** [February 6, 2024, 5:39pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562 "2024-02-06T17:39:38Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 5:39pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/1 "2024-02-06T17:39:38Z")
I have a google sheet with some static data that I want to import into a Glide table.
But I need to add an individual row in the Glide table before I can paste in the rows. How can I add in say 100 rows without having to click “Add Row” 100x.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 6, 2024, 5:42pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/2 "2024-02-06T17:42:33Z")
You should be able to use the Import function. Right click on the Table name in the Data Editor.
---
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 5:46pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/3 "2024-02-06T17:46:01Z")
Will this replace the entire data? Or add additional rows? I cant afford to lose the existing table data…
Will test it now anyhow. Thanks
---
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 5:49pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/4 "2024-02-06T17:49:52Z")
Actually , I already have imported this way.
So I have “Bills” Glide Table & “Import Bills” google sheet imported into glide (looks like glide table as its not source or sync)
I just want to copy 100 rows from 3 columns from my imported google sheet into my bills glide table. Without having to add 100 rows manually in the glide table.
100 is fine but if I wanted to add 1000 , not so much.
I dont want to use the imported table either because I have many columns already set up in my original table.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 6, 2024, 5:50pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/5 "2024-02-06T17:50:11Z")
It will add new rows as necessary.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 6, 2024, 5:51pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/6 "2024-02-06T17:51:59Z")
> [@Emmett\_M](#):
>
> I just want to copy 100 rows from 3 columns from my imported google sheet into my bills glide table. Without having to add 100 rows manually in the glide table.
You can add rows quickly by clicking into a non-computed column in the last row, and then hold your Enter key down.
---
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 5:53pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/7 "2024-02-06T17:53:50Z")
A little quicker than clicking yes , but then gets super laggy if im holding for 1000+ rows.
It would be so much easier to just enter “No. of Rows = 1000”
---
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 5:55pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/8 "2024-02-06T17:55:26Z")
Also , is there a max number of rows a glide table can have?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 6, 2024, 6:01pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/9 "2024-02-06T18:01:36Z")
Not that I’m aware of. I have some with over 100k rows. And Big Tables can have millions.
---
### Author:  [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)
#### Post date: [February 6, 2024, 6:33pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/10 "2024-02-06T18:33:08Z")
Cheers Darren
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 13, 2024, 6:33pm UTC](https://community.glideapps.com/t/add-row-copy-paste/70562/11 "2024-02-13T18:33:36Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.