web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Download and upload Excel template gives error

(1) ShareShare
ReportReport
Posted on by 47

In my Dynamics 365 I need to migrate an Excel template from one environment to another. Unfortunately do not have the original Excel template. 

On DEV - Adv Settings - Template - Select Excel template - Maximize - Download . I downloaded the template and looks OK. However, after go to higher environment in Adv Settings - Template , it fails with the following error. How is it possible that an Excel template that works on one site, when trying to upload on another site it fails (without any change)

I tried upload file as is. then tested with "enable edit". then R.click on the file - Properties - Unblock

Nothing worked. the failure is the same. I really tested on multiple environements and same behaviour, so is no environment issue.  Am I doing something wrong.

Did anyone experienced a similar scenario on D365. 

I very much appreciate your help.

 

thank you,

,pastedimage1674871655495v1.png 

I have the same question (0)
  • Suggested answer
    Pradeep Rai Profile Picture
    5,489 Moderator on at
  • drhorg Profile Picture
    47 on at
    RE: Download and upload Excel template gives error

    Hi Pradeep Rai , firstly, the error that I have is with Excel template not Word Template as I mentioned in the post. Firstly, I tried directly in Dynamics and showed the error as per my original post. I also tried XRMToolbox (using Document Template Manager - since only this supports Excel, the Template Mover is only for Word). XRMToolbox - Document Template Manager failed with similar error. Thirdly the link you provided refer to "Document Template Export" which I do not find as available tool now in XRMToolbox.

    But anyways thank you for trying to help.

    I would very much appreciate if you have another idea for me to try.

    Many thanks,

  • Leco Lv Profile Picture
    on at
    RE: Download and upload Excel template gives error

    Hi partner,

    May be related to file type. After clicking on 'Export to Excel', file with an extension '.xlsx' will be downloaded. Open this file and save it as .csv format in the system.

    pastedimage1675069180821v1.png

    Hope it helps. How to migrate Templates from one environment to another.

    Whether to show supported file types when uploading?

  • Leco Lv Profile Picture
    on at
    RE: Download and upload Excel template gives error

    Hi partner,

    Any progress?

  • drhorg Profile Picture
    47 on at
    RE: Download and upload Excel template gives error

    Hi Leco Lv, sorry does not help. for template it needs xlsx file. Thanks,

  • Cpro Profile Picture
    6 on at
    Download and upload Excel template gives error
    Hi @drhorg ,
     
    were you able to solve the problem described by you two years ago?
    Right now, I experience the same problem even when I try to upload an excel template to the same environment I downloaded it from (without any changes made to it).
     
    Kind regards
    Cpro

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 271

#2
Sohaib Cheema Profile Picture

Sohaib Cheema 97 User Group Leader

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 83 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans