Activating this toggle splits your downloadable file into one spreadsheet row per product.
This is useful when you've added multiple products to your opportunity, order, or subscription, and you'd like these to be shown in individual rows in your export file.
To export, your user needs the Can export data permission. See Access permission: Export.
Where this feature is available:
- Order list
- Opportunity list
- Subscriptions list. For a subscription with several periods, the export contains the order rows of the period that is currently active.
-
Report centre
- Opportunities
- Orders
Example
Let's say you've made these actions:
- Entered the opportunity list
- Selected two opportunities
- Clicked Export in the list header:
- Turned on the Export order rows toggle:
- Clicked Export. The export runs in the background. When it is finished, you get a notification, such as Order export done. Click it to download the file.
The two first rows are products and come from the same opportunity.
The third row comes from another opportunity that only contains one product. Your exported file will then look like below:
| Opportunity ID | Company | Contact name | Description | Product | Price | List price |
| 1234 | Company Name Inc | Firstname Lastname | Subscription fee Q2 | Product name | 4995 | 4995 |
| 1234 | Company Name Inc | Firstname Lastname | Subscription fee Q2 | Product name | 1995 | 1995 |
| 5678 | Another Company Name Inc | Firstname Lastname | Consultant time | Product name | 1995 | 1995 |
Large exports
A large export is split into several files. Clicking the notification then opens Download Export, where you download each file. The more columns you select, the fewer rows fit in each file. With Export order rows turned on, each file holds fewer orders, since each order takes up several rows.