Candy uses a comma as a separator, the default separator is often a semicolon or tab in windows.
Go to Region settings in Control Panel.
Click the Additional settings button.
Change the List separator to a comma.
Open a blank spreadsheet.
On the data tab, in the Get External Data group click From Text.
Locate the CSV file exported by Candy. Click Import.
Make sure the origonal data type is set to Delimited. Click Next.
Only the Comma delimiter should be ticked. Click Next.
Choose where you would like to put the imported data. The default is in the blank spreadsheet created in the first step. Click OK