Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
amazingmechanicalservices
Level 1

When importing customer list from excel I only get the info from the first row of cells

I save the customer list from my old QBs account on excel but when I go to update my customer list on my new QB I only receive part of the name cell and nothing else

1 Comment 1
Anonymous
Not applicable

When importing customer list from excel I only get the info from the first row of cells

We can review the file you have imported into QuickBooks Online (QBO), Amazing. 

 

You mentioned that you have saved this list from your older QuickBooks accounts. Therefore, let's ensure we match the format to the recent one when importing them. The application depends on what data you imported, and mapping your file correctly helps the application read the data.

 

Here's a snapshot of how the fields should be mapped:

format.png

format 2.png

 

I'll provide an article outlining best practices for importing and details on the contact fields that will be included: Which contact fields are imported from Excel?

 

I always have your back if you need additional assistance importing data into QuickBooks. Just click reply to start posting them here. Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us