How to import or export text files in Excel (.txt - CSV.)


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 

Emad ghazi
كاتب المقالة
كاتب ومحرر اخبار اعمل في موقع عالم الاوفيس .

جديد قسم : مهارات الاكسل

إرسال تعليق