Automatically import Excel rows to individual Confluence pages

[Raphael Lamas]

Hi, 

I have an Excel spreadsheet with 4 columns (Code, Description, Theme, Status) and over 300 rows.  I would like to import the data stored in this spreadsheet into my team's confluence space creating a new Confluence page for each Excel row. The name of the page can be the unique code stored in the first column.  

I also created a page template with page property (and page property report) but I'm not sure if it can be used as part of this process. 

Can this be done without an add-on or maybe with Zapier?

Thank you

[Shawn Doyle - ReleaseTEAM · Accepted solution]

Best bet is to write a script using the REST API to parse your spreadsheet and create a new page based on each row.

Here are the API docs for server/Data Center

https://developer.atlassian.com/server/confluence/confluence-rest-api-examples/

[Raphael Lamas]

Thanks, I will check if a developer can help me with this task. 

[samanta_aragao · Accepted solution]

Hello,

In a native way, you can import content using a word document or only embed a excel file inside a page on Confluence.

You could consider use an app, but if you use Jira with confluence I would suggest create pages using an automation inside Jira, with following:

• In Jira, create an automation where when you create an issue it creates a page for that issue and using smartvalues ​​you can enter what information you would like to include in the name of the page. (https://support.atlassian.com/cloud-automation/docs/smart-values-in-jira-automation/)
• In automation you choose which space should be used to create these pages and also which is the parent page.

• After that, import issues through Excel, where each line in the table is an issue.
  So when creating issues, Jira will also create a page for each issue.
• After that, you can delete the issues if you want, because the pages are already created.

I hope it can help you!

Regards!

[Raphael Lamas]

Thanks, that seems an interesting option as we do use Jira and it doesn't require coding.