# Student import errors and how to fix them

> Reading the red box, finding the row in your spreadsheet, and solving each message.

## What you will get

A corrected spreadsheet after a refused import. The good news comes first:

**When there is an error, nothing is saved.** Not even the students on the good
rows. There is no half-finished import, and you never have to hunt for who got
in and who did not.

## How to read the red box

It appears at the top of the second step, one line per problem.

![Red box with the validation errors notice and two errors, one on line 2 and one on line 3](/Apps/edupay/ajuda/importar-erros.png)
*The number is the line of the **file**, counting the header. "Linha 2" is the first student in the spreadsheet — the same number Excel shows down the side.*

Fix everything in the spreadsheet, save, click **Choose another file** and upload
again.

## The most common messages

**The email field is required**
The cell is empty in a spreadsheet where the school demands an email. Fill it
in, or drop the row and register that student by hand later.

**The birth date field must be a valid date**
The date is in a format the system does not recognise. It takes `2004-07-22`,
`22/07/2004` and `07/22/2004`. Anything else — a spelled-out month, a two-digit
year, dots instead of slashes — is refused.

**Invalid CPF**
The verification digits do not add up. Check the document; if your school
registers foreign students, the check can be turned off in **Settings › Student
Portal**.

**Duplicate login identifier in file**
Two rows with the same email (or the same ID, if login is by document). Decide
which one stays.

**Duplicate document in file**
Two rows with the same ID. Almost always the same student typed twice.

**The document number has already been taken**
That ID already belongs to a student at your school. If it is the same person,
drop the row: they are already registered.

## When the error list is enormous

The system stops listing after **100 problems**. A full box is nearly always one
error repeated on every row — a column mapped wrong, or a date format the whole
file uses.

Look at the first error and fix the cause, not the hundred rows.

## The error that never reaches the red box

**A repeated student is not an error.** If the spreadsheet holds people who are
already registered, the import goes through and the green summary counts them
under **Existing records preserved**. Nobody is duplicated and no existing record
is overwritten.

Worth knowing: re-importing the same spreadsheet is safe.

## How you know it worked

> [certo]
> The screen returns to the student list with the green summary banner in place
> of the red box. If **New students** shows the number you expected, you are
> done.

## If something goes wrong

> [erro]
> **You fixed it and the same error came back.** Check that you saved the right
> file — and that your spreadsheet program did not rebuild the old format on
> save.
>
> **An error mentions a field you did not map.** The system validates required
> fields even when they were left on **Ignore field**. Point it at the right
> column.
>
> **An error points at a row that looks blank.** Completely empty rows are
> skipped. If a space or a stray semicolon survived, the row is no longer empty —
> delete the whole row.


---

https://edupay.estudiosite.com/en/ajuda/day-to-day/student-import-errors
2026-08-05