How to import text files or comma seperated values (csv) into Excel:
- Text files are small in size and easy to create
- Text files are not prone to viruses
- Importing such text files into Excel for further manipulations is easily done as shown in the training video
- 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
- Of course, files from a database like MS-Access can also be easily imported as shown in the next training video
|
|
