Issue with Excel import and missing columns when cells are empty

Hi everyone :waving_hand:

I’m using a Bubble plugin that converts an Excel file into a text string using *** as the column separator and , to separate rows.

The problem:
When a cell in the Excel file is empty, the plugin doesn’t add the *** separator for it, so the following data shifts into the wrong columns. This causes issues when I try to split the row by *** — I end up with fewer items than expected, and values get assigned to the wrong fields.

I know each row should have 13 columns, but since the separators are missing for empty cells (even in the middle), I can’t tell where the missing field is.

:backhand_index_pointing_right: Has anyone encountered this before? Do you know a way to reliably detect the missing column or fix the line structure inside Bubble?

Any ideas or workarounds would be really appreciated :folded_hands:
Thanks!

Ask the author to fix the issue or try a different plugin.

1 Like