CSV Template

Suppliers,ready for MRPeasy's vendor import.

Collect suppliers under the names of MRPeasy's vendor import fields, with company names, vendor numbers, contact details, lead times and payment terms checked before the CSV goes into Procurement.

MRPeasy's field namesRepeated vendors flaggedTry it free

MRPeasy Vendors

Try the template with up to 3 rows

What You'll Collect

Company name & vendor number

String
*Required

A company name for every vendor, and a unique vendor number if you use your own codes.

Contact details

Email
*Required

Contact person, phone, fax, email and website, checked as they are typed.

Address

String
*Required

The address in one free-text cell, as MRPeasy's simplest address column.

Currency & tax rate

String
*Required

The vendor's default currency and tax rate.

Lead time

Number
*Required

Default lead time in whole business days.

Payment terms

Enum
*Required

Payment period in days, and 0 (from invoice date) or 10 (from end of invoice month).

Need more than three rows?

Collect every supplier's details.

The free template is limited to three rows so you can try the workflow. Create your own form to send to each buyer or supplier, and get vendor details back in one file instead of a different spreadsheet from every source.

Create your own form

MRPeasy's field names

Company name, Vendor number, Default lead time in days and the rest, so MRPeasy maps the columns for you.

Checked as they type

Repeated company names and vendor numbers, email addresses, websites and payment period types are checked.

Your own fields

Add a certification expiry or a quality rating to your own form.

Up to 1,000 rows

Well inside MRPeasy's 3,000 lines per upload.

How it works

From the supplier list to MRPeasy in three steps.

01

Collect

Import a supplier list, or send the form to each buyer.

02

Complete

One vendor per row. Repeated names, bad emails and websites without https:// are highlighted.

03

Download and import

Download the CSV and import it in Procurement, Vendors, ticking that the first row is a heading, then check the column mapping.

Why use a form?

A repeated vendor number is silently skipped.

When a vendor number already exists, MRPeasy ignores that row instead of reporting an error, so a vendor can go missing without anyone noticing. A company typed two ways, in the items import, creates a second vendor.

A form flags repeated names and numbers as they are entered, so every supplier makes it in.

Vendor numbers that already exist

MRPeasy ignores the row. Each number is used once in your file and checked against MRPeasy.

Payment period type

Only 0 (from the invoice date) and 10 (from the end of the invoice month) are valid.

Lead times in the wrong form

Lead time is a whole number of business days, not "2 weeks".

MRPeasy vendors import template

How MRPeasy imports vendors

MRPeasy keeps your suppliers in Procurement, Vendors, and can import many at once from a CSV file. As with items, you match each column to a vendor field on screen instead of following a fixed template.

Only the company name is required. A vendor number is optional: if you give one and a vendor with that number already exists, the row is ignored when creating vendors. You can also supply a contact person, phone, fax, email, website, an address, notes, currency, tax rate, default lead time in business days and a payment period.

The payment period type is 0 to count the days from the invoice date or 10 to count from the end of the invoice month. MRPeasy takes up to 3,000 lines per upload and returns a skip file listing any rows it couldn't import. The manual recommends backing up your database first.

This template uses those field names and checks each column as it's filled in. It uses the single free-text address column, and leaves out the structured address columns and custom fields. To give an item its own vendor terms, use the MRPeasy items template.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by MRPeasy. MRPeasy is a trademark of its owner. Fields as described in MRPeasy's user manual, November 2026.