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.

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.

• Right-click this link and save the file: Download a sample Items file (Australia) (ensure the file is saved with the name ITEM.txt)
• Right-click this link and save the file:   Download a sample Items file (New Zealand) (ensure the file is saved with the name ITEMNZ.txt)

To open a sample file in Excel

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

To import items into MYOB Essentials

1. In MYOB Essentials, click your business name and choose Import/Export data. The Import/export data page appears.
2. Click the Items option.
3. Click Browse. The File Upload window appears.
4. Select the file containing the items you want to import, then click Open.
5. Click Import. The Item Code Mapping window appears.
6. Fill any fields that have not imported including buying price, account numbers and tax codes.
7. When you have allocated tax codes, accounts and a buying price to each of the items, click Save. A window appears, displaying the number of items that were successfully imported.
8. Click OK.