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
A place to discuss the news and latest developments on the open-source browser Firefox
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