Export or Save a Range as CSV, HTML, PDF or Workbook in Excel 365!!
Tags: exportorsavearange, kutoolsexceltutorial, kutools
Published: 2020-12-02 09:52:45

---
title: Export or Save a Range as CSV, HTML, PDF or Workbook in Excel 365!!
published: true
date: 2020-12-02 07:16:56 UTC
tags: ExportorSaveaRange,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/export-or-save-a-range-as-csv-html-pdf-or-workbook-in-excel-365/
---

In this article, we are going to see how to **Export or Save a Range as CSV, HTML, PDF, or Workbooks in Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Export or Save a Range of Data as a New Workbook:

To export or save a range of data as a new workbook in Excel, follow the below steps.

- First, you need to **select the range**  that you want to export.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- On the **Kutools Plus Tab, select** the **Import**  **& Export** option, then **select** the **Export Range to File** option from the menu.

![Select the Export Range to File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-4.png)<figcaption id="caption-attachment-18464">Select the Export Range to File option</figcaption>

- It will display the **Export Range to File Dialog Box**.
- **File format –** You need to **select** the **Excel workbook** option from this section.
- **Workbook options –** Here, you need to **select** the **Convert formula to values** and **Preserve formatting** options.
- **Save directory –** You need to **select**  **a folder** location to put the final file.
- Then, you need to **click** the **OK** button.

![Export Range to File Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-4.png)<figcaption id="caption-attachment-18468">Export Range to File Dialog Box</figcaption>

- You can see that the selected range has been exported to a workbook.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Output-2.png)<figcaption id="caption-attachment-18469">Output</figcaption>

### Note:

- **Convert formulas to values – ** It will display the calculated results of each formula in the selected range instead of the formula in the final file.
- **Preserve row height/column widths – ** This option will preserve row height/column widths in the final file.
- **Preserve formatting – ** It will preserve the formatting of the range in the final file.
- **Open the file after export – ** If you check this option, it will automatically open the final file after exporting the range.

## Steps to Export or Save a Range as a PDF File:

You can save a range as PDF File in Excel by doing the below steps.

- First, you need to **select the range** that you want to save as a [PDF file](https://geekexcel.com/how-to-convert-excel-files-to-pdf-in-microsoft-excel-365/).

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Import**  **& Export** option, then **select** the **Export Range to File** option from the menu.

![Select the Export Range to File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-4.png)<figcaption id="caption-attachment-18464">Select the Export Range to File option</figcaption>

- It will display the **Export Range to File Dialog Box**.
- **File format –** You need to **select** the **PDF** option from this section.
- **Workbook options – ** In this section, you need to **select** the **Preserve formatting** option.
- **Save directory –** You need to **select**  **a folder** location to put the final file.

![Export Range to File Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-3.png)<figcaption id="caption-attachment-18470">Export Range to File Dialog Box</figcaption>

- Finally, you need to **click** the **OK** button.
- You will get the output as shown in the below image.

![PDF file](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-3.png)<figcaption id="caption-attachment-18471">PDF file</figcaption>

### Note:

- **Convert formulas to values – ** It will display the calculated results of each formula in the selected range instead of the formula in the final file.
- **Preserve row height/column widths – ** This option will preserve row height/column widths in the final file.
- **Preserve formatting – ** It will preserve the formatting of the range in the final file.
- **Open the file after export – ** If you check this option, it will automatically open the final file after exporting the range.

## Export or Save a Range of Data as Comma Delimited CSV File:

If you want to export or save a range of data as a comma-delimited CSV file in Excel, you can get it done as follows.

- Kindly, **select the range** that you want to save as a **CSV** file.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- On the **Kutools Plus Tab, select** the **Import**  **& Export** option, then **select** the **Export Range to File** option from the menu.

![Select the Export Range to File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-4.png)<figcaption id="caption-attachment-18464">Select the Export Range to File option</figcaption>

- It will display the **Export Range to File Dialog Box**.
- **File format –** You need to **select** the **CSV(Comma delimited)** option from this section.
- **CSV file options –** Here, you need to **select** the **Save the actual values** option.
- **Save directory –** You need to **select**  **a folder** location to put the final file.
- Then, you need to **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-3.png)<figcaption id="caption-attachment-18472">Click OK button</figcaption>

- Finally, you will export the selected range as a CSV file as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7-2.png)<figcaption id="caption-attachment-18473">Output</figcaption>

### Note:

- **Save the actual value – ** It will display the actual values in the final file.
- **Save values as shown onscreen – ** This option will display the values in the final file as the same you read them on the computer screen.
- **Open the file after export – ** If you check this option, it will automatically open the final file after exporting the range.

## Steps to Export or Save a Range of Data as Text File:

To export or save a range of data as a text file in Excel, follow the below steps.

- Please **select the range** that you want to export or save a range.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Import**  **& Export** option, then **select** the **Export Range to File** option from the menu.

![Select the Export Range to File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-4.png)<figcaption id="caption-attachment-18464">Select the Export Range to File option</figcaption>

- It will display the **Export Range to File Dialog Box**.
- **File format –** You need to **select** the **Unicode Text** option from this section.
- **CSV file options –** Here, you need to **select** the **Save the actual values** option.
- **Save directory –** You need to **select**  **a folder** location to put the final file.
- Then, you need to **click** the **OK** button.

![Export Range to File Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8-2.png)<figcaption id="caption-attachment-18474">Export Range to File Dialog Box</figcaption>

- You will see the final text file as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/9-2.png)<figcaption id="caption-attachment-18475">Output</figcaption>

### Note:

- **Save the actual value – ** It will display the actual values in the final file.
- **Save values as shown onscreen – ** This option will display the values in the final file as the same you read them on the computer screen.
- **Open the file after export – ** If you check this option, it will automatically open the final file after exporting the range.

## Export or Save a Range as an HTML file:

If you want to export or save a range of data as an **HTML** file, apply the following steps.

- You need to **select the range** that you want to export as an **HTML** file.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- On the **Kutools Plus Tab, select** the **Import**  **& Export** option, then **select** the **Export Range to File** option from the menu.

![Select the Export Range to File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-4.png)<figcaption id="caption-attachment-18464">Select the Export Range to File option</figcaption>

- It will display the **Export Range to File Dialog Box.**
- **File format –** You need to **select** the **Simple HTML ** or **Complex HTML (all formatting)** option from this section.
- **Simple HTML options –** You need to select all the options under this section.
- **Save directory –** You need to **select**  **a folder** location to put the final file.
- Then, you need to **click** the **OK** button.

![Export Range to File Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10-2.png)<figcaption id="caption-attachment-18477">Export Range to File Dialog Box</figcaption>

- You will see the results as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11-2.png)<figcaption id="caption-attachment-18479">Result</figcaption>

### Note:

- **Simple HTML –** It will export with the grid lines, background color, font name, font size, font color, bold italic, column width, horizontal alignment.
- **Complex HTML – ** All formats of the selected range will be kept in the final file.

## A Brief Summary:

In this article, you will clearly understand the steps to **Export or Save a Range as CSV, HTML, PDF, or Workbooks in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Filter Data Based on Cell Value With Multiple Criteria in Excel Office 365!!](https://geekexcel.com/filter-data-based-on-cell-value-with-multiple-criteria-in-excel-office-365/)
- [How to Create Worksheets From a List of Worksheet Names in Excel 365?](https://geekexcel.com/how-to-create-worksheets-from-a-list-of-worksheet-names-in-excel-365/)