Display a table from csv file in Confluence

[Sue Hannan]

Looking for a macro in confluence that would allow the following

show a spreadsheet/table on the wiki page

content is pulled from a csv or excel file stored in onedrive

as the data file content is updated, so is the wiki

for ex, in center of wiki there is a table that is tied to the csv

user updates and saves some values, maybe add col's row's in the csv data file

user browsing the page either refreshes or as a new person joins the page after data file is saved, they now see the updated content

[Katerina Kovriga {Stiltsoft}]

Hi @Sue Hannan ,

We can suggest trying our Table Filter and Charts for Confluence app and its Table from CSV macro.

You'll be able to connect your CSV/TSV files as attachments and via urls (and Google Spreadsheets as well). All the updates made to the source file are immediately reflected on your Confluence page.

The recreated table can be further filtered, aggregated and visualized right in Confluence if required.

[deepika]

am getting error on using Table from CSV. 

can anyone help ??

[Ismael Jimoh]

I would recommend opening a totally different ticket here @deepika .

That way you get the correct support rather than adding to an existing ticket after years.

[Stiltsoft support]

Hi @deepika ,

The Atlassian Community is more oriented to sharing experience, it is not a support portal. Here we try to find related posts manually and some questions can be missed.

So, if you have any issues with the macros provided by the Table Filter, Charts & Spreadsheets for Confluence app, please refer to our support.

Regarding your question, please define your hosting (Cloud/Data Center) and the version of the app if you are on Data Center. Then attach your csv-file that causes the issue - we'll reproduce it and see what can be done here.

Please note that the support portal is confidential and you are able to share your data freely.

[Stiltsoft support]

And you may also try our Table Spreadsheet macro: import your existing .csv/.xlsx data and continue to work with it right in Confluence using all the Excel-like features (cell formulas, filtration, conditional formatting, pivot tables, etc.).

Please give it a try!

[Oki__PolarisOffice_]

@Sue Hannan 

Our app, Polaris spreadsheet allows you to embed an existing excel and CSV files for your project management in a confluence page and to directly edit it. Please check this. 

Atlassian Marketplace 

[Ismael Jimoh]

Hi @Sue Hannan 

I am unsure about CSV but with excel files, you should be able to use the Office Excel Macro to show the file’s content and it should appear as a table.

Give the same macro a shot with excel or derive an excel file from the CSV file to get this working.