Spreadsheets to Mediawiki

Convert Spreadsheets to Mediawiki Tables

2015.05.19

I use wikis quite often for the documentation of different projects. They are quite useful, simple and powerful, but in some specific cases Mediawiki syntax is just horrendous. One of such cases are tables. Therefore I been using Libreoffice to create the sheets/tables and then convert them to Mediawiki syntax using Pandoc.

The main trick is to export the sheet to an HTML file. Then you simply have to use Pandoc to convert the HTML table to Mediawiki, with the command

 pandoc -f html -t mediawiki sheet.html

The result will be a Mediawiki table:

{|
|id
|model
|user
|location
|notes
|-
|1
|Mac Pro 2.26
|All students
|Study
|archive machine
|-
|2
|Mac Pro A1481
|All students
|}