Migration templates are spreadsheet templates with pre-filled headers that can be used to bulk-import data into Clio using the Imports page.
Import contacts
When importing contacts into Clio, the required fields are the first and last name of the person contact or the company contact’s name. If there are both person and company contacts, a person contact is created and then can be linked to the company contact. If the company does not yet exist in the system, then an empty company contact is created. The person contact will then have all the other contact information (address, etc.).
Important: Contacts must be imported before matters for them to link properly.
- Open this template.
- Populate the spreadsheet with your contacts information.
- title: Enter the contact's title (i.e. Mr, Ms, Mrs).
- job_title: Enter the contact's job title.
- first_name: Enter the contact's first name. Required if “company” is blank
- last_name: Enter the contact's last name. Required if “company” is blank
- company: Enter the company's name. Required if “first_name” and “last_name” are blank
- business_street: Enter the contact's street address.
- business_city: Enter the contact's city.
- business_state: Enter the contact's state. You can also enter the country.
- business_postal_code: Enter the contact's postal code.
- email_address: Enter the contact's primary email address.
- primary_phone: Enter the contact's primary phone number.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Contacts from Outlook CSV.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import matters
Important: Contacts must be imported before matters for them to link properly. Additionally, the "originating attorney" will not import into Clio.
- Open this template.
- Populate the spreadsheet with your matter information (required fields in red are mandatory when filling out this spreadsheet).
- status: This must be either Open, Closed or Pending. Required
- location: This is the location of the matter. This populates the Location field inside the matter in Clio.
- client_reference: This populates the Client reference field inside the matter in Clio. This can be any information that your firm need, such as court file number or office file number, unless your firm engages in LEDES billing.
- description: Your specific case information. Required
- open_date, close_date, and pending_date: Enter dates in MM/DD/YYYY format.
- custom_number: This is the matter number that will display if the account is set to a manual numbering system, otherwise this can be left blank and matters will use Clio’s automated matter numbering.
- note: This will create an entry in the Notes subtab of the matter using the subject “Matter import notes.”
- client_first_name, client_last_name and/or client_company_name: These are for linking the matters to their contacts. They should match exactly to the first/last/company names listed in the Contacts section. Required
- responsible_attorney: This must be an exact match for an attorney user on your account. You can also set this in the import.
- practice_area: This refers to the general type of law for the matter.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Matters from CSV.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import activities
Activities must be imported on a per user basis into Clio. This may require breaking up activities into separate CSVs for each user with an active license. Once imported, activities will appear as unbilled. If you enabled the hard and soft cost entries feature in your Clio Manage bill settings, you can choose to import hard cost expenses as soft cost entries or separate hard cost entries from soft cost entries.
If hard and soft cost entries are enabled in your Clio Manage bill settings, the ExpenseEntry activities will be created as soft cost entries, as per the "Example_Activities" template linked in the instructions below.
- Open this template.
- Populate the spreadsheet with your activities information.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- date: Enter the date in MM/DD/YYYY format. Required
- activity_description: This must be an exact match for an activity category (for time entries) or expense category (for expenses) in Clio or a new one will be created. It can be left blank.
- note: This corresponds to the Description field in Clio.
- price: This is the rate or value of each expense. Required
- quantity: For time entries, this is the duration in decimal hours. For expenses, this is the quantity (if left blank, “1” unit is assumed).
- type: This must be either TimeEntry or ExpenseEntry.
- activity_user: Enter the firm user associated with the activity.
- non_billable: This is only for time entries and must be “yes,” “true,” “y,” or “1” to mark an activity as non-billable. The activity will be marked as billable if this is left blank or other text is entered.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Activities from CSV.
- In the User dropdown menu, select the firm user who will be responsible for the imported entries.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
If you want to import hard cost entries and soft cost entries separately, you can add a new expense_type column. In this column, enter SoftCostEntry for soft cost entries or HardCostEntry for hard cost entries. You can also add a vendor_name column and a reference column to import the vendor and reference fields for hard cost entries. See the "Example_Activities2" template linked in the instructions below.
- Open this template.
- Populate the spreadsheet with your activities information.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- date: Enter the date in MM/DD/YYYY format. Required
- activity_description: This must be an exact match for an activity category (for time entries) or expense category (for expenses) in Clio or a new one will be created. It can be left blank.
- note: This corresponds to the Description field in Clio.
- price: This is the rate or value of each expense. Required
- quantity: For time entries, this is the duration in decimal hours. For expenses, this is the quantity (if left blank, “1” unit is assumed). Any value other than 1 for hard costs will result in an error.
- type: This must be either TimeEntry or ExpenseEntry.
- expense_type: Enter either SoftCostEntry or HardCostEntry. If you do not enter a value, the importer will import all expense entries as soft cost entries.
- activity_user: Enter the firm user associated with the activity.
- non_billable: This is only for time entries and must be “yes,” “true,” “y,” or “1” to mark an activity as non-billable. The activity will be marked as billable if this is left blank or other text is entered.
- vendor_name: This is optional for hard cost entries. If the vendor name is found as a contact in Clio, a new company contact matching the vendor name will be created as part of the import process.
- reference: This is optional for hard cost entries.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Activities from CSV.
- In the User dropdown menu, select the firm user who will be responsible for the imported entries.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import calendar events
Calendar entries must be imported on a per-calendar basis into Clio. This may require breaking up calendar entries into separate CSVs for each user/calendar. The user whose calendar events are being imported must have an active user license.
Note: All-day calendar events still require a start and end time to be populated. We recommend filling in “12:00 PM” for both Start Time and End Time to avoid this error.
- Open this template.
- Populate the spreadsheet with your appointment information.
- start_date: Enter in MM/DD/YYYY format. Required.
- end_date: Enter in MM/DD/YYYY format. Required.
- start_time: Enter in H:MM:SS AM/PM format. Required
- end_time: Enter in H:MM:SS AM/PM format. Required
- subject: This field can store a line of text and maps to the Summary field of calendar entries. Required
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description).
- location: This field can store a line of text and maps to the Location field of calendar entries.
- description: This field can store multiple lines of text and maps to the Description field of calendar entries.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Calendar from CSV.
- Under Destination Calendar, select the calendar that should contain the events.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import contact and matter notes
Note: If a note does not import successfully, click the import ID, then scroll to the bottom to see the import error.
- Open this template.
- Populate the spreadsheet with your notes information.
- date: Enter in MM/DD/YYYY format. Required
- subject: Enter the subject of the note.
- detail: Enter the details of the note. Required
- first_name, last_name and company_name: These should match exactly to the first/last/company names listed in the Contacts section. Required
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Notes from CSV.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Important: Ensure that the matter number is an exact match to the matter in Clio or the import will fail. Do not include the matter description as part of the matter number.
- Open this template.
- Populate the spreadsheet with your notes information.
- date: Enter in MM/DD/YYYY format. Required
- subject: Enter the subject of the note.
- detail: Enter the details of the note. Required
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Notes from CSV.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import contact and matter custom fields
Custom fields created in Clio must NOT be set as Default or Required before importing custom field data, otherwise the import will fail. You can set your custom fields as Default and/or Required after the import is complete.
Important: These imports only works if all contacts, matters, and custom fields already exist in Clio and the custom fields have not been selected on any contacts and matters. Remove any custom field selections from your contacts and matters before importing custom fields.
Note: Custom fields that include special characters (?, :, /, etc) will not import into Clio. Remove any special characters before continuing, including ":" if it is used in matter names.
If you are importing custom fields into a large number of existing contacts, export your contact list first, then copy and paste the first and last names into their respective columns for added accuracy.
- Create the relevant custom fields in Clio.
- Open this template.
- Populate the spreadsheet with your contact custom fields information.
- first_name, last_name and company_name: These should match exactly to the first/last/company names listed in the Contacts section. Required
- Edit the custom field column headers to exactly match the name of each custom field that you created in step 1, and then enter each column with their respective data. Required
- Dates need to be in MM/DD/YYYY format.
- Values should be True (checked) or False (unchecked).
- Pre-enter all possible picklist options from your spreadsheet into Clio prior to importing.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Notes from CSV.
- Click Choose File and select the CSV file you saved in step 5.
- Click Upload File.
The matter must be an exact match to the matter display number. If you are importing custom fields into a large number of existing matters, export your matter list first, then copy and paste the matter display numbers into column A for added accuracy.
- Create the relevant custom fields in Clio.
- Open this template.
- Populate the spreadsheet with your matter custom fields information.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- Edit the custom field column headers to exactly match the name of each custom field that you created in step 1, and then populate each column with their respective data. Required
- Dates need to be in MM/DD/YYYY format.
- Values should be True (checked) or False (unchecked).
- Pre-enter all possible picklist options from your spreadsheet into Clio prior to importing.
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Notes from CSV.
- Click Choose File and select the CSV file you saved in step 5.
- Click Upload File.
Note: The import’s State will change to Complete once the import is finished. The Successes will remain at 0 because no new notes were imported; however, the custom field data will still be added.
Import related contacts
Once the import begins, the CSV will match related contacts with existing contacts in Clio and will then create a contact if there is no exact match.
- Open this template.
- Populate the spreadsheet with your related contacts information.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- relationship: Enter the relationship label that connects this related contact to the contact. Required
- company, first_name, last_name: These are used to link the related contact themselves and should match exactly with the first/last/company names in your contact import or existing contacts in Clio. Required
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Matter/Contact relationship from CSV.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import tasks
Tasks must be imported on a per user basis into Clio. This may require breaking up tasks into separate CSVs for each user. The user for whom tasks are being imported must have an active license on the account.
- Open this template.
- Populate the spreadsheet with your tasks information.
- subject: Enter the subject of the task. Required
- due_date: Enter the task due date in MM/DD/YYYY format. Required
- complete: Enter "1" for completed tasks, and "0" for incomplete tasks. Required
- description: Enter the description of the task.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description).
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Tasks from CSV.
- In the User dropdown menu, select the firm user who will be responsible for the imported entries.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
Import balances forward (outstanding balances)
If you are importing outstanding balances, you can complete the attached template and outstanding balances as a one-hour unbilled time entry. Do not include commas in the “price” column. You can also use the manual method for importing balances forward.
Important: Outstanding balances/balances forward imported using this template method may not necessarily facilitate a seamless transition. We highly recommend adding your accounts receivable balances manually instead by following the instructions listed below the "Manually import outstanding balances" tab.
- Open this template.
- Populate the spreadsheet with your accounts receivable information.
- matter: This must be an exact match to a matter display number in Clio. The matter display number is the full matter name, not including what comes after the colon on the Matters page (i.e. not the matter description). Required
- date: This can be the original invoice date or the date the total accounts receivable is accurate as of. Enter it in MM/DD/YYYY format. Required
- activity_description: This is set to “Balance Brought Forward from Previous Software” by default but can be changed.
- note: This corresponds to the Description field in Clio.
- price: This is the outstanding balance amount. Required
- quantity: Enter “1”
- type: Enter “TimeEntry”
- Delete any unused row cells.
- Save the file in CSV format.
- Open Clio's Imports page:
- Click Add.
- Under Import select Activities from CSV.
- In the User dropdown menu, select the firm user who will be responsible for the imported entries.
- Click Choose File and select the CSV file you saved in step 4.
- Click Upload File.
- Go to Activities > Manage Categories.
- Click New Category.
- Select Time entry category.
- Enter the Name (e.g. “Outstanding Balance”).
- Under Billing method, select Flat rate.
- Leave the Rate as 0.00.
- Click Save Category.
Step 2: Create a time entry for the balance
- Go to the appropriate matter's Activities subtab.
- Click New Time Entry.
- Select the created Activity Category.
- Under Rate, enter the outstanding balance.
- Click Save Entry.
Review migration import errors
Once your data is imported, you can review and fix any migration import errors using the importer functionality.
- Go to Clio Importer.
- Click the underlined errors.
- Change the file that downloads to a .CSV file and open the file in excel.
- Read the errors in the left hand side column.