Skip to main content

Import tips and best practices

A few habits prevent most import problems.

Before you upload​

  1. Start with 5 to 10 rows to test the whole journey.
  2. Follow the load order.
  3. Use the template and its dropdowns, and delete the sample rows.
  4. Save old .xls files as .xlsx or CSV UTF-8.
  5. Keep codes and keys unique, so the right record is matched.

Pick the right mode​

  • Add new only for a first load.
  • Add or update to correct and re-run. Running the same file twice updates the same records and duplicates nothing.
  • Update existing only for corrections to records you already have.

Pick a failure policy​

  • All or nothing for anything that touches money.
  • Partial success for large master-data migrations where you want to make progress and fix the stragglers.

Before you run​

  1. Check the New / Update / Rejected labels. Mostly Update on a fresh load means the key is matching existing records.
  2. Use Run a trial first.
  3. Remember that reversing cannot restore overwritten values.

:::info Why is my import waiting? Only one import per company runs at a time, and the import workers are shared by all companies. :::