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.
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.
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.
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.
Link related records
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.
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.
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.
Import your data
Move records from a spreadsheet or another system into ERPoida without retyping them.
7 stepsFor anyone allowed to add records

