4 ms·
PageToSheet: Download Tables from Any Webpage to Excel
- 7e22v837278gb1p 4y agolooks like they need to beef up their web hosting solution.
- sofixa 4y agoAll sites of this type ( static product description/docs/landing/e.g.) should be thrown on top of Netlify/Vercel/Firebase Hosting/similar. Zero maintenance, free (well unless your traffic is huge, but then with the maintenance overhead it still usually comes out cheaper), zero security risk ( for you).
- emeril 4y agoI guess still better off pdf'ing it and running it through tabula (free) or maybe abbyy (paid)
- adammarples 4y agoI use pd.from_html
- pen2l 4y agoWoah, didn't know about this, thanks for bringing it to my attention! Found this article shows its use: https://pbpython.com/pandas-html-table.html https://pbpython.com/pandas-html-table.html
- sixhobbits 4y ago`=IMPORTHTML` in Google Sheets works great and surprisingly many people who could benefit from it a lot don't know it exists.
- Simon_O_Rourke 4y agoDuly noted - thanks!
- lelandfe 4y ago`IMPORTHTML("http://example.com http://example.com", "table", 4)` – https://support.google.com/docs/answer/3093339?hl=en https://support.google.com/docs/answer/3093339?hl=en Pretty snazzy. They also have `IMPORTFEED` for RSS which is giving me all sorts of neat ideas.
- donatj 4y agoFirefox has a really nice built in table selection mode I use to copy into spreadsheets all the time. Just hold down CMD (Mac) or Control (Others) and you can select table rows and columns.
- wrp 4y agoWhere are these tricks documented?
- TAForObvReasons 4y agoThere's a neat Chrome extension to do this https://www.georgemike.com/tablecapture/ https://www.georgemike.com/tablecapture/
- kalleboo 4y agoThe page is 502ing so maybe I'm missing something but I just copy and paste from my browser into Numbers. Is this for automation?
- ygra 4y agoDoesn't Excel already do this on its own? It's based on an IE control in my ancient version (2010), but perhaps it has been updated by now.
- arkitaip 4y agoIts buggy and unpredictable. I feel the crawling engine hasnt been kept up to date.
- JoBrad 4y agoAnd it’s *so* slow, on every PC I’ve used. It’s usually easier to just copy and paste the table, if you can.
- vba616 4y agoThe point of automation is making sure you get things correct.
- vba616 4y agoIn newer versions of Excel, Power Query makes it easy, if you can be bothered to learn Power Query...it doesn't matter if the tables are a bit off, because it is a complete functional-esque language. Like SQL plus easy higher order functions. PDFs can often be extracted too in a similar way. I feel exhausted every time I see another thread on HN about what to do when you will not learn Excel & Office because it's for PHBs and secretaries.
- avinashsonee 4y agoI use copytables https://merribithouse.net/copytables/ https://merribithouse.net/copytables/. It has number of options for selection and also keyboard shortcuts.
- nojito 4y agoExcel does this natively. https://docs.microsoft.com/en-us/power-query/connectors/web/web https://docs.microsoft.com/en-us/power-query/connectors/web/... Or you can just use smart copy in edge. https://techcrunch.com/2020/03/30/microsoft-edge-is-getting-smart-copy-and-paste-a-password-monitor-and-vertical-tabs/ https://techcrunch.com/2020/03/30/microsoft-edge-is-getting-...
- LeoPanthera 4y agoIf you are a Mac user using Numbers and Safari, you can do this by literally selecting the table, and copy pasting it right into Numbers. I do this quite often.