Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi @Marc-André Bouchard You might want to try a free another Stiltsoft app: Live Tables from CSV & JSON for Confluence. This app allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data updated. By the…

Hello @Kh_Safal, thanks for letting me know. Apologies for the oversight - I’ll be more careful going forward.

@David Romero, You might want to try a free alternative, another Stiltsoft app: Live Tables from CSV & JSON for Confluence. This app allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data updated. By the…

Hello @Prudhvi Raju Kanithi, You might want to try a free alternative, another Stiltsoft app: Live Tables from CSV & JSON for Confluence. This app allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data…

Hello @GK In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the main app due to…

Hello @Green, Desmond, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the…

Hello @Pham Ngoc Tuong, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the…

Hello @Ethan Collins, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the main…

@Clarie Dubois, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the main app…

Hi @anuprita_moharil, You might want to try this free app to import CSV data into Confluence: Live Tables from CSV & JSON for Confluence. It allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data updated.

Hello, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the main app due to…

Hello @Jim Stewart, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out of the main…

Hello @Kranthi Kumar, Nadigoti, In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: CSV/JSON import via URL will be moved out…

Hi @kuwashima masato_桑島政人_ If you’re looking for a free alternative to import CSV data into Confluence, you might want to try another Stiltsoft app: Live Tables from CSV & JSON for Confluence. It helps avoid manual copying and keeps your data dynamic. This app allows you to import CSV, TSV, or JSON not only directly from…

Hi @Biju.Shankar, You need to convert values to percentages to display them on the Y axis with the help of Table Transformer via SQL query like this: SELECT T1.'column1', FORMATNUMBER(T1.'Feb'*100/(SELECT SUM(T1.'Feb') from T1)) + "%" AS 'Feb', FORMATNUMBER(T1.'Mar'*100/(SELECT SUM(T1.'Mar') from T1)) + "%" AS 'Mar',…

Hi @MudCo, You are our old customer, and we discussed plenty of questions regarding our macros on Data Center. For example, you may check these posts: https://community.atlassian.com/forums/Confluence-questions/Conditional-formatting-for-the-row-based-on-a-qualifying-value/qaq-p/2863950…

Hi @boellner boellner, Please check a workaround that may work for you in this thread.

Hi Matthias, The issue comes from Jira Issue Epic Link/Epic name as source data. Here's how columns look like without Table Transformer: There are issues with the Epic Name field encoding of special characters in Jira Issue macro; here are Atlassian tickets you can vote for: *…

Hi @mibo, Thanks for the answer! Confluence Cloud performance can sometimes vary depending on a number of factors. If you're experiencing slowness when loading a page, here are a few things to check: Are there other macros on the page besides our app? Some macros can be heavy and may impact loading speed. How large or…

Hello, I tried to reproduce the case and it works as expected. You probably need to update the app to it latest version 13.0.1.

Hello @Michael Verdun Heath, @mibo, I am Katerina from the Table Filter, Charts & Spreadsheets for Confluence team. We're sorry to hear you've been having trouble with the app. We totally understand how frustrating it can be when things don't work as expected. @mibo thanks for your patience! Is there anything in particular…

The date format you specify in the macro browser settings should be the same as in your source table (Jira macro). This setting is to read dates properly for further transformations. You need to use the following date format in Settings M/dd/yy HH:mm and this line in the SQL query FORMATDATE(T1.'Updated',"M dd, yy") where…

Hi @Russell R Rutledge, If you need to create big tables in Confluence, we can suggest looking into 3rd party apps with spreadsheets. For example, our company develops the Table Filter, Charts & Spreadsheets for Confluence app that includes the Table Spreadsheet macro. The macro provides all the basic Excel-like features…

Hi guys, Please let me mention the app that we develop regarding the case – Table Filter, Charts & Spreadsheets. You’ll be able to compare dates and set the corresponding cell background working with native Confluence tables (please check the Table Transformer macro) and using Excel-like spreadsheets (the Table Spreadsheet…

Hi guys, The Table Filter, Charts & Spreadsheets app (that is our add-on) has been already mentioned in this thread regarding native Confluence tables: the Table Transformer macro allows you to set colorful statuses based on different conditions. But if you prefer an Excel-like functionality, you may also use the Table…

Hi @Janice I see that you could add our custom tags to the community system, thanks a lot! We use them on an everyday basis. But I have one more request today, last week we officially renamed our app from "Table Filter and Charts for Confluence" to "Table Filter, Charts & Spreadsheets for Confluence", so it would be…

Hi @René Herrmann, We can suggest trying our Table Filter and Charts for Confluence app. Its Table Filter macro recognizes emoticons, so you’ll be able to filter your table by them.

What concerns your question about the Table Excerpt Include macro, you may just use page labels and collect your Table Excerpts using a specific label. Any page that doesn’t have this label won’t be searched for an excerpt. Or you may choose to show page titles as meta data and later filter out unwanted pages by their…

Hi @Candice, Yes, you use the “Filter whole table” option correctly. The option to use AND/OR operators is active for other filter types, for example, a dropdown. As you need to find several “parts” of text and then hide the corresponding rows, you may use the Table Transformer macro: SELECT * FROM T* WHERE 'Project' NOT…

Hi @Craig_Harley, Please check the following example with the Table Transformer and Chart from Table macros: SELECT "Yes" AS 'Field', SUM(IF(T1.'Field A' = "Yes", 1, 0)) AS 'Field A', SUM(IF(T1.'Field B' = "Yes", 1, 0)) AS 'Field B' FROM T1 And here are the settings of the Chart from Table macro – don’t forget to set the…