Automatically import Excel rows to individual Confluence pages

Raphael Lamas July 24, 2024

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

2 answers

2 accepted

1 vote
Answer accepted
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2024

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 July 25, 2024

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

1 vote
Answer accepted
samanta_aragao
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2024

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:

image.png

  • 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 July 25, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events