Skip to main content
J
jbaenziger
March 12, 2025
Question

Extract shipping addresses into Excel for Mac

  • March 12, 2025
  • 1 reply
  • 0 views

Hello community

 

In QB desktop for Mac, I try to extract the shipping addresses from hundreds of drop ship orders. I can go into 

each specific order and copy/paste, but that's a never ending story. Is there a more efficient way?

 

Thanks!

Jurg

1 reply

J
JanbonN
March 12, 2025

Hello there, Jurg. You can customize and export your Sales by Ship to Address report to get the shipping address data. I'm here to provide the steps to do it.

 

Here's how to generate the report:

 

  1. Navigate to Reports and select Report Center.
  2. In the search field, type in Sales by Ship to Address and open the report.
  3. Click the Customize button.
  4. Make the desired modifications to ensure the report includes the data you need.
  5. Then, click the Export button and follow the on-screen prompts.

 

For more detailed information about creating, customizing, and exporting reports, please refer to these articles:

 

 

Additionally, you can memorize your reports to save your current changes for future use.

 

Should you have other questions or need further assistance extracting data in QuickBooks Desktop for Mac, please don't hesitate to return to this thread, Jurg. We're here to help. Have a great day ahead.

Terms & ConditionsAccessibility statement