Importing CSV Files with phone numbers

Please move the thread to Products . This space isn't for support, it's for discussing the Champs incentive program itself. Move link at right.

Hi Christine,

What is the problem you're running into?  I've always imported telephone numbers using the csv format without any issues?  CSV format tends to strip all the formulas etc out of a spreadsheet.

Thanks

Juli

Seconding Julie here: it's not possible for CSVs to represent Marketo Formula fields.

You can of course have Excel mistakenly set to Formula type in a cell or column, which might result in a CSV with meaningless content. But Marketo wouldn't recognize the output as anything but a String.

Sometimes international phone numbers get messed up when you go from CSV to Marketo -- Excel thinks that your phone number is a long number that needs to display in scientific notation, and Marketo makes the phone number that value. You need to play with the cell format in your CSV before upload, make sure that what you see in the cell is the full phone number before doing your upload.