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?
Google-sheets – How to create a Google Form where the user can upload a CSV
google sheets
Related Topic
- Google-sheets – Google form to spreadsheet, create new column
- Google Sheets – Auto-Create and Name New Sheet from Google Form
- Google-sheets – How to send Google Form results to a particular sheet (“tab”) of a Spreadsheet
- Google-sheets – How to get the name of a colleague from the Google Account email address within a Google Sheet
- Google-sheets – How to transform a form created in Google Sheets into an App or something that can be used by multiple people that also autoupdates
Best Answer
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.