Unanswered

Export Excel from Microsoft Data-verse (not CSV format!!!)

(0) Share

Report

Posted on by Community Power Pla...

I want to export data from Data-verse , but it seems like I can only export csv format, but I want a "xlsx" format file. What can I do?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @Anonymous

As per Oot-Of-the-Box Behaviour it will only download xlsx format only, could you please tel me how you are doing the same.

Note:

For Importing/Creating new record in Dataverse we need to use csv format

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

By default in the Maker Portal if you go to your Table and Data and click "Export Data"

you are right this will export a CSV file for the Accounts table.

If you create a Model App and include your tables in this app then whenever you go into a view you will have in the navigation the ability to export the data in Excel (xlsx) format. See example from grid:

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi @Anonymous ,

In Case If you don't want to create Model Driven App, Please follow below steps to export your data in excel format -

Login to make.powerapps.com -> Select Environment-> Click Gear setting then Advanced settings

Select Advanced find ->Choose your table -> Add required fields ->Click on Results -> Export

Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!

Was this reply helpful? Yes No
antonio_piernav 125 on at

Like (0)

Report

Hello, you can export the data to a csv but with rows and columns.
Create a flow with a csv table and in the first column use the expression "concat" for all the items separated by ';'
Excel when opening the csv orders it as if it were xlsx

Was this reply helpful? Yes No