# How can I import a table from the web? **URL:** \ **Category:** Ask for Help\ **Created:** [February 12, 2023, 8:26am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823 "2023-02-12T08:26:18Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 12, 2023, 8:26am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/1 "2023-02-12T08:26:18Z")
I manage a sports app on behalf of a local football team. At present, you can only view the latest league table by clicking on a link in the App, which opens the website in your browser: [https://matchcenter.ifv.ch/default.aspx?lng=1&cxxlnus=1&v=393&t=67764&a=trr&](https://matchcenter.ifv.ch/default.aspx?lng=1&cxxlnus=1&v=393&t=67764&a=trr&) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/edfece35e5e3e5a2e878dde71e5b1e5f7c3b4824.png) Is there a way to scrape the URL and reconstruct a couple of columns from the table in my app WITHOUT using google or Excel sheets? I prefer my app to only use Glide Tables. Thanks in advance for any tips 🙂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 12, 2023, 8:34am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/2 "2023-02-12T08:34:36Z")
I dare say that it could be done using JavaScript, but have you considered using a webview? (if your plan supports it). ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 12, 2023, 8:44am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/3 "2023-02-12T08:44:38Z")
Thanks Darren. I understand the web view is only for Pro apps and mine is a Starter. I don’t fancy getting into Java and had hoped the column type whereby you can simulate an Excel function would work. What do you think? If not, I guess I will have to attach an Excel Sheet… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 12, 2023, 8:54am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/4 "2023-02-12T08:54:33Z")
I’ve never used that Excel plugin, so I’m not sure if that would work. I know that Google Sheets has an `IMPORTHTML` function, which would probably get the job done. I imagine that Excel most likely has a similar function. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [September 18, 2023, 4:55pm UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/5 "2023-09-18T16:55:55Z")
has this ever been done? ---
**Author:** ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)\ **Post date:** [September 18, 2023, 5:30pm UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/6 "2023-09-18T17:30:08Z")
Some javascript and AI 🧂 Change the instruction to play with getting particular data or asking open ended questions perhaps if you don’t want to do more html parsing. ![20230918_102935](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cca53be51f1dfd609e2f17577ea5974aaafbc32e.png) ![20230918_102921](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a7804498e4924a8d55fa26de7e88381108b0ae4a.png) ![20230918_102912](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d0ea18ebacab4b5dc033d8a03e75d4048de4ddb.png) ![20230918_102855](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/748b6db545371c5c61f13c4bff58855a19258168.png) ```auto var parser = new DOMParser(); var doc = parser.parseFromString(p1, "text/html"); var tables = doc.getElementsByTagName('table'); return tables[0].innerHTML ``` ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 19, 2023, 6:29am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/7 "2023-09-19T06:29:14Z")
AI is useless when it comes to handling tables of data. I wouldn’t trust it. Plus why would I pay to use AI when most spreadsheets offer the web import for free? ---
**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:** [September 20, 2023, 1:03am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/8 "2023-09-20T01:03:43Z")
May I know why you say so? I think Jeremy’s case offers a solid point on how to use it. If you don’t pay for Business/Enterprise to use Call API, I think you can still get to somewhere really good with: - A Javascript column to fetch the endpoint. - An OpenAI column with a solid prompt to force the output into a table/markdown format. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 20, 2023, 6:11am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/9 "2023-09-20T06:11:22Z")
I will take closer look and see if I can import a table to see how difficult it is… worth a plunge and will likely learn something along the way. Thanks. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [September 20, 2023, 6:32am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/10 "2023-09-20T06:32:34Z")
I’m building a few football apps as well, how are you dealing with styling the apps? Like a table of league standings, it can be nicely designed using html in a rich text component. But that would make the table static and users cannot click to view more info on rows. ---
**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:** [September 20, 2023, 8:14am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/11 "2023-09-20T08:14:23Z")
Please let us know if we can help somewhere. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 20, 2023, 10:11am UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/12 "2023-09-20T10:11:43Z")
Here’s a demo of my Football app 😀 [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd711eab8defa73d8dad8ce8f121263488c93847.jpeg "20 September 2023") ](https://www.youtube.com/watch?v=9YWPMlaZr_s) ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [September 20, 2023, 1:52pm UTC](https://community.glideapps.com/t/how-can-i-import-a-table-from-the-web/57823/13 "2023-09-20T13:52:12Z")
very nice!! some similar concepts with my team app to be honest. I’ve only started working on that app this week… i’l share here later today.