empty cells don't have "",

[vitali-bc]

basically if a empty cell has "", it will be converter in , only... and it's wrong...
my code (but doesn't work)

    $csv = new \ParseCsv\Csv();  // Correct instantiation
    $csv->delimiter = ',';
    $csv->enclose_all = true;
    $csv->parseFile($filePath);
    
     foreach ($csv->data as &$row) {

        // Normalize empty cells to `""`
        foreach ($row as &$value) { 
            // Only change null or other empty-like values (excluding already empty strings) to ""
            if ($value === null || trim($value) === '') {  
                $value = ''; 
            }
        }
    }

[gogowitsch]

Could you attach the same file once as a correct CSV and once as a correct spreadsheet, for example a .ods, .xls or .xlsx file? By correct I mean the exact way you expect it.

That way, I can better understand what you expect.

If you want to preserve "" in cells, first try @jimeh’s suggestion below. If that doesn’t work at all and you control both producer and consumer of the files, maybe it helps to change the enclosing char using $csv->enclosure = "!";, assuming your file does not contain any literal ! characters. See https://github.com/parsecsv/parsecsv-for-php/blob/main/src/Csv.php#L106

[jimeh]

If you want two literal double quote characters as the value of a field, the correct way to encode them as CSV is to quote the field, and escape the double quotes, by making each one two double quotes:

id,name
1001,""""""
1002,"Johnny ""Two-Toes"" Smith"

The above would be parsed as:

[
  [
    'id' => '1001',
    'name' => '""'
  ],
  [
    'id' => '1002',
    'name' => 'Johnny "Two-Toes" Smith'
  ]
]