How to import or export text files in Excel (.txt - CSV.)
Welcome
back
Did
you know that there are two ways to import data from a text file using Excel:
Congratulations
You can open a text file in Excel, or you can import it as a file from an
external data range. To export data from Excel to a text file, follow these
steps:
Use the Save As command and change the file
type from the drop-down list.
There
are two commonly used formats for text files:
delimited
text files (.txt), where the TAB character (ASCII character code 009) separates
each text field.
Comma
Separated Values Text files (.csv), where the comma character (,) usually
separates each field of text.Also, you can change the separator character used
in both delimited and .csv text files.
This may be necessary to ensure that the
import or export process works the way you want it to.
Very
important note: You can import or export up to 1048576 rows and 16384 columns
with ease.
Import a text file by opening it in Excel
You
can open a text file you created in another program as an Excel workbook using
the Open command. Opening a text file in Excel does not change the file's
format — you can see this in the Excel title bar, where the file name retains
the text file name extension (for example, .txt or .csv).
Go
to File > open and browse to the location that contains the text file.
Select
Text files in the file type drop-down list in the Open dialog box.
Locate
the text file you want to open and double-click it.
If
the file is a text file (.txt), Excel starts the Text Import Wizard. When you
have finished performing the steps, click Finish to complete the import
process. See the Text Import Wizard for more information about advanced and
understandable options.
If
the file is a csv file. Excel automatically opens the text file and displays
the data in a new workbook.
Note: When Excel opens the .csv file.
, it uses the current default data format settings to interpret how each column
of data is imported. If you want more flexibility in converting columns to
different data formats, you can use the Text Import Wizard. For example, the
format of a column of data in a .csv file might be MDY, but the default data
format in Excel is YMD, or you want to convert a column of numbers that
contains zeros that lead to text so that you can preserve the parent zeros.
Forcing Excel to run the Text Import Wizard, you can change the file name
extension from .csv to .txt before opening it, or you can import a text file by
calling it
Source Microsoft Office