How to convert files text to excel?

Asked By araceliariana 30 points N/A Posted on - 01/22/2013

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

• Status: Open
• Question Views: 1300
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Riley weaver

Go To Solution

Answered By km_jaki 0 points N/A #142019

How to convert files text to excel?

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.

 

About km_jaki

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Riley weaver 10 points N/A #142020

How to convert files text to excel?

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.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #313516

How to convert files text to excel?

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 10/09/2018
• Question Category: MS Excel