I want to end my long distance relationship

Hello everyone. I am a person that does not really believe in this kind of relationship. We met in our native country as friends, but I always had a crush on him. He never saw me a anything more. I moved to the US and he found me on FB and we communicated often. He lives in Mexico. He then told me after a year of frequent calls that he liked me and I was delighted, so I said yes that I wanted to be his long distance girlfriend even though I didn't really believed in that, which he knew. He convinced me and we gave it a go, with the thought that I can tell him if I want it to stop. I thought that maybe we were going somewhere, but I realized recently that is not going anywhere since he wants to live in Spain and I want to stay in the US. Also, he told me not too long ago that he planned to visit me and stay for a week and I was not thrilled by this (I just pretended I was). Thank s would be his first visit after 2 years of "relationship". I don't want him to spend his vacation in visiting me to be honest. I don't think I share his romantic feelings anymore. I'm afraid of losing him as a friend if I say this to him. He helped me a lot while I was in a bad place and I'd like him to stay in my life somehow.