Bug: CSV import tables incorrectly splits cells when values contain commas

Need help
1

Note: This problem was previously reported at Tables Limits & Importing CSVs 📝 - #6 by GunnerJnr

I’ve found an issue when importing CSV files that contain cells with comma values. The import process incorrectly interprets commas within quoted fields as column separators, which breaks the data.

  1. Original CSV file contains properly quoted values with commas:
    image
Column A,Column B,Column C
"1, 2",3,4
5,"6, 7",8
9,10,"11, 12"

  1. Activepieces table structure:
    image

  2. Import process:
    image

  3. Resulting broken table:
    image

Expected behaviour:

Values within quotes in CSV files should be treated as a single cell regardless of commas inside the quotes.

1 Like
2

@Dennis,

Glad it isn’t just me, I made a post about this also, in this thread: Tables Limits & Importing CSVs 📝 - #6 by GunnerJnr

1 Like
3

Haha, yes exactly. I didn’t see your comment earlier, but I recently tried importing a CSV and it did not go as expected. Looks like it’s not just you!

1 Like
4

@Dennis,

Hopefully, it gets resolved.