Skip to content

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, or Two Spirit, TS.
  • Date of Birth must be in the YYYY-MM-DD format.
  • 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.

How to get to the Office page from the main menu.  Image showing the main menu open and an arrow pointing to the Office option.

Click on the Main Navigation menu, and then click on the Office Details page.

{% endstep %}

{% 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 of Office Details, with Patient Demographics chosen. Shows the important information about patient list imports, the test import advice, the Patient Import Template and Instructions button and the data requirements on the left, and the Drop files to upload box on the right.

The Data Importers tab with Patient Demographics chosen. Read the requirements on the left before you upload.

{% endstep %}

{% 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.

How to map data from patient import CSV file into OutSmart - shows the mapping tool in the patient import process.

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.

After mapping the data, how do I continue the patient import - shows the preview mapping data results button in the process of importing patient data into OutSmart.

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.

How do I verify my mapping of patient data into OutSmart before I confirm the import - shows the confirmation mapping of a few sample patients before the actual import of patient data.

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