Probably the simplest way is to use an 'if' formula - import the data & then use if to exclude any data from the list that matches the query - if row/column = whatever,1,false.
BTW that isn't the syntax you need! I've typed out a very rough idea of how it looks, but excel would cringe at that - You'll have to do a little reading up in excel but it works well enough.
Another option is to use autofilter. If the unwanted data is always the same value or if you can append say, a letter to the unwanted data in the next row - for example n for no, then you can use autofilter to exclude any entry in a list that contains that value. This is more constricted & less flexible, but it is another way to do it.