Summary
Update customer records in Sage Accounting using a CSV file.
Resolution
Export and update your customers
- Go to Contacts.
- Export customers to a CSV file.
- Open the exported file.
- Update the details you want to change.
- Save the file.
To add a new record, create a new row and leave the Unique ID column blank.
Import your updated file
- Go to Contacts.
- Select Update customers or Update suppliers.
- Drag and drop your file, or select Choose to browse for it.
- Choose how Sage Accounting treats empty cells.
- Select Continue, then review the summary.
- Select Start import.
TIP: You can also update suppliers using a CSV.