Help & Support
Send Feedback
WikiTableWorks
Converts spreadsheet selection into a stylized wiki table for Wikipedia's MediaWiki open source software.
wikitableworks.com
8 users
Works with
Install
Overview
== NEW IN THIS VERSION!! ==
Bug fixes.

Thank you for reporting bugs.
https://pvtuhs.com/bugs

== QUICK GUIDE to HYPERLINK ==

Suppose A1 is a valid URL path:
=HYPERLINK("https://example.com/", "Foo")
=HYPERLINK("https://example.com/" & A1, "Meh")
=HYPERLINK("https://example.com/" & foo!A1, "Bah")
=HYPERLINK("https://example.com/" & foo!A1, """Free""")
=HYPERLINK("https://example.com/" & foo!A1, """"""Free"""""")
=HYPERLINK("https://example.com/" & foo!A1, """""""""Free""""""""")

== QUICK GUIDE to sortable wiki tables ==

Sortable wiki tables are supported with or without frozen rows.
* If there is more than one frozen row, the last frozen row is the header (sort) row.
* If there are no frozen rows, the first row automatically becomes the header row.

Now, you have are four menu options:
* Convert range to wiki table.
* Convert range to plain wiki table.
* Convert range to sortable wiki table.
* Convert range to plain sortable wiki table.

== KNOWN ISSUES ==
Background colors on sortable wiki tables make the arrows disappear.
* MORE INFO: https://meta.wikimedia.org/wiki/Help_talk:Sorting#Changes_-_linking_headers

G Suite Marketplace listings are not updating.
Thank you for your patience.

== MORE IN PREVIOUS VERSIONS ==

* Fixed hidden row/column offset issue.
* Added plain tables, where "plain" means that font and background styles are ignored
* Added support for table headers using frozen rows
* Added sortable wiki tables
* Added support for merged ranges.
* Improved performance for big wiki table conversions.
* Added support for hidden gridlines based on spreadsheet settings.
* Added support for horizontal text alignments (left, center, right).
* Added support for vertical text alignments (top, middle, bottom).
* Added support for font sizes.
* Added support for row heights and column widths.
* Added support for font colors and background colors.
* Added support for merged ranges (rowspans and colspans in the table).
* Added support for bold, italic, underline and strikethrough.
* Added support for skipping hidden columns and rows.
* Improved export filename to use local spreadsheet timezone
* Added listing to G Suite Markdetplace.

== MAKING WIKI TABLES IN GOOGLE SHEETS ==

Now creating a wiki table is simple and easy. Select a spreadsheet range, and convert the selection to a wiki table that can be copied and pasted into Wikipedia's MediaWiki software. MediaWiki 1.31.x LTS is currently supported.

Save your wiki table snippet to Google Drive.

#wikitable
Reviews
May 21, 2018
None of the formatting was copied to the table making the result not useful for me. Formatting in my case included casting numbers as percentages and color coding some cells. The numbers were put in the result as fractions and the plugin applies its own color coding.
Submit reply
Cancel
September 23, 2015
It's easy to use, and it works. The table header was a little too simple for me, though, because I wanted a grid, but I was able to cut and paste a useful header from a sample table. Thanks for this product.
Submit reply
Cancel
1-2 of 2
Additional information
Search
Clear search
Close search
Google apps
Main menu