Wiki tables + w00t!
Wiki Table Weaver for Google Sheets.
Wiki Table Weaver is a Google Sheets editor add-on that converts spreadsheets into stylized wiki tables. Saves to Google Drive.
NOTE: WikiTableWorks is now Wiki Table Weaver.
Wiki Table Weaver 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.
Wiki Table Weaver 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 Wiki Table Weaver 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.
Explanation of Permissions
PERMISSION: See, edit, create, and delete all of your Google Drive files
PERMISSION: See, edit, create, and delete your spreadsheets in Google Drive
Required to create files and/or 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 Wiki Table Weaver features:
Exports simple wiki tables from Google Sheets.
Exports sortable wiki tables with column headers.
Exports wiki tables with 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
Exports wiki tables with merged cells as spreadsheet ranges, providing automatic processing of complex layouts that require colspans and rowspans.
Also now supports merged cells with hidden rows and columns.
Exports wiki tables with font colors and sizes.
Exports wiki tables with bold font styles .
Exports wiki tables with italic font styles.
Exports wiki tables with strikethrough font styles.
Exports wiki tables with table row heights.
Exports wiki tables with table column widths.
Exports wiki tables with cell background colors.
Exports wiki tables with cell left alignments.
Exports wiki tables with cell center alignments.
Exports wiki tables with cell right alignments.
Exports wiki tables with cell top vertical alignments.
Exports wiki tables with cell middle vertical alignments.
Exports wiki tables with cell bottom vertical alignments.
Skips hidden rows and columns.
Multiline support. (*NEW in Version 33!*)
Default right-to-left support. (*NEW in Version 33!*)
Monospace font support. (*NEW in Version 33!*)
Adds generic "monospace" font name after selected Google Sheets font.
Supports hidden gridlines.
If the gridlines are hidden, the wiki tables are borderless.
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.
(EXPERIMENTAL 🔬) Exports simple wiki tables from Google Sheets, without any font colors, sizes, styles -- or background colors.
(EXPERIMENTAL 🔬) Support for =HYPERLINK formulas with addresses:
=HYPERLINK("https://example.com" & A1, "Hello")
=HYPERLINK("https://example.com" & foo!A1, "Hello")
(EXPERIMENTAL 🔬) Export all selected ranges at the same time as multiple wiki tables.
(EXPERIMENTAL 🔬) Export pre-defined named ranges from a sheet at the same time as multiple wiki tables.
(EXPERIMENTAL 🔬) Stores wiki documents in "Wiki Table Weaver" folder on Google Drive. - [ coming soon ]
Wiki Table Weaver Help
Which WikiSyntax editors are supported by Wiki Table Weaver?
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.