Bug report #20126

Importing Excel *.xlsm files as well

Added by Haitham Shatti over 5 years ago. Updated about 5 years ago.

Category:Data Provider
Affected QGIS version:2.18.24 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:no timely feedback
Crashes QGIS or corrupts data:No Copied to github as #:27947


  • QGIS can recognize *.xlsx files by dragging and dropping however it doesn't recognize *.xlsm (Macro Enabled) files (despite that it has the same xlsx structure) unless the extension is renamed to *.xlsx
  • When importing an Excel file, QGIS recognize the headers only if the second row was not empty and contains a number in the 2nd row, can this "Has header" be an optional check in the sheet import dialog instead of auto detect?.


#1 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Open to Feedback

does OGR (try ogrinfo) recognize such format?

#2 Updated by Jürgen Fischer about 5 years ago

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#3 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Also available in: Atom PDF