The import is not processed because the last column in the file contains empty column headers. How do I rectify this?

You can copy the columns in the file that have data and paste them into a new sheet. Then, download this new sheet as a CSV file and try importing it again.