Articles on: CANDDi Tools

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.


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


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


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


  1. 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

Was this article helpful?

Share your feedback

Cancel

Thank you!