How to convert txt files to csv

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.

 

i didn't tried this method bt i will defiantly gona try it

 

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.

 

thnxx , sure i will try this

 

I got this tool convertio.co/txt-csv after I google your query. Maybe that could help.

 

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.

 

Just change the extension of that file by doing "save as".

 

There are my software or converter tools online. You can find suitable tool searching from google.

 

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.
   
   
   
   
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.
   
   
   
   
6. Click Next.
7. In the Text Import Wizard, Step 3, review the formatting and make changes if required.
   
   
   
   
8. Click Finish.
9. Click OK.
   
   
   
   
10. 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.

 

thank you

 

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...