cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Import products and services from Excel

I have been trying to import my articles file from a QB version (desktop 2019 - same as I am using in this company) that I exported to an excel file - I have spent now 2 days trying and can not do this!

 

3 Comments
Community Backer ***

Re: Import products and services from Excel

hi @ Catterfield,

You should consider to use an importer tool like TPI. Hope it helps. 

QuickBooks Team

Re: Import products and services from Excel

I also agree with Fiat Lux, Catterfield. 

 

Aside from the importer tool, TPI, you can also use the IIF file format to import your list of products and services. 

 

Check out this article for more information about Improved IIF Import in QuickBooks 2019

 

Let me know if you need some help. I'll be around. 

BRC
Established Community Backer ***

Re: Import products and services from Excel

@Catterfield 

RE: I have been trying to import my articles file from a QB version (desktop 2019 - same as I am using in this company) that I exported to an excel file...

 

In this case, start over with the source company file and export the items to an IIF file.  Start at File | Utilities | Export | Lists to IIF files...

 

Then import that file into the destination company and you'll see all your items there.  Use the menu File | Utilities | Import | IIF files... to import the file.