27

I really like comparison tables on wikipedia but find them hard to navigate.

For example: Comparison of web browsers > General Information

Say I want a web browser for Linux which has been recently updated. I can sort by the "Platform" column, or by "Latest release: Date" but not both.

Sometimes tables can be very wide and/or very tall. Once you get to scrolling it is impossible to see either the row or column headings. So then you can't tell where you even are in the table. Example: Table of AMD processors Also they can have complex structures with merged headings and content.

Ideally I would like to apply some basic spreadsheet-type operations like hiding rows/columns, filtering, sorting by multiple columns etc. Even if there was a way to easily get the table into an actual spreadsheet that would be helpful. I tried some extensions that export tables to other formats but nothing worked without a lot of cleanup.

Is there some kind of trick or tool or extension that makes these ginormous tables useful? I can't tell how people even add information to these things, they are so large.

top 13 comments
sorted by: hot top controversial new old
[-] lechatron@lemmy.today 22 points 11 months ago* (last edited 11 months ago)

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.

[-] linuxPIPEpower@discuss.tchncs.de 3 points 11 months ago

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.

[-] TheNumberOfGeese@lemmy.ml 2 points 11 months ago

Google sheet's =importhtml function might do a better job than copy paste. (maybe) https://support.google.com/docs/answer/3093339?hl=en-GB

[-] gnate@lemmy.world 3 points 11 months ago

Freezing top row would be my #1 pick, followed by the ability to use the full width of the browser window for the table (rather than forcing horizontal scroll at a fixed table width), and the ability to hide columns.

Ideally without using an external interface.... But I think the exporting to spreadsheet trick will absolutely be handy.

[-] linuxPIPEpower@discuss.tchncs.de 2 points 11 months ago

Freezing the top row (when wanted by the user) would be an actual legitimate use of that annoying thing where websites have their navigation bar persistently at the top of the window.

[-] PunnyName@lemmy.world 1 points 11 months ago* (last edited 11 months ago)

Multiple tabs, or multiple windows

[-] sxan@midwest.social 1 points 11 months ago

I can sort by the "Platform" column, or by "Latest release: Date" but not both.

My biggest usability pet peeve of Wikipedia. Othewise, I think they've done a fine job on site design.

[-] linuxPIPEpower@discuss.tchncs.de 1 points 11 months ago

It sucks because the info is all there! Someone has gone to the trouble to put it in and everything.

Like I said in the top post I honestly don't understand how these large tables even get updated... How do the authors know what they are even editing?? There has to be a trick.

[-] RickyRigatoni@lemmy.ml 1 points 11 months ago

I've seen websites where if you scroll down a table and cut off the heading, the heading detaches and follows your view so you can always see it. Why can't Wikipedia do that?

[-] linuxPIPEpower@discuss.tchncs.de 1 points 11 months ago

Could be using CSS position: fixed. But idk there could be other more sophisticated ways to accomplish the same thing.

In terms of why to not use it, I can think of reasons to avoid it by default. Like it could be very annoying on some devices in some situations. If the page authors made the table headings really long, it could obscure the content. I know I have been annoyed by this sort of thing when websites use position: fixed for their navigation or other elements. When I've snooped around the backend of wikipedia I see that they are contending with a wide variety of contributors and users and whatever they do needs to accommodate everyone.

What I find surprising is that there is (apparently) no 3rd party browser extension, userstyle or userscript that allows enabling this.

this post was submitted on 04 Dec 2023
27 points (86.5% liked)

Asklemmy

43750 readers
1264 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!

  1. Open-ended question
  2. 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.
  3. Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
  4. Not ad nauseam inducing: please make sure it is a question that would be new to most members
  5. An actual topic of discussion

Looking for support?

Looking for a community?

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago
MODERATORS