There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As …

Here's how: Go to Data > Get & Transform Data > Get Data > From File. Select the type of file that you want to import (such as From Excel Workbook or From Text/CSV). Select the file you …

Use the Text Import Wizard in Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data …

Open the workbook you want to save. Click File > Save As. Pick the place where you want to save the workbook. In the Save As dialog box, navigate to the location you want. Click the …

You can open a CSV file encoded with UTF-8 normally if it was saved with BOM (Byte Order Mark). Otherwise, you can open it through either of the following ways.

But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a mail merge.

A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store information separated by commas.

Select the Data tab, then From Text/CSV next to the Get Data button. If you don’t see the Get Data button, go to New Query > From File > From Text and browse to your text file, then press …

Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.

Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a .csv file. Here's how: