Wiki tables + w00t!

Wiki Table Weaver for Google Sheets.

Version 38.

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.

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

wiki table weaver uses google sheets for color design of wiki tables

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.

demonstration of merged columns and rows as they appear as a wiki table in media wiki

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.

pasta conference wiki table text created by wiki table weaver for google sheets

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.

pasta conference wiki table text in media wiki preview

Availability

The latest version is Version 38.

Wiki Table Weaver is currently available in the G Suite Marketplace in all regions.

Installation

Use G Suite Marketplace to install the MarkdownTableMaker editor add-on. The following video illustrates how:

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.

Features

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")

    • =HYPERLINK(A1, A2)

    • =HYPERLINK(foo!A1, A2)

  • (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:

  • 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 Wiki Table Weaver 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 Wiki Table Weaver features work in Safari for iPadOS.

How do I install Wiki Table Weaver 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. Wiki Table Weaver will detect this setting and export a wiki table with no gridlines.

Does Wiki Table Weaver support images?

Not yet.

Does Wiki Table Weaver support merged table cells?

Yes.

Does Wiki Table Weaver support font colors and sizes?

Yes.

How do I export a sortable wiki table?

When you export a sortable wiki table, the first row will always be the sortable header row.

Optionally, you can freeze more 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 Wiki Table Weaver menu. This conversion creates a sortable wiki table.


Does Wiki Table Weaver support column widths and row heights?

Yes.

Does Wiki Table Weaver skip the rows hidden by filter conditions?

Yes. Wiki Table Weaver skips rows and columns hidden by users or filters.

Does Wiki Table Weaver support individual table cell borders?

Not yet, but hiding gridlines can render you borderless tables for now.

Why is the default alignment in the spreadsheet not working properly in Wiki Table Weaver?

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 Wiki Table Weaver 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 Wiki Table Weaver menu. This conversion creates a sortable wiki table, 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 Wiki Table Weaver 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.

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.