//email-import-header function formatAddresses() { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); var newData = []; for (var i=0, len=data.length; i',''); var str2=str1.split('<'); newData.push(str2); } } sheet.clearContents(); sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData); } function onOpen() { var ui = SpreadsheetApp.getUi(); // Or DocumentApp or FormApp. ui.createMenu('Cleanup contacts from email header') .addItem('Format and convert from columns to rows!', 'formatAddresses') .addToUi(); }