I have some data ready to import and have configured the dataset to match the destination file. I will naturally run a complete export to ensure I have all the data backed up before running the import. Before I leap into importing the data (I always get apprehensive before doing such things for the first time) can anyone tell me will importing data simply add the imported data to the last case (row) in the dataset?
Smart thinking running a complete export of your data so you have it as a backup!
What will happen when you import the data is it will add all of the data as new responses. So for example, if you have 100 responses on your survey and your importing 100 new responses, you will then be left with 200 completely separate responses when the import is done.
If you’re wanting to update the 100 existing responses with new data from the spreadsheet, you’ll want to use the “Match on Response ID” option when you get to the mapping fields screen. This way when you’re done with the import, you’ll still have only 100 responses, but those 100 responses will have the new data that you imported into them.
Hope that makes sense and is helpful!