You may have to mangle your input data if possible to replace double quotes with single quotes. I had a situation where I wanted output delimited by the pipe character and did this: <code> sqlite> select * from keywords limit 20; sqlite> .output /Users/user/Desktop/fubar.txt sqlite> .separator | sqlite> select * from keywords limit 20; </code>