While you can export your customer list to Excel, importing it back into QuickBooks will create duplicate profiles rather than overwriting existing data. To avoid these errors, I suggest manually editing the profiles one by one directly inside the system.
To start, go to All apps, select Customers & leads, and then open the customer profile, and click Edit to update the details. Once done, select the Save button.
Feel free to click the Reply button if you have other questions about QuickBooks.
