Howto create custom csv file to upload into gmail contacts

I recently got the T-Mobile G1 phone and wanted to transfer my contacts from my old phone to the G1. The G1 syncs its contacts with gmail contacts, so I added them there. How I pulled my contacts from my old Motorola E815 phone into a CSV is a tale for another blog, but it was painful. Gmail has a page: http://mail.google.com/support/bin/answer.py?answer=12119 that's supposed to specify how to create a csv file suitable for upload to gmail, but I found it useless because it didn't clearly define the set of acceptable field names. In the end what worked for me was to first export a contact from gmail into a csv file in Outlook format. The first line of that file has all of the field names. I found that the gmail importer was robust to reordering of the field names and omitting field names. It looks like there isn't an easy way to merge these contacts uploaded with email contact entries that already exist.

For the record, here are the field names for Outlook's CSV format that gmail understands:

Name,E-mail Address,Notes,E-mail 2 Address,E-mail 3 Address,Mobile Phone,Pager,Company,Job Title,Home Phone,Home Phone 2,Home Fax,Home Address,Business Phone,Business Phone 2,Business Fax,Business Address,Other Phone,Other Fax,Other Address