> ## Documentation Index
> Fetch the complete documentation index at: https://docs.routiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Import a spreadsheet

> No practice software? Upload a CSV of patients so Robyn can work out who's due back.

If your clinic doesn't use Cliniko or PracSuite, you can upload a list of patients instead. The app asks for "A CSV with a name, a mobile number, and the date they last came in. You choose what each column means, and nothing is imported until you say so."

<Note>
  A spreadsheet has no diary, so Robyn can't book from it. She uses it to work out who's due back and to draft their texts in the Message Queue.
</Note>

## Before you start

* You need to be an owner or admin.
* Save your list as a CSV file. Excel files won't open: save as CSV first.
* Up to 20,000 rows and 8 MB.
* You can't upload a spreadsheet while Cliniko, PracSuite or Routiq Demo is connected.

## Import your list

Open **Integrations**, then **A spreadsheet**. You can also press **Upload a spreadsheet** in the **Set up** card on Home.

<Steps>
  <Step title="Upload">
    Drop your file where it says "Drop your patient export here", or pick it from your computer. Nothing is imported yet.
  </Step>

  <Step title="Match the columns">
    Tell Robyn what each column holds. She suggests matches first, so check each one. Any column she doesn't recognise says **What is this?**. Pick what it means, or leave it. Nothing imports on a guess.
  </Step>

  <Step title="Check">
    Robyn shows how many people will be imported, how many are ready to text, and how many come with a note, such as a missing mobile. When it looks right, press the **Import** button. It shows the count, for example "Import 1,284".
  </Step>
</Steps>

You'll see how many patients were imported.

## Columns Robyn understands

| Column | Notes |
| - | - |
| First name, Last name or Full name | One name is enough. |
| Mobile | Needed to text anyone. |
| Last visit | Needed to work out who's due back. |
| Email, Date of birth | Optional. |
| Visits so far, Appointment type, Practitioner | Optional. They help Robyn understand each patient. |
| Appointment price, Total spent | Optional. Appointment price sets the price of each type. |
| Do not contact | Optional. Robyn won't text these people. |

## Uploading a new version

An upload replaces the whole list. It doesn't add to it. Before you import, Robyn tells you how many people in her list aren't in the new file. "Importing stops them being contacted."

To upload a new version, open **A spreadsheet** on the Integrations page, press **Disconnect**, then import the new file.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.