Populate Confluence page/form with imported csv data

[Chris Garrison]

I have a monthly status report page in confluence. Users from many division have to manually type in dozens of values from a spreadsheet into the Confluence page each month. Is there a way to import data (from a .csv or .xls) and auto-populate fields on a page.

Example Confluence Page:

Monthly Net Revenue: $field1

Monthly Expenses: $field2

Monthly Profit: $field3

Example .csv

field1, field 2, field 3

$200, $150, $50

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Chris Garrison are you on Cloud or DataCenter? Do you have apps like ScriptRunner installed on your instance?

[Chris Garrison]

Cloud. We do not have script runner, but I am familiar with that product from another cloud installation. Could script runner be leveraged to accomplish this task?

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Chris Garrison , I was just thinking that you could attach CSV file to attachment and use the script to read it and use it to build a content of the page. But I do not think you can do it on Cloud.

I just found following app, maybe it could help you?

https://docs.stiltsoft.com/tfac/cloud/how-to-use-table-from-csv-macro-42246005.html?utm_vendorID=1216111&utm_campaign=table-filter-traffic-sources&utm_medium=answer&utm_source=atl_community

[Stiltsoft support]

Hi @Chris Garrison ,

Indeed as @Martin Bayer _MoroSystems_ s_r_o__ has kindly mentioned, our Table Filter, Charts & Spreadsheets for Confluence app can be used as workaround for your case.

You'll be able to use our Table from CSV macro and import your data in csv format or connect your Google Sheet to Confluence (the data will be live in this case). Furthermore, you data can be filtered, aggregated, and visualized.

Or you may use the Table Spreadsheet macro and work with Excel-like functionality (cell formulas, pivot tables, conditional formatting, etc.) right in Confluence (the macro supports editing from view&edit mode as well as collaborative editing).

If you are not familiar with the app, please book a slot for a live call with our team.