Any table in PalDock can be exported for further work in Excel, Google Sheets, or a BI tool. Click the Export button in the table header, set the options below, and press Download.
File format
- CSV, the default
- XLSX
Delimiter
For CSV you choose which character separates the fields:
- Comma
- Semicolon
- Tab
Which one you need depends on what will open the file. Excel in a European locale expects the semicolon, most other tools expect the comma.
Columns
- All available: every column the dataset has, including the ones hidden in your current view.
- Only displayed: the columns currently switched on in the table.
Because the export can include hidden columns, you do not have to widen the table just to get a field out of it. See Advanced columns.
Rows
- All available: everything matching your current filters, not just the page you are on.
- Only displayed: the rows on the current page.
- Only selected: the rows you ticked in the table. This option appears once at least one row is selected. See Show rows in chart.
What ends up in the file
- Your filters are applied. The export is the table you are looking at, not the raw dataset. That includes the result type filter and the reporting time basis, so an export made on approved transactions contains only approved transactions.
- Amounts carry their currency. Whenever a column holds an amount, the matching currency is exported next to it, so nothing has to be guessed from the workspace default.
- Partners export what they can see. An affiliate or an advertiser exporting the same table gets their own rows and their own columns, with the same restrictions that apply on screen.
