Hi,
I have some experience about Ms Excel and a little experience about text file. But I do not know how can a Text file convert to Excel. There are many people who are able to convert text files into excel very easily. Are there anybody to help me?
Thanks
There I see you a process How do convert a text file (.txt, .prn, .csv) to an Excel
Answer:
1.Start Excel.
2.View all readable text files.
Example :In Excel 2010:
1. Select the File tab.
2. In the left menu column, select Open.
3. To the right of the File name: text box, from the drop-down list, select Text Files (*.prm; *.txt; *.csv).
3.Navigate to and select the document you want to convert.
4.Click the Open button.
5.Select the Delimited radio button.
6.Click Next.
7.Under Delimiters, clear all the check boxes.
8.Under Delimiters, place a check in the check box(es) corresponding to the separator(s) your data contains.
9.Click Next.
10.Click Finish.
Hi there,
The whole work is really so easy, you just need to create or format the text in a proper manner to import directly the text file into Excel. Suppose you want to import the data in a CSV file than just give comma after every data for different column. Now open Excel and find out data section, now from the “get external data section” click on “from text”. Highlight the file you want to import and click OK.
Another box will pop up, select delimiter radio and click on Next. Now select the delimiter as you rearranged your text file, like comma, space, tab etc. Click on “Finish” button. These text wills appear in an excel format.
Best regards,
Riley Weaver.
I don’t think you need to convert a text file to the format used by Microsoft Office Excel because, in the first place, Microsoft Office Excel itself supports the text file format (*.txt). You don’t need any conversion to open the file. Just open the text file directly in Microsoft Office Excel and just format how the contents are displayed.
To open a text file, start Microsoft Office Excel then press CTRL + O to bring up the “Open” dialog then navigate to the location of the text file you want to open. By default, you won’t see any text file displayed in the window. To show the text files, in “Files of type” dropdown list, scroll down and select “Text Files (*.prn; *.txt; *.csv)”.
Now, select the text file you want to open on the window then click “Open”. After this, just follow the instructions how to format the contents in Microsoft Office Excel. Or just click “Finish” to simply load the file without re-arranging its contents.
