To import and export supplier data in Invoice Office, open Accounts → Suppliers and use the Import / Export button. A bulk import adds your suppliers from a CSV or Excel file, so you don’t have to create them one by one. An export gives you your vendor list as an Excel, CSV or PDF file.
This guide covers preparing the file, running the import, fixing validation errors and exporting the list. To add a single supplier, see add a new supplier. For customers, see import customers, suppliers and products.

Before you import: an import only adds suppliers
The supplier import never changes existing suppliers. Every row becomes a new supplier, even if a supplier with that name is already in your account. If the Account number is already in use, the new supplier gets the next free number instead.
So don’t use an import to update suppliers, and don’t import the same file twice: you get duplicates. Change existing suppliers by hand. To clean up after a wrong import, delete the duplicates from the list.
Step 1 — Prepare your supplier import file
- On Accounts → Suppliers, click ⇄ (Import / Export) and choose Import.
- Choose CSV or Excel under Where is your data coming from?
- Not sure about the format? Click Download template and choose Excel or CSV.

Delete the example row from the template, Test Bedrijf. If you leave it in, it is imported as a supplier.
Required columns
Only the Name column is required, in every row. Leave Account number empty to number a supplier automatically.
These are the optional columns that are saved:
- Details: Account number, Is person account, VAT number, CoC Number, Email, Website, Phone office, Mobile, Fax, Description and Industry.
- Billing address: Billing street, Billing postal code, Billing city, Region, Billing state, Billing country code and Billing post office box.
- Shipping address: Shipping street, Shipping postal code, Shipping city, Shipping state, Shipping region and Shipping country code.
- Both addresses: Account name and Contact person.
These template columns are not saved: Bank account, Bank account number, Sales process type and Show in selectboxes. Add those details to the supplier by hand after the import.
Format your data
- Email must be a valid address, or the row gives an error.
- Billing country code and Shipping country code need the country’s name, not a code such as
GB. A value that isn’t recognised is left empty, without an error, so check the country on a few suppliers after the import. - Is person account takes Yes or No, spelled exactly like that. Anything else counts as No. With Yes, the supplier also gets a contact person with that name.
Have an export from other software? You can use it as it is. Columns such as Company, Phone, City or VAT are recognised, and you check the matches in Step 3.
Step 2 — Upload your supplier CSV or Excel file
Click Continue, then drag your file onto the upload area or click it to choose a file. You can also pick a file from Google Drive, Dropbox or OneDrive.

Step 3 — Map the columns
Invoice Office matches your columns to supplier fields and shows the result. The screen says product fields, because the wizard shares its wording with the product import. Check each row: the Source column from your file, a Sample value, and the field it goes to.
- Choose another field to correct a match. In the example, Supplier no isn’t recognised, so choose Account number.
- Choose — Do not import — for a column you don’t need.
- The Name field has a
*and must be matched to a column. - Click Save mapping to use these matches for your next import.

Click Continue.
Step 4 — Fix validation errors
Preview & validate checks every row before anything is saved. It shows Total rows, Valid and Errors. As long as there are errors, Start import is blocked: rows with errors are not skipped, so the whole file waits until they are fixed.
Open the Errors tab. Each line shows the row number in your file, the column and the problem.

| Error | What to do |
|---|---|
| Must be a valid email address | Correct the address in that row, or leave it empty. |
| Missing product name | The supplier’s Name is empty, despite the wording. Enter a name in that row, or delete the row. |
To fix them, change your file and save it. Click Back to the Upload step, remove the file and upload the new version.
Step 5 — Start the import
When Errors shows 0, check the rows on the Valid tab and click Start import. The tab shows a sample of your rows, not all of them.

Your suppliers are added straight away. The last screen says Your products are being imported in the background, but that is shared wording too: you don’t need to wait for a notification. Click Suppliers to check the result, or Import another file.

Need the contact people as well? Use Import supplier contacts in the menu on the left of the wizard after your suppliers are in.
Export your vendor list
- On Accounts → Suppliers, narrow the list down first if you only want some suppliers: use Search or Filter, or tick the rows.
- Click ⇄ (Import / Export) and choose Export.
- Choose the columns. On the left are the groups Supplier, Address and Contact. Click a field to add it, and click × to remove one. Number always comes first.
- Choose Excel, CSV or PDF and click Export. Save and export keeps your column choice for next time.

Large lists: if the export has more suppliers than your Number of rows per table setting, an Excel or CSV export runs in the background. You get a notification with a download link when the file is ready. A PDF only holds the first rows, up to that same number.
Using an export as a backup or for your accountant: an export isn’t a full copy of your supplier data. It holds the name, email, phone numbers, label, billing address and contact names. It has no bank details, website, description or shipping address. CoC Number and VAT number are in the window, but they stay out of the file even if you choose them. The country comes out as a code, which the import doesn’t recognise.
For filters and exporting other lists, see export your data.
Any doubts? Contact us and we will help.