How to import your client data


Whether you're coming from another EHR or from paper and pencil records, we can help you import the clients you already have. 

Here is a summary of the process:

  1. Download the Data Import Template in your preferred format:(CSV or Excel).
  2. Review the Data Import Guidlelines below. These guidelines contain important requirements about how your file needs to be organized. If your file is not formatted correctly, we will return it to you to modify.
  3. Enter your client data into the Data Import Template.
  4. Submit your completed spreadsheet to our SimplePractice Imports Team by storing it in the Johnny Appleseed test client. 
  5. Contact the SimplePractice Imports Team by submitting a request through our Help CenterOur team is HIPAA trained to handle customer client data.

Note: The first couple rows of the Data Import Template contain explanatory text, and below the header field row (Row 12), we've included a sample row of data. Please replace this sample row by deleting the entire row and replacing with your first client. 

Data Import Guidelines

Before storing your file in the Johnny Appleseed client page, please go through the following list to make sure your file is setup properly:

  1. Required fields. All fields marked with an asterisk (*) are required, so must contain a value.
  2. Data we are NOT able to import. The following fields should NOT be included in your data file: client occupation, client employer, scheduling or calendar data, notes and session data, diagnosis data, and billing data.
  3. Insurance payer IDs. If you accept insurance and have client insurance data to import, you will need to include Payer IDs. A Payer ID is a unique ID number that is assigned to an insurance company for the purpose of transmitting claims electronically. Each company has a specific number, and it must be 100% correct in order to collect on each claim. How do I find payer IDs?
  4. Clinician. If you have multiple clinicians, you will need to add a Primary Clinician column to your import file that includes the full name of the clinicians, exactly as they appear in SimplePractice. 

Also, check that your file uses the following fields names and responses:

  • Gender. Responses include Male, Female, Trans M-to-F, Trans F-to-M, or blank.
  • Race. Responses include American Indian or Alaskan Native, Asian or Pacific Islander, Black, White, or blank.
  • Relationship status. Responses include Married, Divorced, Domestic Partnership, Separated, Widowed, or blank.
  • Employment status. Responses include Full-Time, Self-employed, Unemployed, Full-time Student, Part-time Student, Retired, Homemaker, or blank.

Store your completed file in the Johnny Appleseed test client

Here is the how to submit your file to the Imports Team: 

  1. Log into your SimplePractice account.
  2. Locate Johnny Appleseed’s client page by searching for him in the client search bar near the top of the screen.
  3. Click Store New Document on the right navigation bar.
  4. Navigate to your CSV or Excel.
  5. Upload your document. 
  6. Contact the SimplePractice Imports Team by submitting a request through our Help Center to let us know that your file is ready.

Note: Data imports can take 5 - 7 business days to complete. If your file is not formatted correctly, it will delay your import.


Q. I downloaded the template, but there are some fields that I want to include that are not in the template file. For example, a lot of my clients have nicknames, so I would like to import this into my account. Is that possible?

A. Yes! The fields included in the Data Import Template are the most common fields, but there are many, including Nickname, that you can add to your file. The table below is the comprehensive list of available import fields. 


Have more questions? Submit a request