Skip to main content

Customer Management

How to Import and Export Supplier Data

Import your supplier list into Invoice Office via CSV or XLS, or export all supplier data for backup, migration or sharing with your accountant.

Updated 8 min read

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.

The Invoice Office suppliers list with six suppliers and the Import / Export menu open on Import, Export and Trash; the ⇄ button, Import and Export are outlined in red

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

  1. On Accounts → Suppliers, click ⇄ (Import / Export) and choose Import.
  2. Choose CSV or Excel under Where is your data coming from?
  3. Not sure about the format? Click Download template and choose Excel or CSV.
The first step of the Import suppliers wizard, Where is your data coming from, with the CSV card selected, an Excel card and the Download template menu open on Excel and CSV; the Download template button is outlined in red

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.

The Upload step of the Import suppliers wizard with a drag and drop area for CSV and XLSX files, outlined in red

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.
The Map your columns step of the Import suppliers wizard with 6 auto-matched columns: Company to Name, Email, Phone to Phone office, City to Billing city, Country to Billing country code and VAT to VAT number, and Supplier no set to Do not import; its dropdown and Save mapping are outlined in red

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.

The Preview and validate step of the Import suppliers wizard with 6 total rows, 4 valid and 2 errors; the Errors tab lists row 4 Email sales(at)proseware Must be a valid email address and row 7 Name Missing product name, the list is outlined in red, and Start import is greyed out
ErrorWhat to do
Must be a valid email addressCorrect the address in that row, or leave it empty.
Missing product nameThe 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.

The Preview and validate step with 6 total rows, 6 valid and 0 errors, listing six suppliers with their name, email, phone office and city; the Start import button is outlined in red

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.

The Done step of the Import suppliers wizard with the message Import started! and the buttons Suppliers and 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

  1. On Accounts → Suppliers, narrow the list down first if you only want some suppliers: use Search or Filter, or tick the rows.
  2. Click ⇄ (Import / Export) and choose Export.
  3. 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.
  4. Choose Excel, CSV or PDF and click Export. Save and export keeps your column choice for next time.
The Export window for suppliers with the Supplier, Address and Contact groups on the left, the Supplier fields in the middle and the chosen columns on the right; the format set to Excel and the Export button are outlined in red

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.

Was this article helpful?

If something is missing or did not work as described, tell us and we will fix the article.

Try it in Invoice Office

Create a free account to follow these steps yourself, or log in if you already have one.