Extract answers to a survey done with Marketo | Community
Skip to main content
Level 2
May 14, 2019
Question

Extract answers to a survey done with Marketo

  • May 14, 2019
  • 2 replies
  • 4071 views

Dear Experts,

I have done a survey using a form on a marketo landing page.

When I download the results, some of them do not appear in the Excel file... see image of field type attached. However I can see them in Marketo. Please note I edit the Default View to make the right columns to appear when I export the list. 

I also notice that when the text is too long or separated by commas, and the repondant has commas in its text, it creates another lign in Excel... any tips to prevent that??

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
Level 10
May 14, 2019

Please paste images inline (with your post text). Not all Nation users can see attachments, which makes them very confusing.

Katia_KPAuthor
Level 2
May 17, 2019

Here it is : 

SanfordWhiteman
Level 10
May 17, 2019

Please attach -- in this case you do have to attach, since it's not an image -- an exported CSV (don't use "CSV (Excel)" but just "CSV") including this column and illustrating the lost data.

Katia_KPAuthor
Level 2
May 21, 2019

Hi, it's actually an image : a screenshot of the Properties of the fields used in the survey. But actually I think the issue is because of some punctuation inserted in the answer : if you can see the image below, you can see that there is this ";" before the answer. When this occurs, I don't see the answer in the Excel file exported.... maybe a bug ?