Sometimes Excel ‘mangles’ the CSV data which has been exported from CANDDi, for example: Excel strips off the leading 0 from Phone Number fields. This FAQ shows how to import the data into Excel in a way which preserves this data.

Run a regular Stream Export in CANDDi
Once the Export has completed then download the CSV file from Actions -> Downloads
Now to import into Excel
Select File -> Import -> CSV File

(NOTE: These screenshots were made on a Mac - but the Windows workflow should be the same)

Select your exported file
Select Delimited
On Step 2 of 3 - click Next (rather than straight to Finish)

Highlight the field that you wish to have displayed as a Phone Number (select Column data format ‘Text’).

Repeat step 7 for every field you would like formatted in the same way.

Have more questions? Contact us at or 0161 414 1080
Was this article helpful?
Thank you!