Just a huge thank you for the developers of the node import module, it worked fantastically for a community website project.

In the process we needed to combine two columns of our original data file to form the title field. We found we were able to do this first in the spreadsheet file before exporting to CSV using the suggestions found here, http://www.oooforum.org/forum/viewtopic.phtml?t=41040

Once we had the CSV file the rest was surprisingly easy with node import.

Thanks.