Calc csv limits for columns

there are columns to CA, but on opening I received a message saying I exceeded the maximum columns. It only imported to BU.

Columns up to AMJ (i.e. 1024 columns) are available, but your CSV data may be malformed with embedded separators but unquoted field content, or you chose a wrong separator, for example ticked blank as well and field content text has blanks. Hard to tell without seeing the actual data.

That turned out to be the case. The data had non-displayed characters that was breaking the text quote pairs. After scrubbing the incoming text to remove any of these characters, it opened without error. Thanks