- Click Batch Update
- Copy the text that you see on that page
- Paste it into spreadsheet
- Then, modify the data to match what it should be.
- Copy from spreadsheet and paste back into Manager
- Click Next
- Review the list of changes. It should only show the columns modified that you tried to modify in the spreadsheet.
- Click Batch Update if you’re happy.
Note: Do not use your original spreadsheet. Create a new spreadsheet (or new tab on existing spreadsheet) and use the data copied from Manager screen if you’re doing a Batch Update.