Have you looked at the CSV Spreadsheet Importer Multitool workflow, @seffy?
With a little fussing you can build formula-driven derived values in addition to directly remapping data. (There are some examples in the prefab templates.) You should even be able to deal with that non-US date format using the derived data approach.