Put in Macro Window and run after copying Excel columns (oldname, newname) in clipboard

Use Excel columns in clipboard for renaming glyphs

from AppKit import NSPateboard, NSStringPboardType

myClipboard = NSPasteboard.generalPasteboard()
renameString = myClipboard.stringForType_(NSStringPboardType)
renameCount = 0

print "Processing: %s" % Font.familyName
print 

for renameLine in renameString.strip().splitlines():
	renameLine = renameLine.strip()
	if "\t" in renameLine:
		while "\t\t" in renameLine:
			renameLine = renameLine.replace("\t\t","\t")
		oldName,newName = renameLine.split("\t")[:]
		glyph = Font.glyphs[oldName]
		if not glyph:
			print "WARNING: '%s' not found (->'%s')" % (oldName,newName)
		else:
			glyph.name = newName
			renameCount += 1

print
print "Done. Renamed %i glyphs." % renameCount