Summary:

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

Steps:

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 PhoneNumber (select Column data format "Text")



Repeat step 7 for all the fields which you wish to have formatted like this

Have more questions? Submit a request
Was this article helpful?
Cancel
Thank you!