Jackson
Rookie

How to convert file format from txt to csv?


Friends I have some important files which I want to convert in csv type file. The documents are in txt format. I want to know that is there any method or software for doing this. So tell me the easiest way of to converting these txt files in csv….waiting for quick reply from your side.
6 months ago
Respond to this discussion
Vinit Nair | Oct 30 2011

It is very easy. csv format is mainly and most popularly used in various online and offline address books. It is a very simple file format and is quite widely supported by various applications. So I think the documents that you want converted in .csv are some text which are separated by commas and are similar to the address book format because otherwise they would not quite well in .csv format. I would also suggest you to convert them to excel format because it is more standard and is a better format.

Here is the method to convert .txt to .csv – start Microsoft Excel, go to the bottom toolbar and delete sheet 2 and sheet 3 because you only need Sheet 1 for this process. In the open dialog search for all files and select the text file you want to convert. In the text import wizard box make the necessary changes so that it looks readable and then click on next. Check if the whole file has imported properly and then correct the minor errors. Spread the columns and do a little formatting. Now click on file and select Save as. Give your file a name and in save as type select .csv. Click yes when the warning regarding incompatibility is shown and save the document in .csv format to your hard drive.

© 2012, Instamedia. Some rights reserved. Powered by Instapress and Instacheckin.