CSV To Excel/Delimited Converter

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

Choose File Encoding

Enter URL as data source

Step 2: Choose input options (optional)

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 Ignore Case
	Field #	Type	Direction
First By
Then By
Then By

Output Field Separator: , ; : Bar-| Tab Unit Separator Other-Choose

Force text format for Excel
Force Wrap values in double quotes
Never Wrap values in double quotes (use with caution)
Add a header line if missing
Append Results below
Suppress Line Breaks in Fields
Add Line Numbers to Output
Display One Field/Value Per Line
Always overwrite template when generating standard CSV
Replace value of NULL in CSV with an empty value
Output Quoting Character is Apostrophe

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

Result Data:

Save your result: .csv EOL:

You can Save the complete settings, and then later Load them from your saved file.
Load Saved Form (Settings)
Save Form (Settings)

Convert CSV to Excel, TSV or Delimited