Question: how to import data from excel to text file?
Answer: Go to File > Save As.
The Save As dialog box appears.
In the Save as type box, choose the text file format for the worksheet. ... 
Browse to the location where you want to save the new text file, and then click Save.