How to process a Google contacts .csv export in excel

Google contacts provides an easy way to export your contacts to csv (for details on how to export have a look at How to export Google contacts to CSV).
With a bit of data manipulation this gives you a great opportunity to be able to edit your contacts directly in Excel, allowing you to rapidly make bulk changes to your contacts. This is much faster than manually editing one contact at a time from Google’s interface.








