Fix import errors - Relaticle  

    [Importing data](https://relaticle.com/help/import)

 Fix import errors 
===================

What to do when an upload, mapping, or validation step fails — and how ambiguous dates are handled.

 Updated August 13, 2026

 Most import problems are one of four kinds — the file won't upload, a column won't map, values fail validation, or the import itself misbehaves. Find the symptom below; each fix is something you can do yourself.

[](#upload-problems "Permalink")Upload problems
-----------------------------------------------

ProblemFixFile too largeSplit into files under 10,000 rows eachInvalid formatRe-save as "CSV UTF-8" from ExcelUpload failsCheck your connection, then try a smaller file[](#mapping-problems "Permalink")Mapping problems
-------------------------------------------------

ProblemFixA column didn't auto-mapPick the field from the **Map To** dropdown yourselfA custom field is missing from the dropdownCheck the field's code in **Settings → Custom Fields**A required field shows redMap one of your CSV columns to it[](#validation-problems "Permalink")Validation problems
-------------------------------------------------------

ProblemFixInvalid emailCorrect the format: `user@domain.com`Invalid dateUse ISO, European, or American format consistentlyInvalid Record IDRe-export to get fresh IDsUnknown select optionUse the exact option label from the field's settingsIn the review step you can also **Fix** a value once to correct it across every row that has it, or **Skip** a value — the rows still import, with that one field left empty.

[](#ambiguous-dates "Permalink")Ambiguous dates
-----------------------------------------------

The wizard reads three date formats and detects which one a column uses:

FormatPatternExampleISOYYYY-MM-DD`2024-05-15`EuropeanDD/MM/YYYY`15/05/2024`AmericanMM/DD/YYYY`05/15/2024`When a day value is greater than 12 the format is unambiguous — `31/01/2024` can only be European. When both positions are 12 or less (`01/02/2024` — January 2 or February 1?), the wizard shows a warning and a format dropdown on that column: pick **European** or **American** to say which reading is correct. ISO dates are never ambiguous, which is why they're the safest format to export from other tools.

[](#import-problems "Permalink")Import problems
-----------------------------------------------

ProblemFixStuck at "Processing"Large imports run in the background — check back in a few minutesSome rows failedDownload the failed rows, fix them, re-import just thoseUnexpected duplicatesMap a unique column (email, domain, or ID) — see [Update existing records](/help/import/update-existing-records)[](#good-to-know "Permalink")Good to know
-----------------------------------------

- **There is no undo.** Test with a 5-10 row sample before the full file.
- **A failed import keeps its successful rows.** Fix and re-import only the downloaded failures.
- **One record type per file.** Importing people can still auto-create their companies if you match the Company relationship by Name.
- **Every run is logged.** The **Import History** page under your workspace name shows created, updated, skipped, and failed counts for each import.

 [  Edit this page on GitHub ](https://github.com/Relaticle/relaticle/edit/main/packages/Documentation/resources/content/help/import/fix-import-errors.md) [  Ask a question in Discord ](https://relaticle.com/discord)