HomeMicrosoft OfficeExcelHow to Export Data to Text file in Microsoft Excel 2016?

How to Export Data to Text file in Microsoft Excel 2016?

If you need to export the worksheet data to a text file in Microsoft Excel 2016, you can do that easily using the Save As command.

How to Export Data to Text file in Microsoft Excel 2016?

1. Open your Excel workbook in Microsoft Excel 2016 and navigate to the worksheet that you want to export to text file.

2. Click File -> Save As menu from the Excel Ribbon and select “This PC” and the click the browse button.

SNAGHTML2a0d32

3. This would display the “Save As” dialog. In the Save as type drop-down list , select “Unicode Text” and click the save button.

image

This would display a warning messaging stating.

Some features in your workbook might be lost if you save as Unicode Text. Click “Yes:” to proceed.

image

Now , when you open the saved text file , you should be able to see the data from the active worksheet.

image

    1 Comment

  1. User Avatar
    Sandhya
    April 14, 2023
    Reply

    The process of exporting data into a text file in Excel is fairly simple.
    Anyone, even a novice, can export data to a text file.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021