cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Importing Vendor/Customer list to QBO from Excel

Hi! I exported my vendor list from QB Desktop 2016 to an Excel spreadsheet. It did not export first and last names for each vendor since not all my vendors require first names: i.e. Capital One, (State) Dept. of Revenue, utility company, etc. When trying to import properly categorized spreadsheet to QBO, I am unable to go to the next step for it appears that the name field is required.   Is there a simple remedy for this?  Please share. Thanks!

Solved
Best answer 04-25-2019

Accepted Solutions
QuickBooks Team

Re: Importing Vendor/Customer list to QBO from Excel

Hello, @Stuart Thaler.

 

I'm here to help import your vendor list successfully to QuickBooks Online (QBO).

 

When importing contacts to QBO, please ensure that the columns of the Excel spreadsheet have the complete headers. Also, please make sure that there are no blank cells or other headers at the top of the spreadsheet.

 

If you can't still import the list, you really need to add the names on the Excel spreadsheet before importing.

 

To learn more, you may check these articles:

 

Please feel free to add a post/comment below if you have any other questions about importing vendor/customer list. I'll be always here to help you!

View solution in original post

1 Comment
QuickBooks Team

Re: Importing Vendor/Customer list to QBO from Excel

Hello, @Stuart Thaler.

 

I'm here to help import your vendor list successfully to QuickBooks Online (QBO).

 

When importing contacts to QBO, please ensure that the columns of the Excel spreadsheet have the complete headers. Also, please make sure that there are no blank cells or other headers at the top of the spreadsheet.

 

If you can't still import the list, you really need to add the names on the Excel spreadsheet before importing.

 

To learn more, you may check these articles:

 

Please feel free to add a post/comment below if you have any other questions about importing vendor/customer list. I'll be always here to help you!

View solution in original post

Need to get in touch?

Contact us