When you click Import in the Google Contacts website, one of the options will be CSV.
Once you've imported your contacts into your Google Contacts on the web, they'll sync automatically with your phone, as long as that's logged into the same Google account.