Importing data into Excel

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 hello@canddi.com or 0161 414 1080

Updated on: 04/02/2020