function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Flavius MihaiesFlavius Mihaies 

can I import contacts to salesforce from Google sheets?

Good afternoon, everyone! Hope you are safe and well. May I seek your kind advice, can I import contacts to salesforce from Google sheets? I have drop-downs and checkboxes in Sheets that don't carry through when I download as CSV and open in Excel, which I assume means it won't carry through to Salesforce when I upload my contacts? Many thanks! 
AbhishekAbhishek (Salesforce Developers) 
>>Go to the 'contacts tab' and then 'tools'.

>>Then select the 'Import my Accounts and Contacts' option.

>>On the Import Wizard click 'start'.

>>Select 'other data source' then click next.

>>Locate your file and then click next again. At this point, you'll be able to customize data fields. ...

>>Click 'Import Now'.

For further reference,  ( can check this too.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Lambert AnnettaLambert Annetta
Thanks for the solution I have the exact same problem. Have tried a variety of things
Thanks to giving the solution i will recommend your post to others Download iMessage for PC (
John KlokJohn Klok
Hello Flavius,

You can follow this step for import contact data from google sheet to salesforce.

Kindly mark this as solved if the reply was helpful.

Flavius MihaiesFlavius Mihaies
Hi, dear Abhishek - I profusely apologize for the delay. I was traveling but this is no excuse. Thank you so much for your kind help. I apologize for not being clear. Creating the new fields in Salesforce seems to work well, and the issue that I am facing is that contacts in my Google sheet already have dropdown values in the new fields I created, but they don't translate over to Salesforce. I am happy to jump on a quick call and screenshare if helpful. Thank you so much again, Flavius
Flavius MihaiesFlavius Mihaies
Hi, dear John - I profusely apologize for the delay. I was traveling but this is no excuse. Thank you so much. I apologize for not being clear. A few contacts already have selected checkbox items in the google sheet that do not translate to Salesforce. The support resource from Google does not mention this use case. I hope that you are safe and well, Flavius
Michael TomarMichael Tomar
Yeah, you can! Skyvia provides a convenient way to load data from Google Sheets to Salesforce ( You can do it without any coding directly in your browser.