View original (French)

Transforming commas to tabs in Excel

Solved
juliepa -  
 Boooksy -
Hello,

I have a file exported from a website in EXCEL that has a single column and many rows, each row consisting of a list of Last Name, First Name, postal code, email separated by commas. How can I get a list with multiple columns in Excel? One column for names, one for first names, etc.

Thank you!

Configuration: Mac OS X / Safari 531.22.7

4 réponses

Réponse 1 / 4
jee pee Posted messages 31912 Registration date   Status Modérateur Last intervention   9 947
 
Hello,

Your text file should have a .txt extension.

In Excel, you open it by selecting file type *.* to allow you to see your .txt file, you open your file and then Excel should offer to convert the file.

Choose type "delimited" next and check "comma" as the separator.

You should then find your data in columns in an Excel sheet.

Best regards

--
A stranger is a friend you haven't met yet.
13
Boooksy
 
Thank you for the tip! :)
0
Réponse 2 / 4
g Posted messages 1285 Status Membre 577
 
Hello,

Menu Data > External Data... > Import Data.

Have a nice day.
2
Réponse 3 / 4
ofardeau
 
Je pose la question inverse, comment transformer un fichier .txt séparé par tabulation en un fichier séparé par des virgules ?
0
malaik5 Posted messages 259 Registration date   Status Membre Last intervention   33
 
Your question is odd, but anyway,
you open your file, go to edit --> replace --> first character = tabulation; second character = ,
0
Réponse 4 / 4
ofardeau
 
I can understand that it seems weird. To explain everything, I have a customer database in Excel format (table) and with one of Facebook's options, it is possible to send emails to people who are not in your contacts. To do this, Facebook requires the addresses to be separated by commas.
Otherwise, I have opened my original .txt file (also in table format) which I imported into Excel, but I don't see the editing option there?
Best regards to you and thank you again for your first response.
0