Back

Excel Template ready to import Vendors

The Master Data Import Worksheet
Video 10/25
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Master Data Information" which is available at Microsoft AppSource. Click to visit AppSource. Master Data Information
Open Playlist
Presenter: Jesper Nielsen, Senior Consultant, Head of Onboarding, Team Manager BC

How to import vendors with the Excel sheet to your master data information worksheet?

In this video, I will go through the Excel sheet that you can use to import vendors with your master data information worksheet.

This is what happens in the video

We have the different fields in the table marked in up here in the And if they’re red, it means they are what we suggest as the minimum to fill out to get some valid data and if it has a gray background, it means it has an underlying table that it looks into.

I will start from the end and number is just a unique number for your vendor.

Name and name 2 are name of the vendor and additional name for the vendor.

Search name is a name that you can change according to the name, but if they are the same data you have in these two fields, you don’t need to fill it out because it automatically gets the data from the name field.

Address, address 2 again, address and an additional dress.