Who can export data?
Your export scope is automatically limited by your admin permissions.
Organisation administrators can export data from all teams across the organisation, regardless of membership status
Site administrators can export data from all teams within their assigned sites, regardless of membership status
Team administrators can only export data from teams they manage
What data can you export?
Tickets
Tasks
Processes
Note: Other objects aren't yet available in global exports, but you can use available local export functions instead.
How to export your data?
Navigate to the Analytics page and select the Export tab.
Choose what to export: tickets, tasks, or processes.
Select the sites and teams you want to export data from, based on your admin permissions.
Apply any optional filters as needed.
Note: The export is meant to give you complete datasets that you can then slice, filter, and analyze according to your specific needs in your preferred BI software.
Chose your export format and click on Export.
Excel format, for Excel only
CSV format, for all software except Excel
Check your email for the download link.
Exports are usually instant, though large data volumes may take a few minutes to process.
For security reasons:
You must be logged in fabriq to download the file.
Files expire after 7 days, but you can generate a new export at any time.
How to use the export?
Data model
Tickets, tasks, and processes are exported as separate files.
Each line in the ticket export represents one ticket. To analyze tasks and processes, export the file and join it to the ticket data using the Ticket ID.
This structure provides clear, comprehensive data for any analysis.
Exports follow a stable, analysis-ready data model:
Columns include both names and IDs for relevant fields. Names help with interpretation; IDs ensure uniqueness for mapping and handle name changes.
Columns include both name and email for user mentions.
Column headers are always in English for consistency.
Origin site and team columns show where the object was originally created. If blank, the object was created outside of a team (for example, from the fabriq home page). This data is only present for tickets created after Jan, 22 2026.
All dates and times are converted to UTC. This may differ from what appears in the app but ensures reliable comparison across sites.
When a field references a deleted value (such as a removed user or deleted label), exports display a null value.
CSV formatting
A CSV (Comma-Separated Values) file is a simple, widely used format for exporting and importing structured data.
The CSV format is not compatible with Excel. Please use the Excel format when exporting.
File structure: Each row represents one record and each column one field.
Header row: The first row contains the column names.
Delimiters: Values are separated by a comma.
Text encoding: Files are encoded in UTF-8, supporting special characters.
Example:Déviation qualitéQuoted values: Fields with commas or line breaks are enclosed in double quotes.
Example:"Line stop, zone A"Empty values: Missing data is left empty.
Example:1234,,OpenDate and time format: Dates and timestamps are exported using a consistent standard format. Dates appear as
2025-01-06, and timestamps (for example in logs) appear as2025-01-06T14:32:00.000000Z.Numbers and decimals: Numbers use a dot (
.) as the decimal separator.
Example:12.5Raw data only: The export contains data only, without formatting or formulas.
Example: No colors, no Excel formulas
Importing a CSV format in other software (except for Excel)
The CSV format is not compatible with Excel. Please use the Excel format when exporting.
Make sure to use the following settings when importing the file to other software:
Import CSV file
File origin / Encoding: Unicode UTF‑8
Data type: Delimited
Delimiters: Comma
Text qualifier: Double quotes (")
Disable auto date/number detection if it alters values
Running analysis (TO BE COMPLETED)
Examples of analysis that can be performed
Troubleshooting
Didn’t receive the email?
Check spam or your corporate filters.
If the problem persists, contact the support.
Link expired?
Re‑run the export and use the new link within 7 days.
No data to export?
Filters might be too restrictive. Enlarge the scope.
File too large or times out?
Narrow your scope or add date/status filters
Columns look unfamiliar?
You might not be used to the English naming, check the content to identify the field, and keep a data dictionary in your BI workspace mapping IDs to business concepts.