Introduction

Knowing the methods of importing and exporting data to and from Excel is very useful and will come in handy more than once in your work as a BA.

• Use Notepad to create a file with the following data:

• Save the data with the file name: mydata.txt

Exercise 1

Perform the following steps:

• Open Excel.
• Open option “Import text”
• Specify the “txt” file you created above.
• Follow the “data import wizard” steps to create an Excel spreadsheet containing the data in the txt file.

Additional Questions

• Explain in general terms what is the point here. [Answer: You are “transferring” data to Excel from another application, using a simple data transfer format.]

• What is a more sophisticated example of this general process. [Answer: Transferring data using “XML” format]