Software Tools Snapshots‎ > ‎Excel‎ > ‎

Importing Data

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:
Letter, Item, Number, Date
A,apple,12,Feb 12
B,Betty,13,Feb 13
C,cat,14,Feb 14
D,dog,20

  • 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]