Cameron's Thoughts
Archives
Gmail

Sending Your Opera Contacts to GMail

Now that GMail has support for importing your contact list, it's now time to upload your address book to GMail from Opera.
But, GMail currently only imports CSV (comma separated values) format files. Not a big deal as most programs work with this format, but Opera doesn't export to CSV.
Fortunately, there is a web-based tool that will convert Opera's format to CSV format. Address book conversion: ADR to TAB or CSV-separated will convert the .ADR Opera address book format to CSV or tab separated files. What you need to do is either locate where your address book is located on your hard drive, like the site mentions, or even easier, just go to the File Menu and choose File-->Export-->Opera contacts. Then save the contact list somewhere (probably not a bad idea to have a backup anyway). Then upload the file to that site, choose 'Comma seperated' then click 'Send File'. You will be prompted to save a .php file. Save that, then rename it to something.csv.
But, GMail won't take this file exactly as it comes. One little edit needs to be made. If you view GMail's info on how to import contacts, you will see that the CSV file needs to have a header, which isn't included when you convert using the website above. Don't worry, this step is simple. Just open the CSV file in your favorite spreadsheet app, like Excel, or my favorite, OpenOffice.org. Then add a row to the beginning of the file. The first column should say 'Name' and the second column should say 'Email Address'.
Then simply save, go to GMail, open your contacts, then click 'Import Contacts' and upload this CSV file. Much easier than adding all those by hand, unless you only know two or three people.