This is possible, yes. Since CSVs only support text, you will need to use the text version of the emoji.
1) Go to http://emoji.codes/
2) Search for an emoji.
3) Click one and the text shortcut will be copied.
4) Paste into the 'Message' field of the CSV file.