Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm trying to open an .xlswith QGIS 1.8 in a Mac, I'm loading the vector layer from Add new vector layeretc. etc. the procedure works in Windows but not in Mac where I have an error Invalid source file. Where is the problem?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

You can use the XY Tools QGIS plugin to load .XLS files just fine on the Mac. You do, however, need to install some required Python libraries.

Open a Terminal window and enter:

sudo easy_install xlrd

You'll need to give your admin password, then the xlrd Python library will install. Then:

sudo easy_install xlwt

You can then open an XLS file (but not XLSX it seems) as a point file.

Tested working on Mac OS X 10.8.5, QGIS 2.0.

share|improve this answer

Sounds like a missing library. One workaround would be to open the file in another spreadsheet program like LibreOffice's Calc and save it as a csv or tab delimited text file. Here's the installation steps for the Mac version of LibreOffice:

https://www.libreoffice.org/get-help/installation/mac/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.