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


Step 2: Choose input options (optional)


Input Options
Limit # of lines: Skip # of Lines
Field Separator:

Step 3: Choose output options (optional)


Output Options
Display which field positions? (Comma separated list where 1 is 1st field, 2=2nd,... i.e. 2,1,3,4)
 
Sort CSV  
 Field #TypeDirection
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 Top
Repeating Section for each Line of CSV
Bottom

Step 5: Generate output


Choose Conversion Type:



.csv

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