|
|
| |
|
|
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
- Of course, files from a database
like MS-Access can also be easily imported as shown in the next
training video
|
|
|
|
| |
|
|