A Client Contact List Report .xlsx download used to be available with separate address, city, state, and zip code fields. What happened to that?

Currently, QuickBooks Online (QBO) exports the Client Contact List report with the entire address in a single field. This means exporting it to separate cell isn't possible. I can provide a solution on what you can do about this, Msingleton.

You can easily separate the city, state and code into individual cells in Excel after exporting the report. Once you're on the page, simply click the option outlined below to insert a cell. I've added a screenshot for your reference:

Additionally, you can also learn how to filter specific information to get the data you need when running reports. For more information, read this article for reference: Customize Reports in QuickBooks Online.

Let us know if you have any other questions when exporting reports. We'll always here to help everery step of the way.