Hello all,

My project involve steps to export data from a sharepoint to excel file.

Loading an.iqy file (Also known as Web Queries) into an existing Excel file can be archieved by loading the.iqy file into connections using the following steps in Excel: Choose the tab 'Data' Click 'Existing Connections' Choose 'Browse for More.' (This opens up a file picker) Navigate to.iqy.
In this video I demonstrate how to import data into Excel 2013 via a Web Query.
For Mac version of Excel import we need.iqy file. And this vidio also explains the detail to create.iqy file to import data in the excel mac. Follow this video and you will se how easy it is for.

The problem that I faced is when I exported the data, it was in iqy format. I need to change this to xlsx format. I see 2 options to get the info in the formal that I need:

Open sharepoint --> Export data into iqy --> copy from iqy & paste to new excel (xlsx format) where I need to further do some data massaging (filtering, adding new column, deleting some row).
Open new blank excel file --> click ‘Data’ --> click ‘Get Data’ --> Click ‘From online services’ --> Click ‘From sharepoint online lists’ --> input URL & wait till data loaded into excel --> save the file as xlsx

Excel creates an Excel table with a one-way data connection based on a web query file. To bring a fresh copy of the SharePoint list to Excel, select Refresh All on the Data tab. Changes made to the Excel table will not be sent to the SharePoint list. If your SharePoint list contains folders, the folder structure does not appear in the resulting Excel table.

For option #1: I dont know how to perform copy all data in the sheet to a new black excel file. Since the data was in iqy i dont think i can use the ‘excel application scope’
For option #2: I cant find a way to open a new black excel file

I appreciate your input. Thank you.

File TypeInternet Query

Developer	Microsoft
Popularity
Category	Web Files
Format	Text

What is an IQY file?

Contains a URL and other parameters for making a query over the Internet; allows information to be retrieved from an .ASP Web page and imported into Microsoft Excel; saved in the Program FilesMicrosoft OfficeQueries directory by default.

IQY files also called Web Query files.

Open over 400 file formats with File Viewer Plus.

Programs that open IQY files

Windows

Free Trial

Included with OS

Mac

Iqy Excel Mac

Free Trial

Excel Web Query File

Included with OS

How To Open Iqy File

Updated 3/5/2010