Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
CSV import to My Smartsheet contacts
Comments
-
It is important to match the requirement EXACTLY.
The columns in your CSV file must be formatted correctly. The column names of A, B, and C should be ‘First Name’, ‘Last Name’, and ‘E-mail Address’, respectively. Exact spelling is important.
-
Same issue here. I created an excel file with the first name column, second name column, and email address column. Then saved it as a .csv file.
When importing it to SS, it fails saying that the file is not formatted correctly.The fix is to make sure that you actually have the column headers written out in your first row. So...
A1 = "First Name", B1= "Last Name", and C1= "Email"Row 2 is where your actual data begins. with "John", "Smith", "john.smith@abc.com"
-
Dear,
In french version it asks me to put for the column name
Pénom, Nom, E-mail It dosent work
I 've tried also
First Name Last Name Email
First Name Last Name E-mail
First Name Last Name Adress EmailNothing works ....same message
Any idea ?
Regards
-
[ENG] Hello JLE,
I've managed to find the solution (I use Smartsheet in french as well). The error message displayed when the import fails is indeed wrong : you have to create your CSV file by separating elements by commas (not semicolons) and use as headers " First Name,Last Name,Email ".
It worked for me this way, I join the screenshot of the template file I used, opened in both Excel 2016 and the notepad.
[FR] Bonjour JLE,
J'ai réussi à trouver le moyen d'importer les contacts via fichier CSV dans Smartsheet (sur version française également). Le message d'erreur affiché est effectivement erroné : le fichier à créer est un CSV dont les éléments doivent être séparés par des virgules (et non pas des points-virgules) et dont les en-têtes doivent être en anglais " First Name,Last Name,Email ".
Ce n'est probablement pas la seule bonne manière de faire mais en tout cas elle fonctionne dans mon cas. Je joins ici une capture d'écran de mon fichier correct, ouvert dans Excel 2016 et dans le bloc-note.
-
Great , I'll try
Thank you
-
You've got to be kidding me.. I need a description row in my 'csv' file?? Wow.. 45 minutes creating different csv versions and really didn't think I needed that in the first row. SmartSheet... I'm sure I'm an idiot.. but could ya BOLD the "must be named" part of that instruction.. all I saw was I needed columns of those values. If for nothing else I'm laughing at myself! Thanks
For those that are don't know what I'm talking about read my screenshot VERY carefully!
-
OK, I do this and all I get is the e-mail address, not the first and last name.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives