# Upload excel file to the app and show the data to glide app

**URL:** <https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718>\
**Category:** Ask for Help\
**Created:** [January 26, 2022, 1:04pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718 "2022-01-26T13:04:24Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\
**Post date:** [January 26, 2022, 1:04pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/1 "2022-01-26T13:04:24Z")

</div>

I want users to upload a google sheet file having their performance data of the employee or company, and i want to display the performance data through analytics or charts. How can i do that?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 26, 2022, 4:54pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/2 "2022-01-26T16:54:15Z")

</div>

Hey there! I’m planning on making a tutorial for this shortly…you’ll need an integromat or zapier account to make it happen though.

---

<div class="post-metadata">

**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\
**Post date:** [January 26, 2022, 5:02pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/3 "2022-01-26T17:02:33Z")

</div>

If possible could you make this tutorial early, we are upgrading our app and we want our clients to use this feature, it would be great if you make a video as early as possible.

Thanks.

---

<div class="post-metadata">

**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\
**Post date:** [January 26, 2022, 5:19pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/4 "2022-01-26T17:19:54Z")

</div>

Clarify one thing i now know sending of data using integromat. suppose now i am using integromat to send data to google analytics, then how can i receive the data and show the analytics in glide app.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 26, 2022, 5:23pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/5 "2022-01-26T17:23:39Z")

</div>

You’d probably need to use the Google Analytics spreadsheet addon

As for an early video, I don’t have my recording equipment until Monday at the earliest (I’m at home quarantining). If you want to hire me for priority support, you can purchase an hour of time here: [Calendly - Robert Petitto](https://calendly.com/robert-petitto/60min)

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 8:02am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/6 "2023-08-07T08:02:46Z")

</div>

yoou have update for this matter?

---

<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:** [August 8, 2023, 12:13am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/7 "2023-08-08T00:13:25Z")

</div>

So ultimately what exactly is your flow? Do you mean uploading a Google Sheet file through your Glide app, and the data will be imported to show some charts?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 8, 2023, 1:10am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/8 "2023-08-08T01:10:31Z")

</div>

Upload excel file \> paste to the current google sheet based on the column name

But, i think i found something similar topic written by you @ThinhDinh , but no idea yet

> [@GLIDE WEB, Import Excels into google sheet, it´s possible?](https://community.glideapps.com/t/glide-web-import-excels-into-google-sheet-it-s-possible/34370/2):
>
> 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.

---

<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:** [August 8, 2023, 1:16am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/9 "2023-08-08T01:16:07Z")

</div>

Yes, that should be the way to do it. As long as you keep the file input format consistent.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 8, 2023, 3:38am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/10 "2023-08-08T03:38:44Z")

</div>

The script now not run on the Google Sheets part.  
Do you have any idea why?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efa579faa3c99d52caa02c0ac1d440742beb0fd6.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1d266b78e415b805f8c6956a133d5e5bfb3b9f58.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5a0a15d3f554c4bf8d8e89e9054e5e7593e09be.png)

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 9, 2023, 8:24am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/11 "2023-08-09T08:24:08Z")

</div>

For those who are wondering,

These are the flow if you have xlsx format.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/303b4b5d3c8bd5bcc02b3bf39e87fc3870dc93cd.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:** [August 9, 2023, 11:56pm UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/12 "2023-08-09T23:56:55Z")

</div>

Why do you need to clear values from the range though? Is it specific to your use case?

The rest looks ok to me.

> [@biha](#):
>
> The script now not run on the Google Sheets part.  
> Do you have any idea why?

Was this solved? I think you were using “Update a row” instead of “Add a row”, and since you did not have any row identifiers, it failed.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [August 10, 2023, 11:56am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/13 "2023-08-10T11:56:52Z")

</div>

Any tips to covert all the tabs of an xlsx? I’ve only been able to convert the first tab of an xlsx document with this method… what might I be missing?

---

<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:** [August 11, 2023, 12:34am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/14 "2023-08-11T00:34:27Z")

</div>

If you know in advance what your tab names are, maybe you can upload it as a Google Sheet, then iterate through the tabs to process. I’m not entirely sure it would work, but I think it’s worth trying.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 11, 2023, 2:31am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/15 "2023-08-11T02:31:03Z")

</div>

I’m not sure but update a row not works for me. Then i try this kind of workflow. Now can.

---

<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:** [August 11, 2023, 2:48am UTC](https://community.glideapps.com/t/upload-excel-file-to-the-app-and-show-the-data-to-glide-app/37718/16 "2023-08-11T02:48:10Z")

</div>

I mean that is the wrong module to use. You have to know which row to update, and from your earlier screenshot, you seemed to not have the info for that.
