Exporting a Saved Report as an Excel Web Query

We can export a saved report as an Excel Web Query. When the report is exported, data can be refreshed from within Microsoft® Excel with the latest information from your NetSuite account. 

To create an Excel Web Query: 

1. Start the Report Builder by clicking Customize on any report or by clicking Edit next to a report name on a list of saved reports. 
2. On the Report Builder page, click More Options. 
3. Check the Allow Web Query box. 
4. Click Save. 
5. Verify that you want to overwrite the previously saved version of the report. 
6. If you do not want to overwrite the previous version, click the Cancel button, rename the report and click Save As to save the report with a different name. 
7. After the report runs, select Export-Excel Web Query in the footer. 
8. The report is saved as an .iqy file. 
9. In the File Download window, you can click Open or Save if you are running on a PC. If you are running on a Mac, save the file. 
   • If you have saved an .iqy file on a PC, you must double-click it to get it to run in Microsoft® Excel. 
   • If you have saved an .iqy file on a Mac, you must first start Microsoft® Excel, then manually import the file by going to Data > Get External Data > Run Saved Query and selecting the .iqy file. 
10. When the .iqy file opens in Microsoft® Excel, in the Enter Parameter Value window, enter the email address you use to log in to your NetSuite account (or if you did not create the Web query, the email address of the user who did), check the option if you want, and click OK. 
    • Your data is loaded into Microsoft® Excel. 
    • You can click Refresh Data to retrieve the latest data from your NetSuite account. 

Notes: 

• Checking the Use this value/reference for future refreshes box enables you and any other user who can access the report to refresh this report from within Microsoft® Excel indefinitely without having to re-enter an email address. The only way to deny future access is to not check this box, remove the check from the Allow Web Query preference, or delete the saved report. 
• If you plan to send a Web query to other users, be aware that IP address rules may prevent them from accessing it. For example, if IP address rules are defined for you when you create a Web query, other users logging in from different IP addresses cannot access this query.  
• When a user accesses a Web query created by someone else, an inconsistency in usage information occurs in login audit trail information and related saved searches. The username is recorded as the creator of the saved report exported as a Web query, but the IP address is the address of the other user accessing the query. 
• If you export a report as an Excel Web Query (.iqy) file when you are logged in using SAML Single Sign-on, this file may fail to retrieve data from NetSuite. In this case, you need to log in to NetSuite using the NetSuite login page and export the report again. 

NOTE: 

Web Query functionality is not available for financial statements. You will not see the Allow Web Query option for the following reports: Income Statement, Income Statement Detail, Comparative Income Statement, Balance Sheet, Balance Sheet Detail, Comparative Balance Sheet, Cash Flow Statement, Budget Income Statement, Budget Income Statement Detail, Budget vs. Actual, Cash Statement, and Cash Statement Detail. 

If you like to have financial reports to be available in excel, then we can make use of ODBC (but the response will be raw data not structured like a report).