Sep 30 2020
I am trying to import data from web but I have problems to use it. I am using an Excel version of Microsoft 365 on Mac.
I have tried doing this without success:
1) I past the url of the website from which I need the data on a word new document, leaving a few spaces.
2) I saved it as a .txt file and then change the file extension to an .iqy file.
I saved it as MS DOS file with line spaces.
I saved it in the queries folder. (There are also 2 sample .iqy documents that I didn't create. They are from microsoft.
3) I opened my new excel spreadsheet and went to the data toolbar > Get external data > Run web query.
It opened the Queries folder where appeared the file that I had created and these 2 MS sample files that I hadn't save it that I mentioned in 2.
Here comes the problem: I can't select the .iqy files that I created because they are "greyed out".
I can see them but they are impossible to select since they are greyed out.
Though I can select the 2 sample MS files and enter the data that are in it in my excel. But with my files, I just can't.
How can I change the files so they are not greyed out?
Can someone help me with this?