# Workaround for bulk importing data into Glide Tables (Python)

**URL:** https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660
**Category:** Ask for Help
**Created:** [March 2, 2021, 3:55pm UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660 "2021-03-02T15:55:52Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![research\_depict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/research_depict/32/21556_2.png) [@research\_depict](https://community.glideapps.com/u/research_depict)
#### Post date: [March 2, 2021, 3:55pm UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660/1 "2021-03-02T15:55:53Z")

</div>

Hi all,

Just in case this isn’t common, here’s a workaround I’m using to bulk import data into glide tables (need to use Python).

[https://pastebin.com/yHZ0RWVJ](https://pastebin.com/yHZ0RWVJ)

Run the above script in Python and move to an open window with a glide table showing and your cursor in the first column you want to enter data into

Once the script is done, data will be entered in automatically.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/662af4caf7619b942e831bc3042236020ed80b49.png)

You’ll need to extend this to work with the data you want to enter.

Cheers!

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 3, 2021, 11:19am UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660/2 "2021-03-03T11:19:40Z")

</div>

This is genius, thanks for sharing.

---

<div class="post-metadata">

### Author: ![ihackstuff](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ihackstuff/32/15168_2.png) [@ihackstuff](https://community.glideapps.com/u/ihackstuff)
#### Post date: [March 3, 2021, 7:27pm UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660/3 "2021-03-03T19:27:06Z")

</div>

Agreed! This is awesome! I’m definitely going to use this. I love this idea, and will use it in other web-based projects that lack certain automation! Thank you!

---

<div class="post-metadata">

### Author: ![ihackstuff](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ihackstuff/32/15168_2.png) [@ihackstuff](https://community.glideapps.com/u/ihackstuff)
#### Post date: [March 3, 2021, 7:42pm UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660/4 "2021-03-03T19:42:31Z")

</div>

Poking around with this. I’m on a Mac using Safari. I ran the script, single-click to select a cell in my Glide table and after 3 seconds I get the “Paste” mouse hover below:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/63e1a6c57ccb5dd06d085e09d0beec70ca8c8506.jpeg)

If I double-click the Glide table cell (now have the blinking cursor) I see it “pasting” five times, but it’s pasting nothing and not moving to the right (presumably because I’m locked in test edit mode in the cell).

Is this a bug?

---

<div class="post-metadata">

### Author: ![research\_depict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/research_depict/32/21556_2.png) [@research\_depict](https://community.glideapps.com/u/research_depict)
#### Post date: [March 4, 2021, 1:09am UTC](https://community.glideapps.com/t/workaround-for-bulk-importing-data-into-glide-tables-python/23660/5 "2021-03-04T01:09:58Z")

</div>

That’s interesting! I’m on Windows so I don’t think I can try this out but try a quick test:

If you press command+V once you’re on a cell (and able to move around freely across cells using just arrow keys), does it paste the contents of your clipboard into the cell?

I wonder if this might have to do with the fact that the script uses:

```
    keyboard.press(Key.ctrl.value)

```

But Mac’s use command not control, so if you substitute all mentions of “Key.ctrl.value” with “Key.cmd.value”, that might work?