Export ranges from Excel to CSV with any delimiter and any character encoding

Widespread popularity of plain text CSV files is easily explained – this format is supported by majority of applications. So saving Excel spreadsheets as comma-delimited CSV files is a familiar operation. But what if you need to export not an entire worksheet, but only a selected range, or apply a different delimiter? Besides, saving as CSV automatically closes Excel workbook – and it becomes tiresome when you have to export data repeatedly.

Export to CSV add-in simplifies this routine operation:

  • Convert selected ranges from XLSX (XLS) to CSV
  • Choose a delimiter: comma, semicolon, tab or vertical pipe bar
  • Set any character encoding: UTF-8, ISO or other
  • Save as CSV without closing the original Excel file
  • Export merged cells accurately
(Note: the video may not reflect the latest upgrades. Please use the guide below.)

How to export a selected range from Excel to CSV

  1. Select a table or a range of cells.
  2. Click theExport to CSVbutton on the XLTools tab A window will open.
  3. Set CSV file options.
  4. Click OK Save the CSV file to your computer Done.
Export a selected range from Excel to CSV

How to change standard comma to a semicolon, tab or pipe delimiter

  1. Select the range Click theExport to CSVbutton.
  2. Choose a suitable separator between values in the output CSV file:

    • Comma
    • Semicolon
    • Tab
    • Vertical line (pipe)
  3. Click OK Save the CSV file to your computer Done.
How to change delimiter in CSV from comma to pipe, semicolon, or tab

How to set character encoding for the resulting CSV file

  1. Select the range Click theExport to CSVbutton.
  2. Choose the necessary encoding for the output CSV file:

    • UTF-8
    • ISO
    • ISCII
    • Unicode, or any other
  3. Click OK Save the CSV file to your computer Done.

How to export values vs formatted values from Excel to CSV

You can define, how to display data in the resulting CSV file, without modifying the source Excel data.

  1. Select the range Click theExport to CSVbutton.
  2. Set the options of how you want the values in CSV to display:

    • SelectSave the formatted value The exported values will match your Excel formatting, e.g. 10%, 12-MAR-2016, $40.
    • SelectSave the value The values will export in default format, e.g. 0.1, 3/12/2016, 40.00.
  3. Click OK Save the CSV file to your computer Done.
Choose to export values or formatted values to CSV

How to export to CSV a range with merged cells

  1. Select the range with merged cells ClickExport to CSV.
  2. Check the boxDuplicate values when exporting merged range The add-in will duplicate values from merged cells into the corresponding places of the CSV text string.
  3. Click OK Save the CSV file to your computer Done.
How to export a merged range from Excel to CSV

How to save Excel data as CSV without closing Excel file

When you convert Excel files using "Save As…CSV", a message appears: "Some features in your workbook might be lost". Next, it seems that your source XLSX file is replaced by the CSV file. What actually happens, is that your original Excel file gets automatically closed. Instead, a newly generated CSV file opens in Excel interface. So after each conversion you have to reopen the source Excel document again and again. It is time consuming and brings risk of losing unsaved changes to source data.

The Export to CSV add-in streamlines the XLSX-to-CSV routine:

  1. Select the range ClickExport to CSV Set CSV file options.
  2. Click OK Name and save the file on your computer.
  3. Done. Note that the original Excel file remains open. Its extenstion did not change.
  4. If necessary, make changes and proceed – uninterrupted – exporting other ranges.

You can alsoOpen CSV file after exportto preview the result immidiately. The file will open in a new Excel window.

How to export Excel data to CSV without closing Excel file
Any questions or suggestions?
close window
How can we help?