CVS files generated by Onpipeline are comma separated, according to the standard https://www.ietf.org/rfc/rfc4180.txt.
If you open the CSV file in Excel and the data is not formatted automatically (all data loaded in the first column), it means your O.S. default “list separator” is a semicolon or a tab.
You have 2 options to solve this:
– If you want to properly read the CSV every time you open the file with Excel, you can change the default list separator to a comma (,) in your O.S. system preferences. It depends on your O.S. but normally you can find this in “Regional and Language Options”.
– You can import the file by using the “Text Import Wizard”. Open Excel and go to the Data tab > Get External Data > From Text. Additional information can be found here: https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857