Showing results for 
Search instead for 
Did you mean: 
Everything you need to know about banking in QuickBooks Online - Discover more
Level 2

Importing customer list

i have a list of my clients customers in a CSV format to be imported into QB, but the file has the first and second names in different columns, there is only one mapping option for name when i'm importing into QB. is there anyway for me to tell the system to put the two columns both into the name field?

QuickBooks Team

Importing customer list

Thanks for posting in Community Colin.


The fields are set in QuickBooks Online and when uploading can't be merged, you will need to edit the CSV file directly to include the two names in one column to be able to upload.



Not applicable

Importing customer list

hi @Colin_Four_Ferry ,

Consider using TPI for your case. You may create a command line to let it merged the columns.


Hope it helps.


Need to get in touch?

Contact us