Use this tool convert CSV to Excel and delimited output.

What can this tool do?

  • Use this tool to convert delimited data to another delimited format.
  • You can convert to and from Excel, pipe delimited, colon or semi-colon delimited, comma delimited, tab delimited, or choose a custom delimiter. Common usage is to convert CSV to TSV or rearrange column order.
  • New Convert Excel to CSV

What are my options?


  • You can change the quoting character to apostophe for input and output.
  • You may choose a new output delimiter.
  • It will force Excel to treat fields as text if requested.
  • Force double quotes or never use double quotes
  • You can to include/exclude rows by using our query option.
  • Sort CSV data in ascending or descending order before converting.
  • It will add missing headers if you like.
  • Optionally output empty field for NULL field value

Step 1: Select your input




   
Encoding
 

 
 

Step 2: Choose input options (optional)


Input Options   

Field Separator:



Step 3: Choose output options (optional)


Output Options
 

Sort CSV  
  Field # Type Direction
First By
Then By
Then By

Output Field Separator:            











Step 4: Create Custom Output via Template (optional)


Modify Template below and Press Convert   See also CSV Templates






Step 5: Generate output





.csv

You can Save the complete settings, and then later Load them from your saved file.