This is my first created topic here, so apologies if it is not well formulated!
I am wondering if there is a tool to simply extract data tables from Wikipedia articles (or other wiki projects) to other formats such as CSV.
Thanks!
This is my first created topic here, so apologies if it is not well formulated!
I am wondering if there is a tool to simply extract data tables from Wikipedia articles (or other wiki projects) to other formats such as CSV.
Thanks!
By "data tables" do you mean normal tables?
Maybe try Wiki Table to CSV online converter.
Thanks @AhmadF.Cheema for your comment!
Yeah, this is exactly the tool I use now but I was wondering if there is some tool integrated in the wiki or if there is a plan to integrate it.
A right click on a wiki table giving export options would be a great integration.
Cheers!
I guess you can install some jQuery plugin for that, like https://www.jqueryscript.net/table/jQuery-Plugin-To-Export-Table-Data-To-CSV-File-table2csv.html
Hello. I've tried using the wikitable2csv.ggor.de software but I found a problem. The wikitable uses commas in its cells "for example, one cell is "sculptor, scientist") and the software adds commas as the separators between cells. So this means I can't open the CSV file on R or Excel properly, because there are more columns than column names. Is there any way to change the cell separator in the wikitalbe2csv software? Thanks!