Add-ons
Check out the store for many more
Add-on

WikiTableWorks


(6)
951 users

Overview

Export formatted wiki tables using Google Sheets as a table generator. Copy and paste into Wikipedia or MediaWiki.
== 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

Details

Version: 21
Updated: January 14, 2019
Language: English