Automatically import Excel rows to individual Confluence pages

Question

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

samanta.aragao · Accepted Answer

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!

Shawn Doyle - ReleaseTEAM · Accepted Answer

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/