Is it possible to convert Excel spreadsheets into MediaWiki markup? I stumpled upon strange recommendations exporting to HTML and convert it into markup. Is there a solution, maybe exporting to XML first or directly converting it?
12 Answers
You could export your Excel document to CSV and import it into this web application:
https://www.tablesgenerator.com/mediawiki_tables
You can then edit the table and export it directly into MediaWiki format.
I use this macro available on the main Wikipedia site.
It convert the Excel tables to wiki formating. The output is pretty close to the original excel file. it does transfer font formating and cell colors. There is limitation on the borders but they come from mediaWiki system.
You can find the Code at : https://de.wikipedia.org/wiki/Wikipedia:Technik/Text/Basic/EXCEL-2003_Tabellenumwandlung_VBA
Here is an online web application, you can copy Excel cells to the clipboard, and import it into this site
You can then edit the table and export it directly into MediaWiki format.
It's 2021 now.
You can copy basic Excel spreadsheets directly into MediaWiki's Visual Editor.
The only thing that's missing in the copy/paste method is cell formatting.
Related