[Resolved] Paragraph breaks and commas in post_content field mess up export of CPT data

[Author]

Posts

[reneV-2]

I am trying to: export the post data of CPTs created with Toolset Types, to CSV

Link to a page where the issue can be seen: hidden link

I expected to see: all text in the post_content field ending up in the same column, even when there are commas or paragraph breaks within that text

Instead, I got: consecutive paragraphs or text after commas ending up in the wrong columns

By the way, this occurs both with Ultimate Exporter Pro (which supports the latest version of Toolset Types) and WP All Export.

[Beda]

I tried to export all posts, pages and Custom Posts with Post Content and I see no such issue.

Please can you explain how to achieve this problem?
Eventually this is due to some issue in the export plugin?
I used WP All Export version 1.2.0 and it worked great.

I used native settings and post types with post body.

The CSV you provided will not help us to determine the issue, as we would need to run the export to see what happens.

Could you try this without any other Plugin and no custom code, and a native WordPress Theme?
If then this fails, I would probably need a copy of your site or database at least.
https://toolset.com/faq/provide-supporters-copy-site/

[reneV-2]

Hi Beda, thanks for getting back! It appears the issue is caused by the way Excel handles .csv files when importing them via Excel > Data > From text. The author of Ultimate Exporter Pro suggested using Google Sheets, and that actually worked like a charm!