# GLIDE WEB, Import Excels into google sheet, it´s possible?

**URL:** <https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370>\
**Category:** Ask for Help\
**Created:** [November 11, 2021, 3:17am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370 "2021-11-11T03:17:25Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![luciano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano/32/33418_2.png) [@luciano](https://community.glideapps.com/u/luciano)\
**Post date:** [November 11, 2021, 3:17am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/1 "2021-11-11T03:17:25Z")

</div>

Hi, I’ve been searching for a way where people/clients of my app can import excels because they need to add a lot of info from their computers and is not comfortable one by one…

I tried zapmax, but it didn’t work, tried integromat, but couldn’t find a way to upload the info…  
So in integromat I tried, download the Excel, transformed it to a csv, but it’s all in 1 “line”, and if I try to upload it in a Google sheet it doesn’t add the info the way I require it, and also I require adding it in an already created sheet, not in a new one.

Give access to my Google sheet is not an alternative

Anyone has some idea or a way where we can make this possible? This could be a great feature to delivery business, courier, events, other activities where you need to add a lot of stuff.

Thank you!!

---

<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:** [November 11, 2021, 12:35pm UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/2 "2021-11-11T12:35:10Z")

</div>

With a Google Sheet as a base, you can use a flow in Integromat like this.

- Let users upload the file in Glide.
- Use a webhook to pass that file’s URL to Integromat.
- Download that file via the HTTP module and convert it to a CSV.
- Add row by row to your destination Sheet.

It would look something like this.

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

---

<div class="post-metadata">

**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\
**Post date:** [November 11, 2021, 2:14pm UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/3 "2021-11-11T14:14:43Z")

</div>

Good timing! I was just trying to figure this out! Thanks ThinhDinh for posting this scenario!

---

<div class="post-metadata">

**Author:** ![luciano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano/32/33418_2.png) [@luciano](https://community.glideapps.com/u/luciano)\
**Post date:** [November 11, 2021, 8:31pm UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/4 "2021-11-11T20:31:04Z")

</div>

Hi!! Thank you for share that, I will try it!

---

<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:** [November 11, 2021, 11:38pm UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/5 "2021-11-11T23:38:44Z")

</div>

Please note that the scenario above was using a CSV file as input. If you can force your users to upload CSV then ok, else add a step to convert it to a CSV using something like CloudConvert.

---

<div class="post-metadata">

**Author:** ![Tuttografica](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tuttografica/32/16484_2.png) [@Tuttografica](https://community.glideapps.com/u/Tuttografica)\
**Post date:** [November 12, 2021, 1:20am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/6 "2021-11-12T01:20:13Z")

</div>

Hello, I have two applications in which a script does the following work.  
App 1: I care about everything that has a shared excel file in a specific folder on google drive.  
App 2: I receive an excel file every day as an attachment in a gmail email.  
That information that arrives I am adding it to a spreadsheet of google sheets which is where I gather the information.  
in my case I could not use integromat or similar, since I have many records per day.  
Note: I sent the scripts to a programmer, since he did not have enough knowledge to do it.  
Greetings

---

<div class="post-metadata">

**Author:** ![luciano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano/32/33418_2.png) [@luciano](https://community.glideapps.com/u/luciano)\
**Post date:** [November 12, 2021, 2:42am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/7 "2021-11-12T02:42:23Z")

</div>

I can do that (force them to use csv), the problem now is, webhooks are not working on beta of web page ☹

---

<div class="post-metadata">

**Author:** ![luciano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano/32/33418_2.png) [@luciano](https://community.glideapps.com/u/luciano)\
**Post date:** [November 12, 2021, 3:12am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/8 "2021-11-12T03:12:09Z")

</div>

How do you filter them? I’m a little confused about how you can filter csv data

as you can see, with an advance (which I IDK how to use it) I tried to give some kind of structure, but somehow I can get that structure even though I have everything separated by commas

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87d4db0a64e02d1e7d6f14b41df814a567c518a9.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca2a53e136e473fa1d5751e4fc160fcc2e05d171.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a5264f13f77af35e30b66731081cd843b8330f7.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/2548227371dd134bdc1a2923eaca4292d839cb67.png)

---

<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:** [November 12, 2021, 3:31am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/9 "2021-11-12T03:31:35Z")

</div>

If you have a CSV already, you just need the HTTP download, then parse CSV and add row (Google Sheet).

---

<div class="post-metadata">

**Author:** ![luciano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano/32/33418_2.png) [@luciano](https://community.glideapps.com/u/luciano)\
**Post date:** [November 12, 2021, 3:39am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/10 "2021-11-12T03:39:39Z")

</div>

HTTP module it downloads it as a .xlsx, that’s why I create a CSV from there, but after intregromat create that CSV, I get all the info in just 1 line of text, from there I need to give it a structure, which you said to create row by row, so I don’t know how do you filter them, and that’s where I’m stuck ☹

the goal it’s to put each line from the client’s excel to my Google sheet with the same structure

19 columns  
1-500 rows (that´s the info to extract)

---

<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:** [November 12, 2021, 9:37am UTC](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/11 "2021-11-12T09:37:15Z")

</div>

So you don’t have a CSV from the client, right? Add a ConvertCloud module to convert the .xlsx file to CSV first, then process like I said above.
