How to Add Contacts to Gmail Using a CSV File Make a contact list in Excel by creating a new table with the following fields: “Email Address,” “Last Name” and “First Name.” Add All Your Contacts. Save the table as a .CSV file. Open Your Favorite Browser Go to Gmail.com Enter your User name and Password. Click Sign in to Login to Your Gmail Account Locate the Gmail Button at the top left of your Gmail page and click on it. Select Contacts from the Drop down menu. Click on Import Contacts. Click on Choose file. Locate the contact file on your hard drive and click open. Click Import. As you can see all the contacts has been imported in just a few seconds. This is How You Add Contacts to Gmail Using a CSV File.