"When allowing costumers to upload multiple images in this form, the entries come out as e.g. 5 links in the same field in Google Sheets and not as 1 link in 5 different columns/fields. That's very hard to work with. How do we get them seperated out?"

Question

&quot;When allowing costumers to upload multiple images in this form, the entries come out as e.g. 5 links in the same field in Google Sheets and not as 1 link in 5 different columns/fields. That's very hard to work with. How do we get them seperated out?&quot;

Vipin · Accepted Answer

Hi Tine, When you sync Google Forms responses to Google Sheets, it records multiple file uploads for a single question in the same cell, separated by commas. Google Forms does not natively support splitting these into separate columns automatically.

Instead of adding a file upload question with the option to upload up to 5 files, you can add 5 separate file upload questions in the form. Or, you can use Google Sheets functions to split these links into separate columns.

Guesswork

When allowing costumers to upload multiple images in this form, the entries come out as e.g. 5 links in the same field in Google Sheets and not as 1 link in 5 different columns/fields. That's very hard to work with. How do we get them seperated out?

Comments (1)

Add your comment

When allowing costumers to upload multiple images in this form, the entries come out as e.g. 5 links in the same field in Google Sheets and not as 1 link in 5 different columns/fields. That's very hard to work with. How do we get them seperated out?

Comments (1)

Add your comment

Related questions