Upload clients from a spreadsheet
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.

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.

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.

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.

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.

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.
If you have questions about this or other Planado features, contact our support team: support@planado.app.