Free Microsoft Excel Training Videos
 

Importing text files into Excel




Importing such text files into Excel for further manipulations is easily done as shown in the training video. Very often we receive comma separated values or text files from databases like MySQl for further analysis. People who have ever traded on the stock market know this very well. Even in standard offices the HRD gets many files in this format for further analysis like how many people joined this year and how many left. What were their reasons for leaving? Why are these text files used?
  • Text files are small in size and easy to create
  • Text files are not prone to viruses

How to import text files into Excel or comma separated values (csv) into Excel:
  • Click on 'Data' in the menu bar
  • Select 'Import External Data' and then 'Import Data...'
  • In the 'Select Data Source' find your text file
  • In our case the text file 'import_excel.txt' file was stored on the 'Desktop'
  • Then follow the instructions step by step to complete the process as detailed in the training video (23 MB)
  • Of course, files from a database like MS-Access can also be easily imported as shown in the next training video

More about importing text files into Excel

Exporting and Importing Text in MS-Excel

Importing Big Text files into MS-Excel

 
Importing Text Files into Excel