The Imports Tool is a powerful feature that allows you to efficiently transfer large amounts of data from an Excel spreadsheet in .csv format into your Apricot database. Before using this tool, it's important to properly format and organize the data within your Excel spreadsheet to ensure a smooth import process and minimize errors, including:

Once your data is ready, you can navigate to the Imports tool by selecting the Administrator tab and clicking the "Imports" page under the Record Manager category. Selecting "Prepare For Import" in the Import Actions palette will guide you through the process of selecting the target form, mapping your data to the appropriate Apricot fields, and validating the information before the final import. This flexibility allows you to create new Tier 1 or Tier 2 records, update existing records, or even import links between records. If needed, you can even undo imports that have already been completed.

Note: It is best practice to upload no more than 20,000 records at a time with the Imports Tool. Whether creating new records or updating existing records in Apricot, it is expected that the Imports Tool may experience issues when processing more than 20,000 records with each upload.

Review the articles below to learn how to manage large-scale data changes in your Apricot database and streamline your organization's data management.