PageToSheet: Download Tables from Any Webpage to Excel(pagetosheet.com)

PageToSheet: Download Tables from Any Webpage to Excel

https://www.pagetosheet.com

20 comments

donatj4 anni fa

Firefox 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.

wrp4 anni fa

Where are these tricks documented?

sixhobbits4 anni fa

`=IMPORTHTML` in Google Sheets works great and surprisingly many people who could benefit from it a lot don't know it exists.

lelandfe4 anni fa

`IMPORTHTML("http://example.com", "table", 4)` – 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.

Simon_O_Rourke4 anni fa

Duly noted - thanks!

nojito4 anni fa

Excel does this natively.

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-...

ygra4 anni fa

Doesn'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.

arkitaip4 anni fa

Its buggy and unpredictable. I feel the crawling engine hasnt been kept up to date.

vba6164 anni fa

In 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.

JoBrad4 anni fa

And it’s *so* slow, on every PC I’ve used. It’s usually easier to just copy and paste the table, if you can.

vba6164 anni fa

The point of automation is making sure you get things correct.

avinashsonee4 anni fa

I use copytables https://merribithouse.net/copytables/. It has number of options for selection and also keyboard shortcuts.

TAForObvReasons4 anni fa

There's a neat Chrome extension to do this https://www.georgemike.com/tablecapture/

LeoPanthera4 anni fa

If 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.

kalleboo4 anni fa

The page is 502ing so maybe I'm missing something but I just copy and paste from my browser into Numbers. Is this for automation?

adammarples4 anni fa

I use pd.from_html

pen2l4 anni fa

Woah, 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

emeril4 anni fa

I guess still better off pdf'ing it and running it through tabula (free) or maybe abbyy (paid)

7e22v837278gb1p4 anni fa

looks like they need to beef up their web hosting solution.

sofixa4 anni fa

All 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).