SQL-Powered Table Transformer

by George IvanovAtlassianPaid

Transform, analyze, and convert Confluence tables with SQL into tables, CSV, JSON, or Jira tables.

Facts verified marketplace.atlassian.comAd-free rankings
PRICINGPaid
DEPLOYMENTServer
CATEGORYData and analytics
UPDATED ON MARKETPLACE
SQL-Powered Table Transformer — screenshot from the Atlassian Marketplace listing

What it does

SQL-Powered Table Transformer transforms and analyzes Confluence tables with SQL. It can filter, sort, split, merge, rename or hide columns, replace cell patterns, calculate cell values, and compare tables. It creates tables from attached or remote CSV and JSON files, and can link tables from a remote database. Results can be returned as tables, CSV, Jira tables, lists, or JSON.

Key capabilities

from the Atlassian Marketplace listing

SQL table analysis

Runs SQL queries against one or more Confluence tables using the H2 SQL grammar.

Column transformation

Adds, hides, renames, filters, sorts, and transforms table columns.

Table comparison

Compares multiple tables and finds intersections between tables.

CSV and JSON import

Creates tables from attached or remote CSV and JSON files.

Multiple output formats

Converts results into tables, CSV, Jira tables, lists, or JSON.

Dynamic analytics

Adds analysis, highlighting, and calculated data to HTML tables.

Use cases

  • Compare versions of an attached or remote CSV or JSON file and return the differences as new tables or other supported formats.
  • Use data from the JIRA Issues/Filter macro as an input table for analysis.

In the catalog

192 plugins in Confluence · Data and analytics

Price distribution: 47 free, 81 freemium, 64 paid

Pricing & deployment

Platform
Atlassian
Product
Confluence
Deployment
Server
Pricing
Paid

Similar plugins in Confluence · Data and analytics

View all 192 →

What the vendor says

«SQL-Powered Table Transformer - a tool to transform/convert/analyze Confluence tables using SQL. Use full power of SQL No need to have or setup a DB (macro seamlessly uses own temp in-memory DB) Original tables are not changed in any way (all the results you get are generated dynamically) No limit for the number of …»

Official marketplace listing

Publisher
George Ivanov
Updated on marketplace
Facts verified