Topic on Project:Support desk

Export wiki tables into CSV or other formats

5
Abdeaitali (talkcontribs)

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!

AhmadF.Cheema (talkcontribs)
Abdeaitali (talkcontribs)

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!

Ciencia Al Poder (talkcontribs)
Mateussf (talkcontribs)

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!

Reply to "Export wiki tables into CSV or other formats"