Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

List Creation for Variable

First - I am new to Confluence and have spent most of the day try to solve this on my own so please forgive the newbie question.

We are looking to create a template which can be used over and over for various Client related details. I have created a variable field called "Client Name" and selected the "List" option. 

I have over 400 items I need to include in the list of options, and entering them manually, separated by commas and attempting to keep them in alpha-order seems like a massive waste of time. There has to be a better way. 

Since my list is in Excel, and could easily be imported into a table, I am thinking once done there has to be a way to use that table to populate the variable list (especially since we will add to the list as new clients come on board)?

Am I off the mark on this? I have to believe we are not the first people to try something like this, but since I cannot find anything anywhere perhaps I am wrong.

Has anyone out there done something like this or have any suggestions?

3 answers

0 votes

Hi @Jen Latkowski

At the moment, you don't have the native Confluence functionality for your use case. However, there are multiple third-party apps at the Atlassian Marketplace that could help you.

For example, our Handy Macros for ConfluenceI would allow you to create custom status sets with unlimited number of statuses to choose from. You'll need to create a set with options just once. after that, it can be reused over many Confluence pages.

Another benefit is that Handy Status can be changed in the page view mode without switching to the edit mode. 

0 votes
Jessica Atlassian Team Nov 26, 2021

Hi Jen,

Hope you are doing well!

At this moment, we don't have native functionality for creating a template that could help automatically add variable/list options.

Correct if I am wrong, but you are looking for having a way to import the information from your excel sheet and import the information there as a template, or data to be entered as variables, is that correct?

Currently, we don't have the functionality of importing doc, pdf, or excel files like templates, but depending on the use case, we can raise a new Feature Request for you.

However, since you have over 400 items to be entered on the list options, would it be a feasible solution if required for users to enter the information only?
If that works, you can use the variable text instead of list, so who is creating the page could enter the information there. :)

Hope that helps!

Kindest Regards,

0 votes

Hi @Jen Latkowski 

With our app Excellentable, you can import the excel file in confluence, edit it natively and publish the results as HTML display.

You can reach out to our support channel for the specific use case

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

283 views 2 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you