@Subhadeep1 

Try to export in CSV and then open it through excel. This way file size is smaller when downloaded and for large chunks of data you will be able to download without corrupting the files.

In excel we usually face this issue due to the extensions xlsx, try by exporting in CSV.

Can you please marked it as correct answer or helpful. If it solved your query.