Method and limits
Why a CSV can open in one column
CSV exports may use commas, semicolons, tabs, or pipes depending on their source. If the application expects a different delimiter, all fields can appear together. Check the preview for the column layout you expect before downloading the workbook.