Page Comparison - Importing contacts (v.2 vs v.3) - MYOB Business

HTML Wrap

class	section group

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

To import contacts into MYOB Essentials

Click your business name and choose Import/export data. The Import/export data page appears.
Image Removed
Click Import then select Contacts.
Image Removed
Select the type of contacts to be imported (Customers or Suppliers).
Click Browse. The Choose File to Upload window appears.
Select the file containing the contacts you want to import, then click Open.
Click Import. A window appears, displaying the number of contacts that were successfully imported.
Click OK.

Getting a "file format is not valid" message?

Check that the contacts you're importing aren't already in MYOB Essentials. Also, use the sample file provided above to ensure the import file is the correct format.

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

Let's step you through it.

HTML Wrap

class	col span_3_of_5

The Import Contacts feature allows you to import customer and supplier contacts into MYOB Essentials.

Contacts that already exist in MYOB Essentials will not be imported. However, if you import a supplier contact that matches an existing customer contact in MYOB Essentials, or a customer contact that matches an existing supplier contact, then the existing contact will be updated to become both a supplier and a customer.

Before you start

Before you import your contact information, make sure your file is in the right format, or has been exported with all the default options from MYOB AccountRight, BusinessBasics or AccountEdge. For more details, see Preparing to import from MYOB AccountRight v19 or earlier, BusinessBasics or AccountEdge and Preparing to import data from other sources.

Sample import files

For the easiest import, work with a Sample file. These files have every heading needed for an import - all you need to do is add the contact information!

UI Expand

title	Sample files

Sample files

The sample files below simplify the import process. You can open the downloaded file in any text editor or spreadsheet software like Excel (recommended) - but be careful not to overwrite the column headings.

Note that these files contain some sample data, and while you don't need to complete all the fields for a successful import, make sure not to delete any unused field headers or columns.

UI Text Box

size	medium
type	note

Tax ID No/GST ID No

The Tax ID No/GST ID No field in the sample contacts files below contains a single space as it cannot be left blank. This field represents the ABN (for Australian contacts) or the IRD/GST No (for New Zealand contacts). If this information isn't relevant for the contact, the Tax ID No/GST ID No field must contain a space.

See the tables below to identify which fields are mandatory and which are optional.

To download a sample file

Right-click on a link below and choose Save link as or Save target as, then choose where to download the file.

To open a sample file in Excel

Open Microsoft Excel and go to File > Open.
In the Files of type field, select All Files(*.*) and then locate and open the downloaded sample file.
When the Text Import Wizard appears, click Finish. The file contents will be displayed and you can now edit the cells as required.

UI Text Box

size	medium
type	warning

When you finish editing, you must click Yes to the message to save it as Text and continue using this format. This will ensure you'll be able to import the file into MYOB Essentials.

OK, let's step you through the import process.

UI Expand

expanded	true
title	To import contacts into MYOB Essentials

UI Text Box

size	medium
type	note

UI Expand

expanded	true
title	To import contacts

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
Select 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 2

New Version 3

Key

To import contacts into MYOB Essentials

Before you start

Sample import files

Sample files

To download a sample file

To open a sample file in Excel

To import contacts into MYOB

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?