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
»
Tagged in:
Visitors: Loading...
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.