How to create a CSV file?

Here's how you create a CSV file for your email campaign:-

Open MS Excel or any other Spreadsheet application (Google SpreadSheet, LibreOffice, etc.)
Name the first row according to the merge tags that you are going to use in your personalized email campaign.
Merge tags are the placeholders in an email.
For eg - if you have a CSV of 200 people with their names and email addresses in it. You can keep the merge tag as 'Fname'. Now when you type Hey {{Fname}} in the email, it will be sent with their names in the email. You can have up to 20 merge tags with SalesHandy.
Enter the data that you have in this manner.
Save the file as '.CSV'.

Note: Make sure you have named the column containing the email address of the recipient as any of the below-given options:
"Email address, Email, Emails, Email address, E-mail, Email-address"

If you want to see exactly how your CSV file should look, download the Sample CSV File.