CSV report is not splitting filters into different columns, just separated by commas. | Community
Skip to main content
July 27, 2022
Solved

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

  • July 27, 2022
  • 3 replies
  • 1014 views

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.
Best answer by Jennifer_Dungan

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:

 

3 replies

Jennifer_Dungan
Adobe Champion and Community Advisor
Jennifer_DunganAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
July 27, 2022

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:

 

July 27, 2022

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

Jennifer_Dungan
Adobe Champion and Community Advisor
Adobe Champion and Community Advisor
July 27, 2022

You're welcome 🙂