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, 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.

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.
If you need help, submit a ticket or email support@planado.app.