Skip to content
Main / Knowledge Base / Upload clients from a spreadsheet

Upload clients from a spreadsheet

11/17/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, rows are treated as new clients, subject to any enabled duplicate checks.

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.


Rows sent for duplicate review

If your company has a duplicate control rule for client imports, a possible duplicate can be sent to the review queue. No client is created from that row until an authorized employee resolves the review.

Open the review queue at the top of Planado and compare the imported data with the matching client. Confirm that the record already exists, or allow a new record with an explanation. Do not upload the same row again while its review is pending.

Duplicate control


If you have questions about this or other Planado features, contact our support team: 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!
🇺🇸