I was just wondering if it is possible to upload contacts using a spreadsheet that has drop-down fields. There is one logic factor that I upload and always end up spelling incorrectly, so want to eliminate this by being able to select from a drop down, but not sure if this will cause problems in the upload. I noticed that there is a warning to remove all formulas from your spreadsheet before uploading.
It actually sounds like you might be trying to accomplish 2 different tasks with one upload. Your contacts sheet should not need to have drop down fields.
The contact should be a unique record for each contact, so not understanding where the drop down comes into play.
But if you have a question that needs the drop down information you would do that in the specific question(s)