This guide walks through how to export all collections data from a Specify database. To perform a full backup with all records included, see How to Create a Full Database Backup in Specify.
Export All Collections Data to CSV
All collections data from a database can be exported to CSV using the Create CSV feature in the Query Builder. To do this, you will need to build a query that includes every field in the database that contains the data you would like to export.
1. Identify Populated Fields
First, you will need to find out which fields contain data. One option for this is to run a query on every field using the 
and Empty operators and note which fields return results.
However, running a query on each field can be very time consuming. Instead, we recommend running a script to identify the fields for you. An IT Administrator will need to follow this guide:
2. Build Your Query
Now, you can build a query that includes all of the fields you identified. We recommend using Collection Object as the base table because it has multiple relationships with other tables.
The Database Schema page in User Tools displays the Specify data model, which may help you identify the correct relationships to use in your query.
3. Create CSV
After you have built your query, run the query and click Create CSV. Once Specify has finished generating the file, it will either automatically download or appear in the 
Notifications tab.
