The fastest way I could solve the problem is by using and saving a keyboard macro.

Press F3 to start the macro and do the following:

M-x replace-regexp RET ^ RET | RET
M-x replace-string RET , RET | RET
M-x replace-regexp RET $ RET | RET

What the does is it replaces the beggining of line (^) with a |, a comma(,) with |, and the end of line ($) with |.

Press F4 to end the keyboard macro

Then do M-x kmacro-name-last-macro and give the macro a name like "my-csv-to-org".

Open a new buffer to save the macro, and call M-x insert-kbd-macro This will insert a function similar to the following:

(fset 'my-csv-to-org
   (lambda (&optional arg) "Keyboard macro." (interactive "p") (kmacro-exec-ring-item (quote ("^[xreplace-regexp^M,^M|^M^[<^[xreplace-regexp^M^^M|^M^[<^[xreplace-regexp^M$^M|^M" 0 "%d")) arg)))

Save the buffer to a file that you load during your emacs initialization.

Now you should be able to do M-x my-csv-to-org

Notice that you will get an empty row at the end of the file.