Export Excel to CSV

Export selected ranges from Excel to CSV with any delimiter

Plain text CSV files are 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 only a selection or apply a different delimiter? Besides, this operation automatically closes Excel workbook – and becomes tiresome when done frequently.

Export to CSV add-in simplifies this routine operation:

  • Convert selected ranges from XLS to CSV
  • Choose comma, semicolon, tab or vertical bar as a delimiter
  • Choose to export values or formatted values to CSV
  • Save as CSV without closing the original Excel file
  • Export merged range accurately

XLTools Export to CSV Features Overview


Add XLTools ‘Export to CSV’ to Excel 2016-2007

Works with: Microsoft Excel 2016, 2013, 2010, 2007, and desktop version of Office 365.

Download XLTools Add-in


Learn your way around:

How to export a selected range from Excel to CSV

  1. Select a table or a range of cells.
  2. Click the ‘Export to CSV’ button on the XLTools tab > A window will open.
  3. Set CSV file options and choose a delimiter.
  4. Click OK > Save the CSV file to your computer > Done.

Export a selected range from Excel to CSV


How to export values vs formatted values from Excel to CSV

You can set data display format in the output CSV data – without modifying the original Excel file.

  1. Select the range > Click ‘Export to CSV’.
  2. Set the options of how you want the values in CSV to display:
    •     Select ‘Save the formatted value’ > The exported values will match your Excel formatting, e.g. 10%, 12-MAR-2016, $40.
    •     Select ‘Save the value’ > The values will export in default format, e.g. 0.1, 3/12/2016, 40.00.

Choose to export values or formatted values to CSV


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

  1. Select the range > Click ‘Export to CSV’.
  2. Choose a separator between values in the output CSV file:
    •     Comma
    •     Semicolon
    •     Tab
    •     Vertical line (pipe)

How to change delimiter in CSV from comma to pipe, semicolon, or tab


How to export a range with merged cells to CSV

  1. Select the range with merged cells > Click ‘Export to CSV’.
  2. Tick ‘Duplicate values when exporting merged range’.
  3. Done > The add-in will duplicate contents of the merged cell in corresponding plain text.

How to export a merged range from Excel to CSV


How to save Excel data to CSV without closing Excel file

When you use ‘Save As…CSV’ on an Excel file, a message appears: “Some features in your workbook might be lost”. Next, it seems that your original .xlsx file is substituted with the .csv file. What actually happens, is that your original Excel file is automatically closed. Instead, a newly generated CSV file opens in Excel interface. So after each export operation you have to reopen Excel. It is time consuming and brings risk of losing unsaved changes to the original Excel file.

The add-in streamlines the XLS-to-CSV routine:

  1. Select the range > Click ‘Export to CSV’ > Set CSV file options.
  2. Click OK > Name and save the file to a preferred location.
  3. Done > Note that the original Excel file remains open.
  4. If necessary, make changes and keep exporting other ranges uninterrupted.

You can also choose to ‘Open CSV file after export’. It will open in a new Excel window.

How to export Excel data to CSV without closing Excel file

 

Any questions or suggestions? Contact us or leave your comment below.

 

Leave a Reply

Your email address will not be published. Required fields are marked *