IMPORTING A TEXT FILE

4. Import a text file

   There are two ways to import data from a text file by using Microsoft Excel: You can open the text file in Excel, or you can import the text file as an external data range. To export data from Excel to a text file, use the Save As command.
   There are two commonly used text file formats:
   

   • Delimited text files (.txt), in which the TAB character (ASCII character code 009) typically separates each field of text.
   • Comma separated values text files (.csv), in which the comma character (,) typically separates each field of text.

   You can change the separator character that is used in both delimited and .csv text files. This may be necessary to make sure that the import or export operation works the way that you want it to.
   Notes
   

   • You can import or export up to 1,048,576 rows and 16,384 columns.