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
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.
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.
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.
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.
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. In Microsoft Excel, go to Data, then click From Text. Locate and select your TXT file. Click Import. In the Text Import Wizard, Step 1, select Delimited, then click Next. In the Text Import Wizard, Step 2, select the checkbox for Comma. This adds lines to show you where the column breaks will be. Click Next. In the Text Import Wizard, Step 3, review the formatting and make changes if required. Click Finish. Click OK. Microsoft Excel displays your data in a spreadsheet. When you save the file, make sure to save it as file type CSV. 11.then save Thanks
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.
CSV file is comma delimited. Text file is either tab delimited or space delimited, generally. You can open the tab text file in ms-excel, and then save it as CSV. In previous versions of excel there was an import file option. That handled the delimiter thing. In new versions, I got no idea where this import option is...