CSV (comma separated values) and tab delimited (TSV) are both types of delimited text files. However they are different in that:
a tab delimited file doesn’t allow the tab character within values
a CSV file ‘escapes’ the comma character in values with quotes (and ‘escapes’ quotes in values with additional quotes)
So you can’t just find and replace commas with tabs. However you can easily convert CSV to tab delimited with Easy Data Transform:
Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully fuctional free trial and you don’t have to give us your email or sign up to anything.
Start Easy Data Transform.
Drag the CSV file you wish to convert onto Easy Data Transform. A pink input item will be added.
Ensuring the pink input item is selected, click the To File button in the left pane (scroll to the bottom of the left pane).
A window will appear. Set the new file name and location. Select tab delimited file as the file type.
A green output item is added and selected.
The tab delimited file is created immediately, no need to ‘run’ anything.
You can change the Encoding in the Right pane.
If you have large number of files to convert you can do it using the batch processing feature.
As well as changing file format, Easy Data Transform also allows you to combine 52 transforms (such as join, filter and dedupe) to quickly and easily create complex data transformations. See our quick start guide for more details.