Once Quanda finishes the contact import, it shows the Import results: how many contacts and companies it imported, how many contacts it updated, how many rows it skipped because of duplicate e-mails and how many rows contained an error. The results arrive by e-mail and you also find them at the very bottom of the Contacts / Bulk Contacts Import page in the Results of the last import section.

Import Results page in Quanda: green bar confirming the import is complete, blue summary with the numbers of imported contacts and companies, skipped and incorrect records and the import date, below it the error table with the columns Error in the line number, Imported to, Imported from and Value and the Print and Close → Contacts buttons
Import results with the table of faulty rows.

What the import results contain

  • Imported contacts and companies: new records the import created.
  • Updated contacts: contacts that were already in Quanda and where the import added or overwrote data according to the chosen priority.
  • Skipped contacts: rows with an e-mail address that repeats in the file or already exists in Quanda while you gave priority to the existing data. Every contact in Quanda has a unique e-mail, so duplicates are not loaded.
  • Faulty records: rows that could not be imported, with a detailed error table.
  • Date and time of the import start and completion. The Print button prints the results, the Close → Contacts button takes you to the contact list.

How to read the error table

When some contacts could not be imported, you find a table with a detailed list below the results. Each row shows:

  • the row number in the file you imported the contacts from,
  • the column of the file the value was read from,
  • the field in Quanda the value was meant for,
  • the faulty value, for example an invalid e-mail address or a date in the wrong format.

How to fix the errors

  1. When you see just a handful of faulty records, add or correct these contacts by hand directly in Quanda.
  2. When there are more errors, correct the data in the source file and repeat the import. Quanda recognises already imported contacts by their e-mail and does not duplicate them.
  3. When you got the file by exporting from a CRM, accounting or other program, correct the data there as well, so that the next export is fine. How to prepare the file is described in the article Export of contacts and preparation for their import.
  4. When accented characters display incorrectly after the import, the guide to fixing the encoding will help.

Do you have questions? We will be happy to answer them. Just contact our customer support at +420 605 163 892, e-mail: support@onquanda.com.

Frequently asked questions

When the import finishes, they arrive by e-mail and you also find them at the very bottom of the Contacts, Bulk Contacts Import page in the Results of the last import section.

Most often because of a duplicate e-mail address. When the same e-mail repeats in the file or already exists in Quanda and you gave priority to existing contacts during the import, Quanda skips the row. Every contact in Quanda has a unique e-mail.

It points to the row in the file you imported the contacts from. The other columns show which column of the file the value was read from, which field in Quanda it was meant for and which value was faulty.

Fix or add a handful of errors by hand directly in Quanda. With a larger number of errors, correct the data in the source file and repeat the import, Quanda recognises already imported contacts by their e-mail and does not duplicate them.