cancel
Showing results for 
Search instead for 
Did you mean: 
Treasurer Steve
Level 2

Exporting Employee List to Excel

When I export my employee list to Excel (as a CSV), the Address cell merges with the City, State and ZIP.  The City, State and Zip columns still exist.   How can I export into Excel and have the Address cell maintain what is shown in Quickbooks Employee Center - simply the street address?

2 Comments 2
BigRedConsulting
Community Champion

Exporting Employee List to Excel

You can't do it from the employee center, but you can create an employee contact list report and then include the Street1 and Street2 fields and then export that report to Excel.

 

Start at Reports | List | Employee Contact List.

Treasurer Steve
Level 2

Exporting Employee List to Excel

Worked great.  Thank you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us