Here's a short ruby script that opens a spreadsheet file with a full name column and splits that into a first name and a last name.

* With assumption that the last word from the full name column is the last name