ParseCsv.cs

// Compile: "c:\Program Files (x86)\MSBuild\14.0\Bin\csc.exe" ParseCsv.cs /r:CsvHelper.dll
// Depends on: https://www.nuget.org/packages/CsvHelper/
// Source code: http://joshclose.github.io/CsvHelper/#change-log

using System;
using System.IO;
using System.Xml;
using System.Xml.Linq;
using CsvHelper;

class Program
{
	static void Main()
	{
		using (var reader = new StreamReader(File.OpenRead("SampleInput1.csv")))
		{
			var csv = new CsvReader(reader);
			var records = csv.GetRecords<Record>();
			foreach (var record in records)
			{
				Console.WriteLine("-----------");
				Console.WriteLine(record);
			}
		}
	}
}

class Record
{
	public int Site { get; set; }
	public int Format { get; set; }
	public string Title { get; set; }
	public string Variations { get; set; }
	public XDocument XmlVariations { get { return XDocument.Parse(Variations); } }

	public override string ToString()
	{
		return $"Site: {Site}, Format: {Format}, Title: {Title}, Variations: {XmlVariations}";
	}
}