Importing large Excel docs into Jira for product requirements

[bcselewski]

We have a project we are working on, figured I'd reach out to the community.  We have a team that has a couple very large excel docs with multiple sheets.  Some contain data, some contain images. 

One sheet has almost 3000 rows and 4 sheets.  Does anyone have any experience doing something like this and if you did, do you have any tips we can give the team? 

Currently they are looking at a very manual approach and it's going to be an extensively long process.  

[Tomislav Tobijas]

Hi @bcselewski ,

So, you're trying to import this to Jira as work items (not Confluence)? I'm asking as this landed in Confluence Q&A forum group.

Now, to import files from Excel, you'd need to convert it to CSV, but CSV is text-only so images will not be converted or uploaded. 👀

Have you tried using Rovo? Like uploading a file to Rovo and seeing if it will be able to translate this to Jira? 🤔

Apart from that, I do see complex situations like this one actually requiring creating some kind of custom solution - e.g., a script that will go through the Excel file, and then create work items via REST API. ⚙️

Cheers,
Tobi