Page 1 of 13PREVNEXT

Import data: Import text files into Excel 2003

Import text files into Excel
Learn how to import text files into Microsoft Office Excel so that you can work on the data in Excel, and how to update the imported data if the external data changes.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use the Text Import Wizard to import text files that contain data into Excel.
  • Choose a method to import text files that lets you update the data if you want to.
  • Update the imported data if the external data is revised.

Before you begin

To learn about other ways to import external data, see the following courses:

There's a lot of external data that you can import into Excel and analyze. External data is data that is stored outside of Excel, in software accounting systems, mainframes, or databases, for example. By importing the data, you don't have to type it into Excel.

Some of this data may be in text files, a common file format that Excel can read. For example, someone may want you to work with the data from one of the tables in their database, but they can't grant you access to the database. So they convert the data into a text file, and then you can easily import the data into Excel.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 13PREVNEXT