WikiTableWorks exports wiki tables from Google spreadsheets.
WikiTableWorks is a Google Sheets add-on that converts spreadsheet ranges into stylized wiki tables.
You can create simple wiki tables or sortable wiki tables.
Sortable wiki tables allow row sorting using column headers.
The newest version only supports MediaWiki 1.31.x LTS, Wikimedia, and Wikipedia.
WikiTableWorks 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.
FeaturesThe following is a list of WikiTableWorks features:
- Exports simple wiki tables from Google Sheets
- Exports sortable wiki tables with column headers
- Supports frozen rows for sortable wiki tables.
- For multiple frozen rows, the last frozen row is the header row used for sorting.
- For unfrozen frozen rows, the first row is the header row used for sorting.
- Added support for the HYPERLINK function link and labels.
=HYPERLINK("https://example.com" & A1, "Foo")
=HYPERLINK("https://example.com" & foo!A1, "Foo")
- Supports merged cells as spreadsheet ranges, providing automatic processing of complex layouts that require colspans and rowspans.
- Supports font colors and sizes.
- Supports bold and italic fonts styles.
- Supports strikethrough font line styles.
- Supports row and column size colors.
- Supports horizontal alignments: left, center, and right.
- Supports vertical alignments: top, middle and bottom.
- Supports hidden spreadsheet gridlines.
- Skips hidden rows and columns.
- Supports spreadsheet cell background colors.
- Exports for copy and paste into MediaWiki or Wikipedia.
- Exports with limited feature support in GitHub wikis.
- Saves to Google Drive as a wiki document.
- Uses the spreadsheet timezone for filename generation.