How to convert txt files to csv

Hello,

Could you please help me how to convert txt files to csv one.


Thanks.

 

If it is csv data, you can just change the extension to .csv.

What format is the data in otherwise?

 

Open your txt file with notepad. Click on "save as", and type yourfilename.csv

 

Show a sample text file.

 

CSV just means comma separated values. If your text file has data in rows, just make sure the columns are separated by a comma. Save the file with a .csv file extension instead of .txt. Then you can use the CSV file to import into another database or use it as input for a software program.

Most databases have an export feature that will assist you in getting the data output saved in CSV format. Otherwise if you have the raw data, you may have to search and replace column separators with actual commas, or you'll have to do a little bit of manual formatting.

 

Just rename the extension.

 

Show us a sample of your txt data.

For it to be in CSV format your first row should be your column headers and each entity needs to have a comma delimiter. If the delimiter is not a comma, then you can simply do a find a replace.

If it already meets this criteria then just change the extension to .csv as mentioned before.

Excel is a good tool to work with columns and save as CSV format.

 

that s not enough to make the file .CSV
u need to seperate the colums with commas!
the easiest way is using excel. just save as.

 

Just found this: Link

Not sure if it will work, but it's worth a try

 

open with notepad, separate columns with commas and save as .csv it will work

 

The columns should already be separated if you're converting txt.

 

The txt file is some products datafeed with | separated columns. When i tried to use an application it require csv files. Thats what i meant.

Here is the data sample:

453629947|Ticket Sales Representative|65|JobsInSports.com|http://www.shareasale.com/m-pr.cfm?merchantID=65&userID=98236&productID=453629947|http://www.jobsinsports.com/images/new-minilogo.gif|http://www.jobsinsports.com/images/new-minilogo.gif|9.95||Business/Services|Careers|JobsInSports.com is assisting a major professional sports franchise hire Ticket Sales Representatives. This is a full time position that requires a college degree. Other requirements are a professional appearance, excellent Communication and organizational skills and the desire and work ethic to be the best.||||New Jersey Professional Sports Franchise|New Jersey|2005-05-16 19:41:49.233|instock|||||||

Code (markup):

 

Use MS Excel or any such tool and import this TXt file. You can run through the steps and you will get the excel sheet. now save it as CSV. you delimiter will be |

 

Fields appear to be delimited by | . Lines should be terminated by something as well, or set to a fixed number of fields. Look at your text file and try to import into excel or a similar app. You just need set the import options correctly.

 

or specify a fixed width

 

Hi,
For converting the .txt file which contains contact no. to .csv files u have to go at microsoft outlook express with the whole content of txt file and that will automatically change it in csv

 

Open the text file in excel or calc if you have open office, it will prompt you to convert the txt delimited to csv.

 

U need replace "|" by ";" and save in csv

 

There are two ways to import data from a text file by using Microsoft Office Excel: You can open the text file in Excel, or you can import the text file as an external data range. To export data from Excel to a text file, use the Save As command.
There are two commonly used text file formats:

• Delimited text files (.txt), in which the TAB character (ASCII character code 009) typically separates each field of text.
• Comma separated values text files (.csv), in which the comma character (,) typically separates each field of text.

You can change the separator character that is used in both delimited and .csv text files. This may be necessary to make sure that the import or export operation works the way that you want it to.

 

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

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

After saving the file as abc.csv, the text is put into columns in the spreadsheet.