3

I'd like to create a Google Form where the user can upload a CSV and each line in the CSV populates a spreadsheet.

Is there any way to do this in Google Sheets?

1
  • Forms are normally for manual text entry, not for parsing uploaded CSV. Google Form certainly can't do that. You can make a spreadsheet editable, which would allow users to insert sheets by uploading their CSV. But this is somewhat different in that users would see each others' uploads; something you probably don't want.
    – user79865
    Dec 3, 2015 at 1:39

1 Answer 1

1

You could tell the user to upload their CSV to Dropbox (or similar) and to share it, and to enter link to their shared file into your Google Form.

Then have a script behind the Form which picks up the link, opens the file and copies/pastes the data into a spreadsheet of yours.

Now, I'm not the person to write this script. And it does depend on your users being smart enough to upload the file and share it. But in concept this should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.