Export data table

To download a file containing your data table items, simply click Export in your collection header.

Note: Exported data represents your current data table items. If your collection is filtered -for example with a search term- the export file will contain your filtered items.

Export Button
Export Button

A modal will open to select the Export format and the properties to export.

CSV and Microsoft Excel (.xlsx) formats are available. When at least one of your properties is hidden from the Data Table, an option is shown to export only visible properties or all your properties.

For CSV format exports, an option to select the column delimiter is available. Comma and Semicolon delimiters are available. Exported CSV files use UTF-8 for encoding.

Export Modal
Export Modal

Export data in the current sort order

When you sort your collection by a property, the export modal displays an Order By "Property Name" option. This option is checked by default, so rows in the exported file follow the same ascending or descending order as your data table.

I recommend keeping it checked when you plan to review or share the exported file. The rows will appear in the order you already verified in Datablist. Uncheck it to export rows in the collection's default order.

Export data in the current sort order
Export data in the current sort order

Export enrichment run statuses

Enrichment run status properties contain structured data, so Datablist excludes them from exports by default. To include them, open More options and check Export enrichment run statuses. This option is available for full collection exports in CSV and Excel formats.

Datablist adds two columns for every enrichment run status property:

  • Property Name - Status contains Success, Warning, or Error.
  • Property Name - Credit Cost contains the credits used for the enrichment run.

For example, an enrichment property named Waterfall Email Finder creates Waterfall Email Finder - Status and Waterfall Email Finder - Credit Cost columns. This split keeps each exported cell compatible with spreadsheet tools instead of placing the run status object in one cell.

Export enrichment run statuses and credit costs
Export enrichment run statuses and credit costs

You can open the generated file with Microsoft Excel, Google Sheets, Apple Numbers, or any CSV editors.

Export selected items

To export only some items from your collection, select items and click the "Export items to CSV/Excel" button in the top bar.

The export modal will open to perform an export with your selected items.

Export Selected Items
Export Selected Items

Export with copy/pasting

Another simple way to export items or cells is to use copy/pasting. Select items or cells and click "Edit -> Copy" in your browser or use the keyword shortcut Ctrl + c to copy the data in your clipboard.

Clipboard data is compatible with any spreadsheet tools, data editors, or text editors.

Data Types export formats

When exporting data, Datablist converts all data types to string values:

  • Checkbox data is exported with TRUE and FALSE values.
  • DateTime data is exported using ISO 8601 format