XLS2PG transform

xls2pg.el

(defun xls2f (str)
  "Transform a '42,42' string into a 42.42 float."

  ;; (atof (replace-regexp-in-string "," "." "42,42"))

  (format nil "~{~a~^.~}" (sq:split-sequence #\, str))
)

xls2pg.sql

LOAD CSV FROM FILENAME MATCHING ~/huge_file.csv/
         WITH ENCODING iso-8859-1
    INTO postgresql://login_x@localhost:5432/db
     (
        float num using (xls2f str)
     )
    WITH skip header = 1,
         fields optionally enclosed by '\"',
         fields escaped by double-quote,
         fields terminated by ',';

See dimitri/pgloader#92 for a full blown example using user defined transformation functions, and to debug use a very small file and both the following options: --debug --verbose, when both specified that's the same as --client-min-messages data which is the more advanced debug logs available.

Your transforms file should begin with the form:

(in-package :pgloader.transforms)

Also you can name the file with a .lisp extension ;-)