Main / Knowledge Base / Upload clients from a spreadsheet

Upload clients from a spreadsheet

11/9/2026

Upload clients from an XLSX spreadsheet or a CSV file to create your database or update existing clients.

Provide a first name for an individual and an organization name for an organization. Add other details as needed. Include a permanent external ID if you plan to update records later: without an ID, each upload creates a new client.

Uploading sites is described separately.

1. Upload the file

Open Addresses. Click Upload at the top of the page and select Clients to open the upload dialog.

Upload clients

Use the CSV file example link as a reference when preparing your spreadsheet. CSV files should use UTF-8 encoding.

Click Upload or drag your XLSX/CSV file into the dialog. After the file is read, the field mapping step opens.

2. Map the fields

Check how the file’s columns are mapped to Planado fields. Choose a field for each column you want to upload. The selected field appears to the right of each column name, and you can preview the column’s values.

Map client fields

Check automatic mapping carefully. Columns without a mapped field show a field selection placeholder. Assign a field to any column you want to upload; leave unnecessary columns unmapped.

Check the external ID and the client’s first name or organization name in particular. Click Continue.

3. Preview and choose an action

In Preview, check the data. Successful and Unsuccessful show the rows that passed validation and those with errors. Fix the file or mapping before submitting if you find errors.

Preview clients

Use change mapping to return to field mapping. The default action is Create and update. Use the arrow next to it to select Create or Update separately.

Choose the upload action

To update an existing client, provide the same external ID used when the client was created. Check the selected action and start the upload.

4. Check the upload result

Wait for processing to finish. The result dialog shows counts for all, created, updated, and unsuccessful records.

Client upload result

Click a client’s name in the result table to open their details. Check errors and open a few uploaded clients to make sure their data was transferred correctly.


If you need help, submit a ticket or email support@planado.app.

Still not sure? Test Planado out for yourself!

Sign up for your free trial and get full access to all features for 14 days. We will also customize Planado for your business absolutely free!
🇺🇸