Home / Others

How to create a CSV file?


Last updated on Sep 05, 2023

So, you're all set to launch an amazing email campaign with Mystrika, but you need to create a CSV file to make it happen. Don't worry; we're here to guide you through this process in simple terms that anyone can understand.

Step 1: Open Your Spreadsheet Application

  • To start, you'll need a spreadsheet application like Microsoft Excel, Google Sheets, or even LibreOffice. If you don't have one yet, you can use free alternatives like Google Sheets, which works great.

Step 2: Name Your Columns with Merge Tags

  • Merge tags are like magical placeholders in your emails. They let you personalize your emails with your recipients' names, making your campaign more engaging. For example, if your CSV has people's names and email addresses, you can name a column "personalized_line" for Personalization. When you write something like "{{personalized_line}}" in your email, it will automatically fill in the personalized line your provided for each recipient.

Step 3: Enter Your Data

  • Now, it's time to input your data. Fill in the rows beneath your column names with the relevant information for your campaign. For example, under the "fullname" column, add your recipients' names. Be sure to keep your data organized and accurate.

Step 4: Save Your File as '.CSV'

  • Last but not least, save your file in CSV format. This is crucial because Mystrika and email marketing tools use CSV files to import your data seamlessly. To do this, go to the "File" menu and select "Save As." Then, choose the '.CSV' format. Give your file a name you'll remember, and click "Save."


That's it! You've just created a CSV file that's ready to power your Mystrika email campaign. With personalized emails and organized data, you're well on your way to crafting successful outreach.

If you have any more questions or need further assistance, feel free to reach out. Happy emailing! 😊