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.

Important:

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:

  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.

    If you do not want to overwrite the previous version, you can save the report with a different name. Click Cancel, rename the report and click Save As.

  6. After the report runs, select Export-Excel Web Query in the footer.

    The report is saved as an .iqy file.

  7. 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 have to 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.

  8. 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:

Warning:

Check that you are not breaching your organizations security policy before distributing .iqy files to other users. The files are personalized and generated for your use only. A recipient of such a file would have the capability to run the report at any time in the future and see the same live data that is available to you – even if the recipient’s role would not normally give them access to such data. The only requirement to view the report is the login details (email address) used when creating the report. This address could be guessed by the recipient.

Related Topics

General Notices