Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Populate Confluence page/form with imported csv data

Chris Garrison March 1, 2024

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

1 answer

2 votes
Martin Bayer _MoroSystems_ s_r_o__
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 1, 2024

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

Chris Garrison March 1, 2024

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__
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 1, 2024

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

Like Stiltsoft support likes this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 2, 2024

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.

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events