Make smart wiki tables.

WikiTableWeaver for Google Sheets.

This is experimental software in BT Labs.

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.

NOTE: In addition to using Markdown files for project documentation and issue tracking, GitHub has a collaborative wiki feature.

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.

Availability

WikiTableWeaver is only available for closed beta testers.

Installation

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

Features

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.

    1. For a table with multiple frozen rows, the last frozen row, the last row is the header row used for sorting

    2. For a table with unfrozen rows, the first row is the header row used for sorting.

  • Added Support for the HYPERLINK function link labels

    1. =HYPERLINK("https://example.com", "Foo")

    2. =HYPERLINK("https://example.com" & A1, "Foo")

    3. =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.

WikiTableWeaver Help

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:

  • Wikipedia

  • MediaWiki LTS

  • 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.

Does WikiTableWeaver work in Google Sheets on iPadOS?

Yes.

In general, Google Sheets add-ons and all their features are available in Safari for iPadOS. However, the Google Sheets (native) offline app for iPadOS must be first uninstalled.

When the Google Sheets app is installed, it handles all the Google Sheets spreadsheet documents automatically. To prevent this default handler behavior, the app must be uninstalled.

Removal of the Google Sheets offline app allows Google Drive spreadsheet documents to be opened within the full-featured version of Google Sheets, using the Safari web browser for iPadOS.

All WikiTableWeaver features work in Safari for iPadOS.

How do I install WikiTableWeaver for Google Sheets?

The closed beta is not available at this time.

I want to show the spreadsheet data without the gridlines. How do I hide gridlines on the wiki table?

You can simply hide the spreadsheet gridlines. WikiTableWeaver will detect this setting and export a wiki table with no gridlines.

Does WikiTableWeaver support images?

Not yet.

Does WikiTableWeaver support font colors and sizes?

Yes.

How do I export a sortable wiki table?

Optionally, you can freeze rows prior to export. In this example, we will freeze two rows. The last frozen row will contain the column headers used for sorting.

Then, try using “Convert range to sortable wiki table” in the WikiTableWeaver menu. This conversion creates a sortable wiki table.

Does WikiTableWeaver support column widths and row heights?

Yes.

Does WikiTableWeaver skip the rows hidden by filter conditions?

Yes.

Does WikiTableWeaver support individual cell borders?

Not yet.

Why is the default alignment in the spreadsheet not working properly in WikiTableWeaver?

Default alignment depends on the spreadsheet properties and wiki locales. To override default alignments, you need to explicitly choose alignments in Google Sheets.

I don't need a fancy-schmancy wiki table. I just need something with plain text. How do I get a plain wiki table?

Try using "Convert to plain wiki table" in the WikiTableWeaver menu. This conversion creates a simple wiki table, but ignores the background colors, font colors and font sizes.

I just need my wiki table to be sortable without all the extra formatting magic. How do I get a plain sortable wiki table?

Try using "Convert range to plain sortable wiki table" in the WikiTableWeaver menu. This conversion creates a sortable wiki tabl, but ignores the background color, font colors and font sizes.

The sorting arrows on the table headers disappear when a background color is assigned. How do you make them re-appear?

This vanishing sorting arrows icon is known issue in MediaWiki software. The issue occurs whenever the "background" color style attribute is added to a table cell within the header rows. As a workaround, the exporter of sortable wiki tables in WikiTableWeaver simply ignores the background color in table headers (which may be first row or frozen rows of a range).

Can I use wiki tables on GitHub wikis?

Yes, but GitHub has limited support for the wiki table features on its wikis. For example, grid size and color formatting is restricted to the GitHub-specified style sheets.

Does WikiTableWeaver skip the rows hidden by filter conditions?

Yes. WikiTableWeaver skips rows and columns hidden by users or filters.

Additional Notes

Wiki table syntax is used in MediaWiki-powered platforms. Currently, MediaWiki 1.31 LTS is supported.

Google Sheets, Google Chrome Web Store, and G Suite Marketplace belong to Google. All other products and trade names belong to their respective owners. Except for MediaWiki with multiple licenses for multiple parts.

Live long and prosper.