Make smart wiki tables.
WikiTableWeaver for Google Sheets.
WikiTableWeaver is a Google Sheets editor add-on that converts spreadsheets into stylized wiki tables. Saves to Google Drive.
NOTE: WikiTableWorks is now WikiTableWeaver.
WikiTableWeaver is a simple wiki table generator for Google Sheets. It uses the Google Sheets user interface as a wiki table designer. The generated wiki table uses WikiSyntax, which is used by popular platforms, such as Wikipedia, MediaWiki, and GitHub.
You can create simple wiki tables or sortable wiki tables.
Sortable wiki tables allow row sorting using column headers. The newest version now supports MediaWiki 1.31.x LTS, Wikimedia, FANDOM, and (of course) Wikipedia.
WikiTableWeaver is the best way to export wiki tables from Google Sheets to MediaWiki-powered web sites, such as Wikipedia.
Merge rows and columns to create powerful layouts. Building complex tables with rowspans and colspans can be expensive for projects, even for expert wiki authors.
Using WikiTableWorks for Google Sheets, you can build the precise layout that you imagine without the time consumed with trial and error.
Use the Google Sheets user interface to change colors and sizes. Developing a simple add-on that uses your prior knowledge, which includes past spreadsheet experience, to build wiki tables is much more cost-effective than reinventing the wheel — or in this case, the interface.
Using Google Sheets to design wiki tables is a natural fit for users who are already comfortable using online spreadsheets to collaborate.
For example, you can customize the fonts, columns, and rows in Google spreadsheets to create stylized wiki tables.
Export your wiki tables to other collaborative environments. It is easy to copy and paste the WikiSyntax into MediaWiki or Wikipedia. You can also save wiki documents to Google Drive.
WikiTableWeaver is only available for closed beta testers.
No installation methods available at this time.
Explanation of Permissions
PERMISSION: See, edit, create, and delete all of your Google Drive files
Required to create files and folders in Google Drive
PERMISSION: View and manage spreadsheets that this application has been installed in
Required to read the spreadsheet values and properties
PERMISSION: Display and run third-party web content in prompts and sidebars inside Google applications
Required to generate the Markdown export sidebar
The following is a list of WikiTableWeaver features:
Exports simple wiki tables from Google Sheets.
Exports sortable wiki tables with column headers.
Supports frozen rows for sortable wiki tables.
For a table with multiple frozen rows, the last frozen row, the last row is the header row used for sorting
For a table with unfrozen rows, the first row is the header row used for sorting.
Added Support for the HYPERLINK function link labels
=HYPERLINK("https://example.com" & A1, "Foo")
=HYPERLINK("https://example.com" & foo!A1, "Foo")
Supports wiki tables with merged cells as spreadsheet ranges, providing automatic processing of complex layouts that require colspans and rowspans.
Supports wiki font colors and sizes.
Supports wiki bold font styles.
Supports wiki italic font styles.
Supports wiki strikethrough font line styles.
Supports wiki table row heights.
supports wiki table column widths.
Supports wiki table cell background colors.
Supports wiki table cell left alignments.
Supports wiki table cell center alignments.
Supports wiki table cell right alignments.
Supports wiki table cell top vertical alignments.
Supports wiki table cell middle vertical alignments.
Supports wiki table cell bottom vertical alignments.
Skips hidden rows and columns.
Supports hidden gridlines.
Exports as WikiSyntax wiki table for copy and paste of wiki table into MediaWiki or Wikipedia.
Exports as WikiSyntax wiki table with limited feature support in GitHub wikis.
Saves wiki table to Google Drive as wiki document.
Uses the spreadsheet timezone for filename generation.
(EXPERIMENTAL 🔬) Stores wiki documents in WikiTableWeaver folder on Google Drive.
Which WikiSyntax editors are supported by WikiTableWeaver?
Right now, support has been limited to a few WikiSyntax editors and platforms.
The following platforms are fully-supported:
Wikimedia / Wikimania
FANDOM / Wikia
The following platforms are partly-supported:
MediaWiki (non-LTS or beta versions)
GitHub.com (does not implement all WikiSyntax)
NOTE: Subject to change without prior notice.