Page Comparison - Importing contacts (v.8 vs v.9) - MYOB Business

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

To import contacts into MYOB

To import an accounts list into MYOB, the import file must:

be a text (TXT) file
be in tab-separated format
contain a header row for all mandatory fields
be under 25MB

To import contacts

Click your business name and choose Import and export data.

On the Import tab, for the Data type choose Contacts.

For the

Contact type, select Customer or Supplier.

Click Browse and locate the import file.

Click the import file then click Open.

For the Match contacts using, choose how you'll match imported contact information with existing contacts.

Choose the method for handling duplicate records.

Click Import.

To import contacts using a sample import file

For the

easiest import, work with a sample file. This also ensures the required information is entered in a format that's accepted by MYOB. This is handy if you've exported your contacts from another program or have the details in a spreadsheet.

We've provided a sample file which has every heading needed for an import - all you need to do is download the file, open it in Excel, add your contact information, then import it into MYOB.

Let's step you through it.

HTML Wrap

class	col span_3_of_5

You can import contacts (customers or suppliers) into MYOB instead of entering their details one at a time. This is handy if you have a list of contacts you've exported from another program or contained in a spreadsheet.

To ensure your import file is in the right format with all required information, we recommend using the sample import file we've provided below.

We'll step you through how to import a prepared file, as well as how to import using a sample import file.

UI Expand

title	To import contacts

UI Expand

title	To import contacts using a sample import file

UI Expand

title	1. Download and modify the sample file

Right-click the sample file for your country and save it to your Desktop: SampleContactsFile.txt
Open a blank workbook in Microsoft Excel.
Click and drag the downloaded sample template onto the the workbook. The file will open in Excel and the contents of the template will be displayed.
When looking at the file in Excel, note the following:
- the first cell contains parentheses (brackets) - these need to remain, as they indicate that the import file is from MYOB.
- the second row (beneath the row with the brackets) is labeled so you can work out what type of information is displayed in each column.
  Image Modified
Enter your data in each applicable column. Remember:
- each column in the import file represents a field in MYOB
- each row in the import file represents a different contact
- leave the brackets on the first row, and the headings on the second row.
When you're done, save the template as a text (.TXT) file. If you like, you can give the file a meaningful name, such as "Customer Import" or similar.
Image Modified

UI Expand

title	2. Import the prepared template

By importing the prepared template you'll add new contacts to MYOB, or update the details of existing contacts. Be sure this is what you want to do before proceeding.

Click your business name and choose Import and export data.
On the Import tab, for the Data type choose Contacts.
For the Contact type, select Customer or Supplier.
Click Browse and locate the import file.
Click the modified import file then click Open.
For the Match contacts using, choose how you'll match imported contact information with existing contacts. If you're importing new contacts, choose Company name or last name.
Choose the method for handling duplicate records.
Click Import.

HTML
</span>

HTML Wrap

width	15%
class	col span_1_of_5

HTML Wrap

float	left
class	col span_1_of_5

Panelbox

name	magenta
title	Related topics

HTML Wrap

class	sidebarlinks

Importing and exporting data

Importing items into MYOB Essentials

Adding customers

Adding suppliers

Page tree

Versions Compared

Old Version 8

New Version 9

Key

To import contacts into MYOB

To import contacts using a sample import file

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?