I'm creating a VRTM and want to take my csv file and import it into Confluence. How do I do that?
What I found - seems to be the only reference outside a marketplace app.
https://support.atlassian.com/confluence-cloud/docs/import-data-into-your-database/
Hi Chris, to add to Matthew’s link, I just tried it with a small VRTM-style CSV and it works well:
All columns come in as text, so afterwards it’s worth changing columns like Status or Verification method to a Tag field. That makes filtering and grouping easier.
If you only need a static table on a page and not a database, copying the cells from Excel and pasting them into the page editor also works. CSV:
Import:
Hi @Chris Austin,
Just to quickly add to this — I think it really depends on what you want to achieve with the CSV/Excel file and how you'd like to display or manage that data in Confluence.
There are a few options:
Suggestion: Try out Rovo and/or MCP integrations for this 👈
One more option, and personally my favorite, is using Rovo or an AI tool connected to Confluence through MCP. You can provide the CSV/Excel file and ask the AI to transform it into a Confluence table, page, or even a database. With Rovo's Create with Rovo functionality, you can attach a file as context and generate Confluence content directly.
I've found this approach incredibly convenient, especially when the data needs some restructuring or formatting before being added to Confluence. It can save quite a bit of manual work! 🥳
Cheers, Tobi
Nice overview, @Tomislav Tobijas. On the copy-paste option: in my experience it works, but you then spend quite some time fixing the table afterwards (column widths, header row, sometimes number formats).
One more option that avoids that: import the CSV into a database, then paste the database link on a page and switch it to Embed. I tried it with a small VRTM. The table shows live on the page and you can filter it right there (e.g. Status is Passed). One thing to watch: “Save changes” in the filter updates the database view for everyone, so use “Add as new view” if you want a separate one.
I also tried your Rovo suggestion on the same data and it surprised me: it built the table with the header right and even turned Status into coloured labels. I only tested it with a few rows though, so I’m curious how it does with a full VRTM. Nice hint by the way.
One thing I'd consider with a VRTM is what happens after importing the CSV. Getting the data into Confluence is one part, but being able to filter requirements by verification status, group them by category, or quickly identify what's still pending can be just as important.
I'm part of the team behind Simple Tables for Confluence, and this is actually a good use case for it. You can import CSV or Excel files directly into a table and then apply filtering, grouping, calculated columns, and summaries without leaving Confluence.
That said, if you need to maintain and edit individual requirements collaboratively, Confluence Databases might be the better starting point.
Just curious: is your VRTM something you update regularly, or is it mainly a report you want to publish and analyze in Confluence?
Mia
I’m part of the Table Filter, Charts & Spreadsheets for Confluence app, and it’s a pretty popular one, so there’s a high chance you might have it on your instance.
If you have it, then using our Table Spreadsheet macro, you could import the CSV file right to a Confluence page and even work with it there.
How to check if you have Table Filter, Charts & Spreadsheets on your instance:
Please let me know if you have the app in your Confluence workspace so I can assist you further. :)
It looks like you're new here. Sign in or register to get started.