1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to convert txt files to csv

Discussion in 'Databases' started by komrad, Aug 6, 2009.

  1. Sumi Ariani

    Sumi Ariani Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #21
    actually dear it depends upon the data, if the data in your txt file is like this
    A B C
    D E F
    then u can replace space with tab and directly copy paste it to Microsoft excel file and then save
    SEMrush
     
    Sumi Ariani, Mar 4, 2016 IP
    SEMrush
  2. frank007

    frank007 Active Member

    Messages:
    157
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #22
    Open any text editor which support search and replace, search | replace with , and search ||||||| replace with \n or \n\r whatever shows you new line in your editor, then save that file to csv format.
     
    frank007, Mar 4, 2016 IP
  3. FemaleAdda

    FemaleAdda Member

    Messages:
    142
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    43
    #23
    just change the extension, or open the text file and save as csv.
    If nothing else works go to google search and convert it online.
    I often do it that way.. especially for e-mailers.
     
    FemaleAdda, Mar 4, 2016 IP
  4. Sumi Ariani

    Sumi Ariani Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #24
    i didn't tried this method bt i will defiantly gona try it
     
    Sumi Ariani, Mar 4, 2016 IP
  5. frank007

    frank007 Active Member

    Messages:
    157
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #25
    If your txt file lines are like this then surely this process would get your job done ;). I've used same method many times as it would convert txt to csv format.
     
    frank007, Mar 4, 2016 IP
  6. Sumi Ariani

    Sumi Ariani Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #26
    thnxx , sure i will try this
     
    Sumi Ariani, Mar 4, 2016 IP
  7. DarwinJones

    DarwinJones Member

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #27
    I got this tool convertio.co/txt-csv after I google your query. Maybe that could help.
     
    DarwinJones, Apr 11, 2016 IP
  8. Luriya

    Luriya Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #28
    In many cases all you really have to do is change the extension to .csv. Sometimes saving as a .csv does the trick as well.
     
    Luriya, Jun 8, 2016 IP
  9. Saqib Habib

    Saqib Habib Greenhorn

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #29
    Just change the extension of that file by doing "save as".
     
    Saqib Habib, Jun 18, 2016 IP
  10. nosheen hayat

    nosheen hayat Banned

    Messages:
    57
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    33
    #30
    There are my software or converter tools online. You can find suitable tool searching from google.
     
    nosheen hayat, Jun 20, 2016 IP
  11. rownakucse

    rownakucse Banned

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #31
    Convert a TXT file to CSV format
    Convert a TXT file to CSV by changing the file extension, or importing the TXT data. Xero uses data in CSV format in bank statement imports, invoice imports, and more.

    Save .txt file extension with .csv extension
    The easiest way to convert a TXT file to a CSV file is by saving the TXT file with a .csv file extension.

    Example
    This TXT file, named fruit.txt, has commas that determine where column breaks will be if imported into a spreadsheet.



    Save the file as fruit.csv and open it in a spreadsheet program. You'll see the text displayed in columns in the spreadsheet.



    If this method doesn't give you the result you need, try importing the TXT data into CSV format.

    Import TXT data into CSV
    This example uses Microsoft Excel, but you can use any spreadsheet program compatible with TXT and CSV format files.

    1. In Microsoft Excel, go to Data, then click From Text.
    2. Locate and select your TXT file.
    3. Click Import.
    4. In the Text Import Wizard, Step 1, select Delimited, then click Next.

      [​IMG]

    5. In the Text Import Wizard, Step 2, select the checkbox for Comma. This adds lines to show you where the column breaks will be.

      [​IMG]

    6. Click Next.
    7. In the Text Import Wizard, Step 3, review the formatting and make changes if required.

      [​IMG]

    8. Click Finish.
    9. Click OK.

      [​IMG]

    10. Microsoft Excel displays your data in a spreadsheet. When you save the file, make sure to save it as file type CSV.

      [​IMG]

      11.then save
    Thanks
     
    rownakucse, Oct 17, 2016 IP
  12. R Poornima

    R Poornima Greenhorn

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #32
    • First, launch Microsoft Excel -> Click "Data," -> "From Text." The Import Text File dialog box is displayed.
    • Now click on a “TXT file” -> click on "Import" it will display the Text Import Wizard.
    • Select "Fixed width" radio button and click "Next."
    • In the data preview section click on the line to create field break line. Each break line should be formed to distinct one field from another, then click “next”.
    • Now click on “finish” and “ok” to import.
    • Click "File," then select "Save As" and select "CSV (Comma delimited)" from the Save As Type drop-down menu.
    • Finally, click "OK" and "Yes" to accept the conversion of your text data to CSV format.
    • Now save the new CSV file in the specified place.
     
    R Poornima, Nov 2, 2016 IP