Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
Customers of Azure Test plans need to export data for a wide variety of use-cases. Currently, users can only export Test plan data (with all nested suites and latest test outcome) into PDF and HTML formats. We’re improving our export capability by adding support for Microsoft Excel supported format (i.e. XLSX) as well.
This will allow customers to easily edit/modify the exported data as per their needs.
If you found this informative, please consider accepting an answer as a token of appreciation. and if you have further questions, I will request you to please post your queries in dedicated forums as in below links:
https://developercommunity.visualstudio.com/spaces/21/index.html
https://developercommunity.visualstudio.com/t/get-unique-id-from-devops-organization/756710