Importing old xls files into Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1606462%22%20slang%3D%22en-US%22%3EImporting%20old%20xls%20files%20into%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606462%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20...%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20a%20query%20of%20this%20file%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.nordpoolgroup.com%2Fglobalassets%2Fmarketdata-excel-files%2Felspot-prices_2020_hourly_nok.xls%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nordpoolgroup.com%2Fglobalassets%2Fmarketdata-excel-files%2Felspot-prices_2020_hourly_nok.xls%3C%2FA%3E%26nbsp%3Binto%20Excel%20365%2C%20but%20it%20seems%20to%20be%20a%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20comments%20I've%20got%20is%20that%20this%20is%20not%20a%20real%20xls-file.%3C%2FP%3E%3CP%3EOthers%20says%20that%20Microsoft%20have%20prevented%20any%20query%20from%20older%20xls-format.%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20this%20query%20to%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1606462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606683%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20old%20xls%20files%20into%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106948%22%20target%3D%22_blank%22%3E%40%C3%98yvind%20Granberg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20workbook%20is%20actually%20a%20HTML%20file%20(web%20page)%20that%20has%20been%20saved%20with%20extension%20.xls.%3C%2FP%3E%0A%3CP%3EYou%20can%20open%20it%20in%20Excel%20(tell%20Excel%20to%20open%20it%20anyway%20when%20it%20displays%20a%20warning).%3C%2FP%3E%0A%3CP%3EIf%20you%20then%20press%20F12%20to%20display%20the%20Save%20As%20dialog%2C%20you'll%20see%20that%20Excel%20wants%20to%20save%20it%20as%20a%20HTML%20file%20(web%20page)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3482.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214165i4DAFE62AE9C846A5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3482.png%22%20alt%3D%22S3482.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3EChange%20the%20file%20type%20to%20Excel%20workbook%20(*.xlsx)%20to%20save%20it%20as%20a%20%22real%22%20workbook.%20You%20can%20then%20use%20this%20in%20your%20query.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606708%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20old%20xls%20files%20into%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20an%20quick%20answer.%3C%2FP%3E%3CP%3EBut%2C%20I%20can't%20set%20this%20file%20up%20as%20a%20query%20in%20Excel%20365.%3C%2FP%3E%3CP%3EI'll%20get%20get%20an%20message%20that%20it%20can't%20be%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606797%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20old%20xls%20files%20into%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106948%22%20target%3D%22_blank%22%3E%40%C3%98yvind%20Granberg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20tried%20opening%20the%20.xls%20file%20in%20Excel%2C%20saving%20it%20as%20.xlsx%20and%20then%20using%20the%20.xlsx%20file%20in%20your%20query%2C%20instead%20of%20the%20.xls%20file%20that%20doesn't%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606924%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20old%20xls%20files%20into%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20...%20It%20works%20okay%20this%20way%2C%20but%20I%20hoped%20to%20avoid%20this%20detour.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi ...

I am trying to set a query of this file, https://www.nordpoolgroup.com/globalassets/marketdata-excel-files/elspot-prices_2020_hourly_nok.xls into Excel 365, but it seems to be a problem.

 

Some comments I've got is that this is not a real xls-file.

Others says that Microsoft have prevented any query from older xls-format.

How can I get this query to work?

4 Replies

@Øyvind Granberg 

The workbook is actually a HTML file (web page) that has been saved with extension .xls.

You can open it in Excel (tell Excel to open it anyway when it displays a warning).

If you then press F12 to display the Save As dialog, you'll see that Excel wants to save it as a HTML file (web page):

 

S3482.png

Change the file type to Excel workbook (*.xlsx) to save it as a "real" workbook. You can then use this in your query.

@Hans Vogelaar 

Thanks for an quick answer.

But, I can't set this file up as a query in Excel 365.

I'll get get an message that it can't be done.

@Øyvind Granberg 

Have you tried opening the .xls file in Excel, saving it as .xlsx and then using the .xlsx file in your query, instead of the .xls file that doesn't work?

@Hans Vogelaar 

Yes ... It works okay this way, but I hoped to avoid this detour.