Exporting Data

Overview

Qik allows you to export your data to CSV files for use in spreadsheets, reporting tools, or external systems. Exports are available from Smart Lists and generate downloadable files based on the columns and filters you've configured.

Exporting from a Smart List

The most common way to export data is through a Smart List. Since Smart Lists already define which content type, filters, columns, and sorting to use, they provide a ready-made export configuration.

Step 1: Open Your Smart List

Navigate to the Smart List you want to export. If you don't have one yet, create a smart list first with the columns and filters that match the data you need to export.

Step 2: Click Export

Click the Export button on the smart list view. This creates a background export job that processes all matching records.

Step 3: Download the File

Once the export job completes, you'll receive a downloadable CSV file. The file contains:

• A header row with the column titles from your smart list
• One row per matching record
• Data formatted according to the column type (dates, numbers, text, etc.)

What Gets Exported

The export includes all records that match your smart list's filters — not just the current page. If your smart list matches 5,000 records but only displays 50 per page, the export will contain all 5,000.

The columns in the export match the columns configured on the smart list. To add or remove columns from the export, edit the smart list's column configuration.

Export Options

• Standard Export — Generates a CSV file with all matching data
• Print Format — Formats the output for printing, which can be useful for generating physical reports

Date and Timezone Handling

Exported dates are formatted according to your browser's timezone setting. The system sends your timezone information with the export request to ensure dates appear correctly in the output file.

Large Exports

Exports are processed as background batch jobs. This means:

• You don't need to keep the page open while the export runs
• Very large exports (thousands of records) will complete in the background
• You'll be notified when the export is ready to download

Tips

• Create a dedicated smart list for exports with exactly the columns you need — this keeps your export files clean
• Use date filters on your smart list to export data for specific time periods
• CSV files can be opened in Excel, Google Sheets, Numbers, or any spreadsheet application
• If you need to export different subsets of data regularly, create separate smart lists for each export scenario

FAQs