Description: Description: Description: C:\Users\Graeme\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Word\Candy Technote-small.jpgCSV Excel Import Separator Options

Introduction

Candy uses a comma as a separator, the default separator is often a semicolon or tab in windows.

Permanently change the separator

Go to Region settings in Control Panel.

Click the Additional settings button.

Change the List separator to a comma.

Change separator for current import only.

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