Exporting a Saved Report as an Excel Web Query
You 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.
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.
To create an Excel Web Query:
-
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.
-
On the Report Builder page, click More Options.
-
Check the Allow Web Query box.
-
Click Save.
-
Verify that you want to overwrite the previously saved version of the report.
If you don't want to overwrite the previous version, you can save the report with a different name. Click Cancel, rename the report and click Save As.
-
After the report runs, select Export-Excel Web Query in the footer.
The report is saved as an .iqy file.
-
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've saved an .iqy file on a PC, you have to double-click it to run it in Microsoft® Excel.
-
If you've saved an .iqy file on a Mac, first start Microsoft® Excel, then import the file manually by going to Data > Get External Data > Run Saved Query, and selecting the .iqy file.
-
-
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 didn't create the Web query, use the email address of the person who did), check the option if you want, and click OK.
-
Your data loads into Microsoft® Excel.
-
Click Refresh Data to get the latest data from your NetSuite account.
-
Notes:
-
Use caution when checking the Use this value/reference for future refreshes box. Checking the box enables you and anyone with access to the report to refresh it from Microsoft® Excel any time without having to reenter an email address. The only way to deny future access is to leave this box cleared, clear the Allow Web Query box, or delete the saved report.
-
If you plan to send a Web query to others, be aware that IP address rules may prevent them from accessing it. For example, if IP address rules are defined when you create a Web query, users logging in from other IP addresses won't be able to access it. For information about these rules, see Enabling and Creating IP Address Rules.
-
When a user accesses a Web query created by someone else, a mismatch in usage information occurs in login audit trail information and related saved searches. The user name is recorded as the creator of the saved report exported as a Web query, but the IP address belongs to the other person who accessed the query.
-
If you export a report as an Excel Web Query (.iqy) file when you're logged in using SAML Single Sign-on, the file may not be able 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.
Make sure that you're not breaching your organization's security policy before sharing .iqy files with others. The files are personalized and generated for your use only. Anyone you share the file with can run the report at any time and see the same live data you can, even if their role wouldn't normally give them access. The only thing needed to view the report is the email address used to create it, which could be guessed by the recipient.
Related Topics
- Report Customization
- Report Builder Interface
- Report Customization Permission
- Adding, Removing, or Reordering Report Columns
- Formatting Numbers on Reports
- Filtering Data on Reports
- Sorting Data on Reports
- Setting Additional Options for Custom Reports
- Arranging Data on Summary Reports
- Setting Up Cash Basis Reporting
- Sharing Custom Reports with Other Users
- Example Report Format Changes
- Saving a Custom Report
- Deleting a Custom Report