The tables from Wikipedia will usually copy and paste into LibreOffice Calc. Just make sure you select the full table and nothing else. It takes forever to paste if there are lots of images in the table though.
Firefox
/c/firefox
A place to discuss the news and latest developments on the open-source browser Firefox.
Rules
1. Adhere to the instance rules
2. Be kind to one another
3. Communicate in a civil manner
Reporting
If you would like to bring an issue to the moderators attention, please use the "Create Report" feature on the offending comment or post and it will be reviewed as time allows.
Don't know how techy you are, but I've had some luck with using pandas for stuff like this, though I don't know how good it works on wikipedia.
https://pandas.pydata.org/docs/reference/api/pandas.read_html.html
You can either do the filtering directly on the resulting pandas datframes or export it to whatever format you like including excel or csv
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_csv.html
There are some addons for Firefox that can extract tables and other things. Search “tables” in the addon store and see what’s there.
I tried the ones I found but they choke on these complicated tables