CSV report is not splitting filters into different columns, just separated by commas.

Updating Media

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

Jennifer_DunganAccepted solution

Level 2

Hi, your screenshot seemed to fail so we can't really see your example...

However CSV stands for "comma separated values".

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

When I add "comma" as delimiter, the data preview now shows correctly:

Jennifer_DunganAccepted solution

Level 2

Hi, your screenshot seemed to fail so we can't really see your example...

However CSV stands for "comma separated values".

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

When I add "comma" as delimiter, the data preview now shows correctly:

Translate

New Participant

Appreciate it, I now was able to split them using your instructions. Thanks!

Translate

Level 2

You're welcome 🙂

Translate

Sign up