this post was submitted on 04 Dec 2023
27 points (86.5% liked)
Asklemmy
43857 readers
1695 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy ๐
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- [email protected]: a community for finding communities
~Icon~ ~by~ ~@Double_[email protected]~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You can select the whole table and copy/paste it into a spreadsheet program. Then you have all the spreadsheet tools to use. I just tested in excel and Google sheets and both loaded the data correctly.
edit: Here is that spreadsheet in google sheets.
Thanks for taking the time! But it doesn't properly reproduce the content.
As an example, here is the very bottom left corner from the wikipedia:
there is a merge row with content "5 TSMC N5". Same height as merged row in next column, with content "Zen 4".
But in the google sheet:
those row containing "5 TSMC N5" have all be un-merged into 14 separate rows. However for some reason "Zen 4" has been properly copied?
I would need 2+ very large displays to compare the two documents side by side but from what i can see on my 1 small display there are many such inconsistencies. My experience is that cleaning up the data is impossible.
Google sheet's =importhtml function might do a better job than copy paste. (maybe) https://support.google.com/docs/answer/3093339?hl=en-GB