Data Connections, From Web, File Type CSV, Unable to Connect Error (Excel 2016)

[EXWIP]

Hi,

I'm trying to import some data from the web using data connections and I keep getting this error: "Unable to connect. We encountered an error while trying to connect. Details: "External table is not in the expected format."" The link I'm trying to connect with is:

"https://socds.huduser.gov/permits/o...9.6&__utmt=1&__utmb=200893484.2.10.1599240639"

This is being generated from this website SOCDS Building Permits Database with the criteria
>CBSA's
>Monthly (preliminary)
>Atlanta, Austin
>All Years
>All Series

If anyone's curious, the data set is how many apartments have been permitted for construction in any given month in any given city.

Anyways, if I plug this url into a browser it give me the file I need. Now I just need excel to connect with it. Any guidance would be appreciated.

Thanks,

MV

 

[EXWIP]

Figured it out! When I got the error message it gave me the option to edit my web query. When I go to edit it gives me a new basic form option "open file as". The default setting is "excel workbook", but when I changed it to CSV, it worked!