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 answers

  1.
    jee pee Posted messages 31884 Registration date   Status Moderator Last intervention   9 979
     
    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
    1. Boooksy
       
      Thank you for the tip! :)
      0
  2. g Posted messages 1285 Status Member 578
     
    Hello,

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

    Have a nice day.
    3
  3. ofardeau
     
    Je pose la question inverse, comment transformer un fichier .txt séparé par tabulation en un fichier séparé par des virgules ?
    0
    1. malaik5 Posted messages 259 Registration date   Status Member Last intervention   33
       
      Your question is odd, but anyway,
      you open your file, go to edit --> replace --> first character = tabulation; second character = ,
      0
  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