There are two ways to do this:
1. You can do a mass edit by exporting the sheet as an .xls or .csv file, fill in the new field, and then import the file back if you have existing data. Don't forget to click on Renew data for the Import policy step. Learn more about importing in our documentation here.