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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can I bulk create pages using a template with variables that are filled in from data in excel?

I am attempting to make a dictionary of internal terms. I have designed a template for the dictionary and added variables to each of the sections that will need to be filled out. 

 

I have a spreadsheet that has data that contains the page name and data for the variables. Is there a way to do a bulk import (similar to JIRA) where I use the spreadsheet to fill in the variables I created in the template?

1 answer

I have this challenge too!

One thing I tried was to convert the spreadsheet into a table in MS Word, then highlight the first column and format the text as Heading 1 before trying to import it into Confluence.

This process created the new pages all right, and if I recall correctly the information in the other cells appeared as a table in the newly-created pages. Of course the import process did not include labels or formatting, so going back in and editing all the new pages was still needed.

As far as I know there is not a way to have Confluence automagically insert markup as part of the Word import process.

I am very interested in other solutions to this challenge!

We have a distinct format for our wiki too and if I am going to have to apply it to every page then it really does not save any time. I have looked at exporting XML and importing the XML just edited but I have not found a good way to edit the XML (there are too many references that I do not know what they track and how changing them would affect the import)

I don't know if your wiki format would lend itself to this idea, but one thing I tried was doing a mail merge in MS Word, piping data from Excel into an MS Word doc (one page per record). The Word doc could then be imported into Confluence. But the page layout/formatting might not translate as desired.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence Cloud

Please tell us how you use Confluence space settings

👋 Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with im...

126 views 5 6
Join discussion

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