Your CSV File will open in Google Sheets so we can correct a few export errors and you will need to match the correct column names with the data in those rows. Right Click on the File in your My Drive and Click Open With, then Select Google Sheets. Upload the.CSV file you saved from the Address book export to Google Drive. Give it a File Name and save it where you can find later.
In this video we will backup our contacts from the Thunderbird Addressbook, correct the columns of the CSV that it exports using Google Sheets and then restore them into Gmail / Google Contacts.Ĭhange the “Save as type” to Comma Separated.
