Exporting Lists into Quickbooks

Jun 29, 2006 4 Replies

I was wondering if anyone exported a customer list into quickbooks from excel but the name and address did not go across but down for ex:



First Name phone address Fax city, State, zip email



This client I have have so many names I would hate for them to retype it. Thanks Susan



I was wondering if anyone exported a customer list into quickbooks from excel but the name and address did not go across but down for ex:

First Name phone address Fax city, State, zip email

This client I have have so many names I would hate for them to retype it. Thanks Susan

I cannot be sure exactly what you are asking from your email, but I am taking a guess.

I think what you need is to fix the file in Excel before "importing" into QB. Excel has a function called "Transpose" which allows you to take an array and make the old columns into rows and the old rows into columns. Try looking at the Excel help files regarding this function. If this is what you need and you need more help regarding this function, you can post to newsgroup "microsoft.public.excel.worksheet.functions".

Your client did not map columns correctly when importing.

forget original post, did not realize this was the format of name in Excel before import. Transpose is the solution.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required