As I saw this question I started to write a meta collection about how to import data from Excel since this seems to be one of the most frequently asked questions. I try to start with simple scenarios and move up to more complicated ones - giving a short description. Most of these have been answered somewhere in the forum or on the hub - but it might be somewhat confusing searching for them.
I will expand these in the future: