Skip to content
Documentation
DropUI homepage
Topics

Import contacts from a file

Have a contact spreadsheet you want to move into DropUI without retyping it? Prepare the file and inspect its preview first. Records reach your contact list only after DropUI approves the import and processing finishes.

Prepare a small test file

Start with a few representative rows: a new person, an existing contact and a record with consent. Keep the source so you can explain where the data came from.

  • Supported formats are CSV and Excel (.xlsx), up to 10 MB and 10,000 rows.
  • Put column names in the first row. A simple layout is name, email, phone. Each row needs a recognizable email address or phone number.
  • Store phone numbers as text with the country calling code. If it is missing, add a country column, such as PL. Check that the spreadsheet has not removed a plus sign or leading zeros.
  • The import reads names, email, phone and selected consent decisions. An extra comment or order-number column does not automatically become a contact-profile field.

Download the example CSV from the import form to check the layout. Its sample rows are not your customer data.

Upload the file

Open Contacts -> Contacts -> Import and choose the file. To assign people to a segment, select its contact base and a manual segment, or enter a new segment name. Lists and segments have different roles.

The start of a demo import, showing formats, limits and supported contact data.

Import marketing consents is separate. Without it, you import contact details rather than permission to send. If the file contains documented decisions, configure the consent import.

Review before submitting

Select Build preview. Compare the parsed emails and phones with the source, then check new, updated, invalid and duplicate rows.

The demo preview includes a new person, an update, a duplicate and an invalid email. It is not a completed import.

Invalid or skipped rows do not become new contacts. Correct conflicting email and phone assignments at the source; DropUI does not automatically merge those people. Return to the file and build a fresh preview if its layout is wrong.

Submit and check the outcome

Describe the source, confirm your authorization to use the data and select Send for review. This locks the file and preview. Submission is a review step, not confirmation that contacts were added.

Return through Recent imports. Read the status and any rejection or error explanation. After completion, compare the report and a few profiles in the selected list. Do not upload the same file again just because review is still in progress.

Completed local demo import. The report lets you compare the outcome with the preview.

For an unexpected result, give us the filename, status and affected row number. A single relevant example is usually more useful than sending the entire list in a message.

Have questions after reading this guide?

Get in touch. We’ll answer your questions and help you with setup, free of charge.

Patryk Surmacz

I’ll walk you through the settings, step by step.