I'm aware that I can't mention specific software brands or platforms, or even discuss software bugs, so I'm going to try to frame my question from a methodological perspective.
I used a well-known platform, owned by a popular search engine, to conduct online user interviews. Everything ran smoothly until I needed to transcribe the data to generate insights and identify problems.
Indeed, when I exported the file to a spreadsheet, I ended up with a document that was tough to read. I also attempted a PDF export, but it proved a real headache to copy-paste text into a table and redo everything. I also considered importing the data to another well-known note-taking, database, and Kanban board application, but that solution failed.
So, I'm interested in understanding how you go about planning your interviews in advance to avoid such inconveniences that are currently causing me significant time losses. Do you compose your questions in a text file or a spreadsheet before? And once you've received responses, how do you retrieve the user data? What best practices have you established to prevent such situations that I'm currently facing?
To put it simply, how do you anticipate and prevent potential technical issues or recurrent bugs when working across various platforms and software?
Thank you for your assistance.