Import your data

Move records from a spreadsheet or another system into ERPoida without retyping them.

7 stepsFor anyone allowed to add records

  1. Prepare a CSV file

    Export your data as CSV, with column headers in the first row and one record per row. Excel, Google Sheets and most business systems can save as CSV.

  2. Open the import

    Go to the object you want to fill, such as Companies or Products, and choose Import data. Drop the CSV file in, or browse for it.

    You need permission to add records to that object. A few objects cannot be added from an import yet; the import tells you which, and you add those on their own screen first.

  3. Match columns to fields

    For each column in your file, choose the field it imports into, create a new field for it, or leave it out. Example values from your file sit next to each column so you can check your choice.

  4. Update instead of duplicating

    Choose a matching field, such as an email address or a customer number. A row that matches an existing record updates it; the other rows are added. Each matching value must appear only once in the file.

  5. A column can point at records in another object, for example the company a contact belongs to. The import finds them by the field you pick.

  6. Check, then import

    Check rows shows how many records will be added, updated or left out, and flags problems such as a value that appears twice, before anything is saved. Then import the file.

  7. Save it as a template

    Importing the same kind of file again? Save the column setup as a template. A personal template is yours alone; a shared one is there for everyone in the workspace who can change that object.

Next steps

← All guides