How to upload multiple vendors to your Melio account

  • Updated

It's easy to get all your vendors’ details into your Melio vendors list in one go. When you import multiple vendors, you can add company names, contact names, email addresses and phone numbers. We’ll provide you with a .csv template to download and fill in vendors’ details to make it super simple.

 

Here’s how to do it:

1. Go to the Vendors tab, and click Add vendor.

2. Click Import Vendors.

Add_a_new_vendor_-_NEW.jpg

 

3. Click Download in step 01 to get our .csv template.

Import_multiple_vendors_NEW.jpg

 

4. The .csv file will download to the chosen location on your desktop. Open and fill in your vendors’ details.

NOTE: Don’t change the header titles (row 1) of the sheet.

Your .csv file must include the same header titles included in our template: 

  • Company name (required) 
  • Email address 
  • Contact name
  • Phone number

Vendors_list_template.jpg

5. Save this sheet as a .csv file on your desktop. Be careful not to change the file format as the import won’t work. 

6. Return to Melio in your browser window. 

7. Click Upload .csv file, and select the .csv file you just saved. 

Import_.csv_file_NEW.jpg

 

8. Once you’ve reviewed your vendor list to check every field is filled in, and details are correct, click Confirm and save.

Review_and_confirm_NEW.jpg

 

That's it! You’ll get confirmation that your vendors have been imported successfully and can view your new contacts in Vendors.

Multiple_Vendors_6.jpg

 

Error messages that you might see

Error: Company name is required. Rows can’t be added without one. 

How to fix this: Make sure every row has the company name filled in.

Company_name_required.png

 

Error: This company name already exists. Vendors with duplicate names won’t be added.
How to fix this: Open your Melio account in a separate window and check if the company name already exists in your contacts list. If it does, that entire row won’t be imported.  To solve this, simply update the company’s information directly in your contacts list.

company_name_already_exists.jpg

 

Error: Incorrect email format. You can edit it later or upload a new file.
How to fix this: Check the email address carefully - emails that are not in the correct format (like example@example.com) won’t be saved. To fix this, add the correct email address in Melio contacts once the upload is finished.

Email_format_wrong.png

TIP: Editing an existing vendor.

Edit an existing vendor in Xero. On the next sync, the vendor’s details will be updated in Melio as well.

 

 

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request