Convert tab separated data to .CSV: free sfk tabtocsv for Windows, Mac OS X, Linux, Raspberry Pi

How to do things
AI Noob vs. Pro

List biggest files
List newest files
Show subdir sizes
Search in files
Replace word in files
List dir differences
Send files in LAN

Free Open Source:

Swiss File Knife

a command line
multi function tool.

remove tabs
list dir sizes
find text
filter lines
find in path
collect text
instant ftp or
http server
file transfer
send text
patch text
patch binary
run own cmd
convert crlf
dup file find
md5 lists
fromto clip
hexdump
split files
list latest
compare dirs
save typing
trace http
echo colors
head & tail
dep. listing
find classes
speed shell
zip search
zip dir list

Depeche View
Source Research
First Steps

windows GUI
automation

command line
file encryption

free external tools,
zero install effort,
usb stick compliant:

zip and unzip
diff and merge
reformat xml
reformat source

cpp sources

log tracing
mem tracing
hexdump
using printf

articles

embedded
stat. c array
stat. java array
var. c array
var. java array
view all text
as you type
surf over text
find by click
quick copy
multi view
find nearby
fullscreen
bookmarks
find by path
expressions
location jump
skip accents
clip match
filter lines
edit text
highlight
load filter
hotkey list
receive text
send in C++
send in Java
smooth scroll
touch scroll
fly wxWidgets
fly over Qt
search Java

Convert tab separated text data to comma separated .CSV output with the free Swiss File Knife for Windows, Mac OS X and Linux.

Download the free Swiss File Knife Base from Sourceforge.
Open the Windows CMD command line, Mac OS X Terminal or Linux shell.
OS X : type mv sfk-mac-64.exe sfk and chmod +x sfk then ./sfk
Linux: type mv sfk-linux-64.exe sfk and chmod +x sfk then ./sfk. OS X and Linux syntax may differ, check the help within the tool.

sfk tabtocsv infile.txt [options]

convert plain tab separated data to csv.

default input/output format
- input fields are separated by a tab and should
  not be surrounded by quotes, as these are not
  interpreted. input fields themselves cannot
  contain TAB characters.
- output fields are separated by comma ","
- output fields are surrounded by quotes "
  if input contains a comma or quote
- if input contains quotes it is escaped as ""

options
  -tofile x     write output to file x
  -quotetext    surround all text by quotes
  -quoteall     surround all output by quotes
  -outsep="x"   change output separator to
                character x, e.g. ; or \t
  -quote="x"    change quote character

examples
  sfk tabtocsv in.txt -tofile out.csv
     convert tab separated to csv in default format
  sfk csvtotab -quote="\x27" -insep=";" in.csv -tofile tmp.tsv
     reads a CSV with input fields separated by semicolon and
     surrounded by single quotes ' with ASCII code hex 27
  sfk tabtocsv -outsep=";" -quote="\x27" tmp.tsv -tofile out.csv
     converts tab separated to an output CSV, with output fields
     separated by semicolon and surrounded by single quotes

sfk tabtocsv infile.txt [options]

convert plain tab separated data to csv.

default input/output format
- input fields are separated by a tab and 
  should not be surrounded by quotes, as
  these are not interpreted. input fields
  themselves cannot contain TAB characters.
- output fields are separated by comma ","
- output fields are surrounded by quotes "
  if input contains a comma or quote
- if input contains quotes it is 
  escaped as ""

options
  -tofile x     write output to file x
  -quotetext    surround all text by quotes
  -quoteall     surround all output by 
                quotes
  -outsep="x"   change output separator to
                character x, e.g. ; or \t
  -quote="x"    change quote character


examples
  sfk tabtocsv in.txt -tofile out.csv
     convert tab separated to csv in 
     default format
  sfk csvtotab -quote="\x27" -insep=";" 
                 in.csv -tofile tmp.tsv
     reads a CSV with input fields 
     separated by semicolon and surrounded
     by single quotes ' with ASCII code hex
     27
  sfk tabtocsv -outsep=";" -quote="\x27" 
                 tmp.tsv -tofile out.csv
     converts tab separated to an output 
     CSV, with output fields separated by
     semicolon and surrounded by single
     quotes

you are viewing this page in mobile portrait mode with a limited layout. turn your device right, use a desktop browser or buy the sfk e-book for improved reading.

sfk is a free open-source tool, running instantly without installation efforts. no DLL's, no registry changes - just get sfk.exe from the zip package and use it (binaries for windows, linux and mac are included).

the Daily Landscape image
the Daily Mobile Background