bulk import from a csv to only certain columns

I needed to bulk import from a csv to only certain columns. My solution was to create a view on the columns I needed and do the bulk import on that