How To Import Client List - CaseFox | Legal Software

How To Import Client List

Please visit for details about how to import data into CaseFox.

 [If your existing system can export the client list, case list (with client references), and time entries (with case references) in tabular form into CSV or Excel formats, we may be able to import the data into your account. Please email the exported data files to us.]

Note that CaseFox can also import your Google contacts with just a few clicks. Visit "Settings/Tools/Reports" -> "Import Clients". 

If you want to import from other sources, please follow the following instructions. CaseFox also supports import through vCards. Please click on the above link for instructions.


How to Import Client List into CaseFox
 
You may import your client list from other systems into CaseFox. CaseFox supports import through a CSV file.

Prepare a CSV file

1. Export your client list in CSV file format from another software. You can also export in MS Excel format. Open the XLS file in MS Excel. Click on "Save As." Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)" and Save. 
 
2. Download CaseFox CSV Sample File.
 
3. Format the exported file so that the columns match the sequence in the sample file. The first line must include the column headers. 
 
4. All 19 columns (field names) in the CaseFox sample file must be present in the formatted file and the columns must be in the same order as in the CaseFox sample file. Billing address column values and Company column values may be left blank (but the column headers must be present). 
 
Import the formatted file into your CaseFox account
 
1. Login to your CaseFox account.
 
2. Click on the "Settings/Reports" link on the right top corner.
 
3. Click on "Import Clients from File". On the right side panel, click on "Choose File." Select the formatted CSV file and click Ok. 
 
4. Click on "Upload File." 
 
5. If the CSV file is formatted according to CaseFox requirements, a table will be displayed on the screen. The table will include a default header (field names) and the header retrieved from the file. Verify that the header sequence retrieved from the file matches with the default header sequence. Field names in the CSV file can be different but the sequence must match. 
 
6. You may leave the Company field blank (if there is no company). 
 
7. You may leave Billing address fields blank (but headers still must be in the file). If left blank, corresponding field values from the client address will be automatically taken. For example, if the BillingCity field is left blank, the data from the City field will be used for BillingCity. 
 
8. Verify if the client data in the table is displayed correctly and if each data value is being displayed in the right column.
 
9. If there are inconsistencies in the displayed data, make necessary changes in the CSV file and repeat steps 2 to 8. 
 
10. If the table is displaying the data correctly, click on the Create Client button. Clients will not be created in your account until this button is pressed.


=============================================================================


Importing from Google Contacts

1. Login to your CaseFox account. Go to "Settings/Tools/Reports" -> "Google Settings".

2. Use the button to link to your Google Contacts and Calendar. A screen will redirect to Google for permissions. Grant permission to CaseFox.

3. On the left side menu bar, click on "Import Clients."

4. A pop-up will list your Google Contacts (only the ones that have street address information). Select one more contact and click on the button on the pop-up to create import contacts and create clients in CaseFox.
 

Importing from QuickBooks Online

1. Login to your CaseFox account. Go to "Settings/Tools/Reports" -> "Import Clients/Contacts".


2. Click on the Connect To QB button. A screen will redirect to Intuit for permissions. Grant permission to CaseFox.

3. Click on the Import from QuickBooks Online button."


Import QuickBooks IIF File with CUST! entries

1. Export your client list in CSV/IIF file format from QuickBooks or other programs that are capable of exporting client lists in IIF format. After exporting, run Microsoft Excel and open the IIF file. Excel will show a data format conversion dialog box. Click Finish with default settings. Then in Excel, click on Save As, and in file type select CSV type and save.

2. In CaseFox, click on "Settings/Tools/Reports" and then select the Import Clients option on the left side menu bar. Select the exported file and click on Upload. If the file is in the correct format, a list of clients will be displayed. Verify data and click on the "create clients" button just above the displayed to be imported data table.
 

Import using Excel/CSV or vCard - Prepare file (version 3.0)

1. Export your client list in Excel file format from another software (if CSV or XLS, open the CSV or XLS file in Excel and do a SaveAs to XLSX format). If the system displays a file read error, the file may be protected. Please make a copy by doing SaveAs in Excel into XLSX format.

Using vCards - Many software applications (e.g., MS Outlook, Google Mail, etc.) also allow exporting contacts as vCards. If the application supports vCard export, you may export more than one contact in one vCard file and use the vCard file, instead of CSV or XLS file, to import your contacts/clients into CaseFoxTMPrior to exporting vCard file, ensure that the all contacts include email and postal addresses.

2. (Skip this step if using a vCard file) Make sure that the first row of the spreadsheet in your Excel file contains column headers (e.g., First Name, Last Name).

3. (Skip this step if using a vCard file) First Name and Last Name are required columns.

4. (Skip this step if using a vCard file) Client's Email column is also needed. However, if not provided (or if provided but not all clients have emails), your email will be used.
 


Import the formatted file into your CaseFox account

1. Login to your CaseFox account.

2. Click on the "Settings/Reports" link in the right top corner.

3. Click on "Import Clients from File". On the right side panel, click on "Choose File." Pick your Excel or vCard file and click Ok.

4. Click on "Upload File."

5. If the vCard file is formatted correctly, a table will be displayed on the screen. The table will include a default header (field names) and the header retrieved from the file. Verify that the header sequence retrieved from the file matches with the default header sequence.

6. If importing from an Excel file, a column mapping screen will be shown so that the system knows the details of the data contained in your Excel file.

7. If there are inconsistencies in the displayed data, make necessary changes in the Excel file and repeat steps 2 to 8.

8. If the table is displaying the data correctly, click on the Create Clients link below the table. Clients will not be created in your account until this button is pressed.

 


 

Note: If you are having difficulty importing the client list, please email the CSV/XLS/vCard file to service(at)casefox.com

from your registered email. We will attempt to import the client list into your account.

 

Automatic Update

If the same client list is imported again, client information is updated instead of creating new entries in the CaseFox client list. Therefore, no two entries with the same First Name, Last Name, Company, and Email are created.



    • Related Articles

    • Can I import my client list?

      Yes. You can import your client list via a CSV or vCard file. Please see http://www.casefox.com/web/importclients.html for more details or contact us. If you have your client list that is not formatted according to the instructions, you may also send ...
    • Import Your Client List into CaseFox

      CaseFox Timekeeping and Billing Software supports importing clients via a CSV file. You may export your client list from another system and follow the instructions at http://www.casefox.com/web/importclients.html for importing the client list into ...
    • Import into CaseFox Client List Case List and Time Entries From Other Software

      Please click for more information: Importing Data Client List Login to your CaseFox account, Click onSettings/Tools/Reports - Import Clients/Contactsfor importing your client list into CaseFox. Case List Login to your CaseFox account, Click on ...
    • How to Import Data from other Legal Products

      Importing data from other systems: (such as Clio, MyCase, TimeSlips, Bill4Time, TimeMatters, TSheets, Rocket Matter - all trade names of respective owners) into CaseFox® CaseFox can import some of the data automatically when data exported from Clio ...
    • How to Import Data into CaseFox

      Objective The main aim of this article is to help you in importing data into CaseFox. Want to explore, Try CaseFox for free Questions can be directed to service@casefox.com Overview Clients/Contacts List Go to Settings. Select Import Clients/Contacts ...