Import Text Files

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

Further reading:

Import data: Import text files into Excel 2003

Exporting And Import Text With Excel

Importing Large Files In To Excel

Leave a Reply

Your email address will not be published. Required fields are marked *