DEV Community

loading...

Export or Save a Range as CSV, HTML, PDF or Workbook in Excel 365!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・7 min read

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

Note: kutools for Excel 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
select the range

  • 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
Select the Export Range to File option

  • 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
Export Range to File Dialog Box

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

Output
Output

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.

select the range
select the range

  • 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
Select the Export Range to File option

  • 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
Export Range to File Dialog Box

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

PDF file
PDF file

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
select the range

  • 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
Select the Export Range to File option

  • 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
Click OK button

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

Output
Output

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
select the range

  • 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
Select the Export Range to File option

  • 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
Export Range to File Dialog Box

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

Output
Output

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
select the range

  • 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
Select the Export Range to File option

  • 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
Export Range to File Dialog Box

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

Result
Result

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. Keep Learning!

Read Also:

Discussion

pic
Editor guide