🡠 Back

What to check before importing

Reading time
1 min
Data
October 27, 2026
afrus.ai
Learn how to prepare your file before importing it into AFRUS to avoid errors and duplicates.
In this article
+

About the file

  • Use only the first sheet. AFRUS only reads the first sheet of the Excel file.
  • The first row must have the column titles.
  • Write dates as day/month/year, for example 25/10/2026.

Required data

  • Leads: email and name.
  • Transacciones (donations): amount (numbers only), email and name.

If the email is missing, the screen lets you continue, but every row fails.

Repeated people and donations

  • AFRUS recognizes each person by their email. If they exist, they are updated; if not, they are created.
  • Each row creates a new donation. If you upload the same file twice, the donations are duplicated.

Contact permissions

When importing, AFRUS marks each person as accepting communications on all channels, even if they had unsubscribed before. Include only people who gave you their permission.

Frequently asked questions

How do I write phone numbers and document type?

Phone numbers must include the country code and the "+" sign. For the document type, write the matching number:

  • National Identification Document: 4
  • CPF: 8 (Brazil)
  • CNPJ: 9
  • NIE: 13 (Spain)
  • NIF: 14 (Spain)
  • Passport: 1
  • CĂ©dula de ciudadanĂ­a: 16
  • CĂ©dula de extranjerĂ­a: 17
  • RUC: 18
In this article
âś•

Related Tutorials

Data
October 27, 2026
What the Presets, Año and Mes filters of the General report are for
Learn how to choose the period of the Reporte general with the Presets, Año (Year) and Mes (Month) filters.
Data
October 27, 2026
What the 3 icons of each tag do
Learn how to use each tag's icons: see the people who have it, edit it and delete it.
Data
October 27, 2026
What Downloads is for
Learn what Downloads is for: getting your exports, knowing when they're ready and keeping them in one place.
Data
October 27, 2026
What the Reporte general (General report) is
Learn what the Reporte general is: the dashboard with your organization's most important numbers in one place.