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

  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'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.

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

Warning:

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

General Notices