Trying to get .xlsx from Anaplan Connect but comes out as csv

I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue

When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly.

So it seems anaplan connect is saving the csv file, with a .xlsx extension which is causing some issues for us.

Any suggestions