Here is the most common issues seen while trying to Export data to Excel from an Advanced Find view. And you end up seeing this error which says ‘Failed to Generate Excel’ –

Getting the Error

1. So this is what you typically do – When you run an Advanced Find and click on Export when you see the results
   
2. Or, when you are in an entity’s view and you want to Export to Excel right from the ribbon button like this –
   
3. But, as soon as the File is being generated and you feel you’re there –
   
4. You see this –
   

Culprit

The reason for this is – Redundant Display Names of the fields used in the View you are exporting

How to catch this

The easiest way to catch this is trying to Export the view to Excel Online, this will give you the exact error

The Downloaded Log File won’t help much in identifying the column that is duplicate though, you’ll need to go through the Columns manually to check

Hope this helps! 🙂