Importing and Exporting Data

Using Excel, you can create a list from a text file; you can also save a list or table to a text file. You import and export text files when you want to share lists between programs, such as mailing-list management software and database programs that cannot read Excel worksheet files.

To import a text file as a list, first position the insertion point in the cell where you want the data to appear. Make sure no data appears below or to the right of the location you select, or it could be overwritten. Then follow these steps: