Csv file field size limit

Question

I was wondering if there is a limit on the size of one field that can be saved in the csv file? I understand that the size of the CSV file itself depends only on the operating system.

Thanks.

Answer 1

The history of CSV is described on Wikipedia . The closest to the formal specification of the CSV file format is RFC4180 .

None of these documents describe any restrictions on the size of the field. In practice, the tools you use may have some limitation, since most CSV parsers will buffer the recording line before it is split.

Answer 2

Specifications and Limits Excel Excel cannot read more than 32767 characters in a single cell. Total number of characters a cell can contain: 32,767 characters

Answer 3

The new Google Sheets limits you to 50,000 characters / fields. You will receive an error message (see below) if you try to insert more than this.

If you download .csv, there is no warning, but the violation field and all the following fields on this line are discarded.