convert .iqy file to .xlsx file using macro

I have .iqy file exported from sharepoint, but i want to convert this as xlsx file
or
i need to copy all data from sharepoint to in existing Excel template file.

Thanks,
Gourish