NOTE: To find out what data you can import and for help with preparing your file, look at our data import article.

Import your data file

1. On the menu bar, click File then click Import.
2. If required, click Backup to back up your data, then once complete, click Next.
3. In the Data type window, select the type of data you want to import then click Next.
4. In the Data source window, select the format of the data you're importing.
5. If the first row of your data contains headings, select the First row contains headings checkbox.
6. Click Browse, locate and select the file to import, then click Open.
7. If your import file contains multiple worksheets, choose the required worksheet from the drop-down list.
8. Click Next. To link the imported data to the correct fields, complete the Imported field column as required, choosing the field from the drop-down list. Compulsory fields show with an asterisk.
   • If required, you can use the Load Map and Save Map options to import the default or previously saved mappings.
9. Once you've selected the required fields, click Next, check the summary information is correct, then click Import or Finish.

If the import is successful, a list of transactions imported appears in the Record Imported pane. Click Close.

If the import is unsuccessful, a list of import errors appear in the Records, not the Imported pane. Click Edit import to amend the original import file, click Close, then attempt to import again.

[BCB:19:UK - Sales message :ECB]