How to Transfer Addresses From UPS to QuickBooks

While your online UPS address book is essential to shipping out products to clients and consumers, Intuit's QuickBook program can help you manage or merge your UPS address book with your business's other records. UPS's export feature and QuickBook's import feature make the transfer process completely painless.

Instructions

1. Log into your UPS account and then click on the "Address Book" heading. Select the "Export Addresses" option in the address book. Save the address book file to your desktop.

2. Launch QuickBooks. Click on the program's "File" heading, navigate down the File menu to the "Utilities" heading, navigate over to the "Import" heading and then click on the "Excel Files" option.

3. Click on the "Browse" button, located under the "Set Up Import" tab, when the "Import a file" menu appears.

4. Click the "Import" button to import the addresses.

References

• UPS: How do I import or export addresses for My UPS Address Book?
• Intuit: Import Excel and comma-separated values files - Import from Excel and CSV Manual