Use a structured CSV to download a clearly labeled pricing table from your Dashboard. Choose Structured format when you export from Price Sheets Overview, open an affiliate’s attached sheets with one link, or download rates from an affiliate profile.
Structured format removes extra blank rows from the older CSV layout and adds a header row that names each column. When you download for a specific affiliate, the file includes the sheets or schedules attached to that affiliate.
Download pricing from Price Sheets Overview
Use the price sheets’ Overview page when you want to select which price sheets or schedules to include, then export them.
To download a structured CSV from the Price Sheets Overview tab:
- Navigate to Settings > Price Sheets > Overview.
-
Open Prices and visibility.
- In the prices and visibility controls, select the price sheet(s) or schedule(s) you want to include.
- Optional: Use the Filter pricing options to narrow items or customer types before you export.
- Open the Download CSV options.
-
Select Structured format.
Your browser downloads a CSV with a header row and one row of pricing data per line.
Note: Old format is the previous CSV layout. Prefer Structured format when you need labeled columns and a cleaner table.
For more on filtering and viewing sheets on Overview, see Using price sheets.
Download pricing with an affiliate’s sheets preselected
When you edit an affiliate, you can open the price sheets’ Overview page with that affiliate’s attached sheets or schedules already selected. Use this shortcut to export a structured CSV.
To open preselected affiliate pricing and export:
- Navigate to Settings > Affiliates.
- Find the affiliate and open their settings for editing.
- In Pricing, select View and edit in Price Sheets settings.
- Confirm the attached sheets or schedules are selected on Overview.
- Open the Download CSV options.
- Select Structured format.
Note: Price sheets and schedules assigned to one affiliate may also be used by other affiliates. Confirm you selected the sheets you intend to share before you download.
To verify rates without downloading a file, see Checking your affiliate rates.
Download rates from an affiliate profile
An affiliate profile includes a Rate sheet card you can use to download pricing for that relationship without multi-selecting sheets on Overview.
To download rates from an affiliate profile:
- Open the affiliate’s profile from your affiliates list.
-
On the Rate sheet card, click the download CSV option.
The file downloads automatically. It includes pricing for the sheets or schedules attached to that affiliate.
Note: This rate download is separate from exporting contact details as CSV from the affiliates table. For profile overview and custom contacts, see View and manage affiliate profiles.
Understand the structured CSV columns
Structured exports use these column headers, in order. Affiliate appears when the export is specific to an affiliate.
| Column | What it shows |
|---|---|
| Affiliate Name | The affiliate for this export, when the download is affiliate-specific. |
| Operator | Your company's name. |
| Generated | The date the CSV export was created. |
| Effective date | The date these rates are applied or used. Typically the date range of a price schedule. |
| Item | The Item name for that row. |
| Item ID | The Item’s ID for that row. |
| Customer type | The customer type for the rate row. |
| Price sheet | The price sheet (or related sheet name) for the row. |
| Retail price | The pre-tax price for that customer type on the selected price sheet. |
| Retail tax | The tax applied to the retail price (one summarized tax total when multiple tax types apply). Can be $0.00 when the sheet is not taxed. |
| Total price | Retail price + retail tax. The full customer-facing amount for that customer type before the affiliate split. |
| Invoice sheet | The invoice sheet associated with that rate row. |
| Commission rate | The commission rate associated with that invoice sheet. |
| Invoice amount |
The amount from the affiliate’s invoice sheet for that Customer Type. Note: On percentage commissions (e.g. “20% OTA”), this is the affiliate’s commission - typically retail price × commission rate. It is what is owed between you and the affiliate for invoicing, not a second customer price. |
| Net to operator |
What you (the operator) keep after the invoice amount.
|
| Notes | An explanation when a rate or amount can’t be shown (for example, no price configured). |
Frequently asked questions (FAQs)
What is the difference between the new structured CSV format and the old CSV format?
The structured format adds a header row and removes extra blank spacing from the older layout so columns are easier to read in a spreadsheet. The old format keeps the previous CSV layout.
Is the affiliate profile rate sheet download the same as the affiliates table CSV?
No. Rate sheet on the profile downloads pricing for that affiliate relationship. The affiliates table CSV is for contact information (including custom contacts when available), not pricing.
Does opening View and edit in Price Sheets settings create a new export feature?
No. That link opens Overview with the affiliate’s attached sheets already selected. Structured format is the newer download option you can choose from Download CSV after the sheets are selected.