How can I export my contact list on Mac desktop

Hi there, @printshop.

I can help you with exporting your contact list from QuickBooks Desktop (QBDT) for Mac to Excel.

To export your list to Excel, you can run a report (Customer Contact List, Vendor Contact List, or Employee Contact List), then export it to Excel.

Here's how:

1. Open your QBDT Mac.
2. Go to the Reports tab.
3. Look for the report you want to open (depending on the list you want to export).
   • Select Customer & Receivables, then Customer Contact List.
   • Vendors & Payables, then Vendor Contact List.
   • Employees & Payroll, then Employee Contact List.
4. From the reports page, click Export.
5. When the file opens, choose File, then it as CSV.

For more tips about managing reports in QuickBooks for Mac, you can download the QuickBooks Desktop Mac 2021 User's Guide, then proceed to page 223 to 224.

You can also review the topics from our help articles for additional resources in the future. Here's the link: Find QuickBooks help articles for QBDT for Mac.

If you have any other question about exporting your contact list, please let me know by adding a comment below. I'm more than happy to help. Cheers for more success!

Thanks for the clear and concise response Angelyn.

All the steps worked, other than Excel not reading the document. "This file is damaged or modified from its original format". When I export it automatically tries to open in Excel. I do have an older version.

Can I save another way?

Cheers

Thanks for getting back to us, @printshop.

I have some information about exporting a report to Excel. You can save a report as Excel workbooks (.xlsx), CSV spreadsheets, or PDFs. Since your Excel isn't updated, you'll want to save it as a PDF instead.

To do it, just go back to the report page in QuickBooks and click the Print drop-down at the top. Then, choose Save as PDF. See image below.

Additionally, you'll want to repair Microsoft Office. This way, you can export your reports to Excel without errors.

I'm also attaching this link about creating reports in QuickBooks for Mac. It has a list of different reports you can use based on what you need to see.

Don't hesitate to let me know if you still have questions or concerns with QuickBooks reports. I'll be around for you. Take care and have a great day ahead.