Excel 365 truncates data import at column 8 for semicolon delimiter

[Glent7760]

Excel 365 truncates data import of csv/text file at column 8 for a semicolon delimiter. Reducing csv/text file size causes truncation to column 2.

[#2]

solution use text import wizard instead of Data import