Importing Patient Demographic Data
Your patient list can be imported from a CSV or Excel file. Download our template and copy your exported information into it.
Download Patient-Import-Template.csv
The file must meet these requirements:
- Do not import more than 1,000 patients at a time to prevent the import page from becoming unresponsive.
- First Name and Last Name are required. Any rows missing these will not be imported.
- A Unique Patient ID is required if you plan to also import a schedule or patient charts. Without it, we cannot link other information to the correct patient.
- Gender must be entered using one of the following:
Female,F,Male,M,Transgender,TG,Female to Male,F2M,Male to Female,M2F,Other,O,Agender,A,Bigender,B,Intersex,I,Gender Fluid,GF,Gender Queer,GQ,Non-Binary,NB,Pangender,P,Trans Male,TM,Trans Female,TF, orTwo Spirit,TS. - Date of Birth must be in the
YYYY-MM-DDformat. - Every row must contain a Country if you want to import any address information. You must map the Country column before mapping a Province/State column.
- Notes in the General Notes column will be visible to all office staff.
- Notes in the Private Notes column will only be visible to you.
If you have data that does not fit into these columns, contact us at contact.outsmartemr.com for assistance.
Once your data is properly formatted, you have two options: Assisted Import (recommended) or Self-Import.
Assisted Import
For an assisted import, upload the file to the Documents Module in your OutSmart account. Do not send it via email. The OutSmart team will then review and perform the import.
- A paid subscription is required to upload documents. If you have a free account, contact us at contact.outsmartemr.com for instructions on how to securely transfer your file. Note that there may be a cost associated with importing data for free accounts.
Self-Import
If you are confident in your ability to format the data, you can import the list yourself.
Before you begin:
- Your list must not contain more than 1,000 patients. If it does, you need to split it into multiple files and import them separately.
- Patient list imports cannot be undone or used to update existing patient information. Check your list carefully before you begin.
- Import each patient list once. Importing the same list twice creates a second record for every patient. If that happens, you can combine the duplicates with the Patient Merging Tool, one patient at a time.
To begin a self-import, sign in with the account that owns the office. You cannot import patients from a staff account.
{% stepper %} {% step %} Open the Main Navigation Menu, at the top left of the screen, and click Office. The Office Details page opens.

Click on the Main Navigation menu, and then click on the Office Details page.
{% step %} Click Data Importers, in the row of buttons beside your office’s name. {% endstep %}
{% step %} Under What kind of data would you like to import?, choose Patient Demographics. The instructions for patient imports appear on the left, with a Patient Import Template & Instructions button, and an upload box on the right.

The Data Importers tab with Patient Demographics chosen. Read the requirements on the left before you upload.
{% step %} Drag your import file into the Drop files to upload box, or click the box and choose the file. {% endstep %} {% endstepper %}
Mapping Column Data
On the next page, you must map the OutSmart patient record properties to the columns in your import file. If you used our template, it is done for you. Review the mapping to ensure it is accurate, especially for any columns highlighted in red that could not be automatically matched.

Mapping OutSmart Patient Record properties to the columns in your patient list import file.
Reviewing the Import
After mapping, click the Preview Data Mapping Results button. This will show you a sample of the first 10 rows of your data and how they will be imported. If everything looks correct, click Proceed with import.

Click on Preview Data Mapping Results to see how the data from your import file will be read by Outsmart during the import process.
If any errors occur, you will be notified of the affected rows. You can then correct these issues and create a new import file containing only the corrected rows.

A sample of how your patient list import file data will map into Outsmart Patient Record properties