This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How can I export a saved report to excel while also determining which lines are part of which section

&gt;*AI generated answer (using internal Slack threads):*
To export a saved report to Excel while also determining which lines are part of which section, you can follow these steps:

1. Run the saved search in NetSuite.
2. Click on the 'Export' option and select 'Excel (xls)'.
3. Open the exported file in Excel.

However, it's important to note that the exported Excel file will not include the title, date range, or any filters applied in the saved search. Also, any highlighting or bolding of specific rows in the saved search will not be retained in the exported Excel file. This is a limitation of the export functionality in NetSuite.

If you need to include the title, date range, or filters in the Excel file, you may need to manually add them after exporting the file. Similarly, if you need to retain the highlighting or bolding of specific rows, you may need to manually apply them in the Excel file after exporting.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1601304202092600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.799712658

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1672775241711709|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.79134506

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1677600839419419|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.787176967



Please provide your feedback on this answer.

<@U06NYKGGFTL> also consider something like CloudExtend ExtendInsights which allows you to run saved searhces directly into Excel where you can then use the power of Excel to consolidate ad format your data as desired. A little work up front but once you set it up you can refresh with 1 click (or on a schedule) and your formatted reports will also update.

<https://support.cloudextend.io/en/articles/6942824-creating-income-statements-from-g-l-search|Here's an example> of a way to recreate an income statement and format it as desired.

<@U750CHB8F> oh this is wonderful. Does it only work with saved searches? the primary use is for a saved report but just wanted to make sure.

<@U06NYKGGFTL> unfortunately the API does not support reports. Boy I wish it did. If you're not accessing financial data you could use Excel Web Query for free, but if it's financials you are looking for it won't work.

Most reports can be converted to saved searches. You can even search NetSuite's support center and you will see plenty of examples.