Import Your Legacy Business Data into Dynamics NAV

When you sign up for Dynamics NAV, you can choose to create an empty company so that you can upload your own data and to test your new Dynamics NAV company. Depending on the finance solution that your business uses today, you can transfer information about customers, vendors, inventory, and bank accounts.

From Home, you can start an assisted setup guide that helps you transfer the business data from an Excel file or from other formats. The type of files you can upload depends on the extensions that are available. For example, you can migrate data from QuickBooks because Dynamics NAV includes an extension that handles the conversion from QuickBooks. If you want to migrate data from other finance solutions, you must either check if an extension is available for that solution or import from Excel.

Dynamics NAV includes templates for accounts, customers, vendors, and inventory items that you can choose to apply when you import your data.

Importing Data from QuickBooks or Dynamics GP

If your business uses QuickBooks or Dynamics GP today, you can export the relevant information to a file. You can then open the assisted setup guide to transfer the data. For example, if your file includes customers and vendors, you can choose to transfer only the customer data. You can then transfer the rest of the information later.

The assisted setup includes an option to change the default configuration of the transfer, but we recommend that you only enter this advanced setup if you are familiar with database tables. In the vast majority of businesses, the default mapping from QuickBooks or Dynamics GP to Dynamics NAV will transfer the information that you want.

For more information, see QuickBooks Desktop Data Migration, QuickBooks Online Data Migration, or Dynamics GP Data Migration.

Importing Data from Configuration Packages

Dynamics NAV includes a configuration package that you can export to Excel and set up your data there. Then, you can import the data from Excel again. The package consists of 27 tables, including master data such as customers, vendors, items, and accounts, other basic setup tables such as shipping methods, and transactions tables such as sales header and lines.


Working with configuration packages is advanced functionality, and we recommend that you contact your administrator. For more information, see Importing Data from Legacy Accounting Software using a Configuration Package.

See Also

Importing Data from Legacy Accounting Software using a Configuration Package
QuickBooks Desktop Data Migration
QuickBooks Online Data Migration
Dynamics GP Data Migration
Customizing Dynamics NAV Using Extensions
Setting Up Dynamics NAV

© 2017 Microsoft. All rights reserved.