Import and Export Text Files in Excel
This lesson will teach you how to import and export text files in Excel. A text file can be of two types- comma-separated (.csv) or tab-delimited (.txt).
Export from Excel
To export as a text file from Excel, follow the steps below.
1. Open a workbook in Excel.
2. Click File tab -> Save as ->Browse.
3. Select Text (Tab delimited) from the drop-down list of the Save As type box.
5. Click Save.
Result: a text file (tab-delimited) is created. Note that you can select CSV in step 4 to get the comma-separated text file.
Import into Excel
To import a text file into Excel, follow the steps below.
1. Click File tab -> Open ->Browse.
3. Browse your file location and select “Text Files” from the drop-down list.
4. Now, select your file. In our example, we selected “ExcelMine- Tab delimited”.
5. Click Open.
6. Select “Delimited” and click Next.
7. Check “Tab”, uncheck all other delimiters, and click Next.
8. Click Finish.
Result: the text file (tab-delimited) is now showing in Excel.
| 4 of 4 completed! Congrats!! You can now move on to Chapter 13: Next Example >> |
| << Previous Example | Skip to Next Chapter 13: Protect Your Work |