Note to self - LibreOffice Calc web tables

There are always the small, one-time tasks where I need to figure out an easier, quicker way to accomplish something. This is one of those.

The problem is simple enough: copy a table from Wikipedia. Grab it once, and move on.

Copy and paste is usually my friend for browser-to-spreadsheet transfer, but some Wikipedia tables are massive and not to mention, very awkward. I have previously ended up with a messy file which needs a ton of cleaning before it is useable.

LibreOffice Calc is just the ticket. From the menu, go to:

• Sheet > External Links
• Add the URL and press Enter
• Keep default values on Import Options
• Select HTML_tables > OK

Done. I have a nice, clean table. In a spreadsheet.

If the page contains multiple tables, Calc allows choosing which one to import.

I tend to forget this feature exists, so now it is noted for next time. Via ecodiv.earth.*

* In LibreOffice Calc v24, the old Link to external data is now named External Links