fantastic, I've just downloaded OpenOffice, copied my excel values into the Open spreadsheet and created the csv and everything works just fine. Thanks!
Marc Dupuis-Désormeaux, Ph.D. candidate, Biology (ecology and evolution) York University [email protected] On Dec 12, 2013, at 10:07 AM, Charlotte Whitham <[email protected]> wrote: I know, it's not the best, but I hear it's Mavericks fault? :( Yes it's very easy - you can just write click on the excel file and go to "Open with" and then choose Openoffice. Another friend told me the other way was to create .csv file in TextEdit but this was much more complicated, so I believe OO is the best option Good luck and all the best, Charlie On 12 Dec 2013, at 15:03, Marc Dupuis-Desormeaux <[email protected]> wrote: > Thanks Charlotte, I'll try that route. Is it easy to import a file from > excel into openoffice? Seems like a roundabout way to create a simple .csv > file! > > On Dec 12, 2013, at 9:54 AM, Charlotte Whitham <[email protected]> > wrote: > > Don't panic Marc! Although I completely understand as I did the same last > week (using QGIS 2.0.1 and Mavericks OSX). > > There appears to be issues with Microsoft Excel and Mavericks and creating > csv and txt files. > > The only way I found around it was to make my .csv file in OpenOffice and it > worked perfectly! > > Hope that helps! > > Cheers, > Charlie > > Charlotte 夏琳 Whitham > PhD Candidate > Beijing Forestry University > > Address: Mailbox no.159, College of Nature Conservation > C/O Dr. SHI Kun, Director of the Wildlife Institute, Beijing Forestry > University > 35, Tsinghua-East Road, > Beijing 100083 > China > Website: http://wi.bjfu.edu.cn/en > Email: [email protected] > China Mobile: +86 152 0130 9411 > QQ: 1745214168 > > Think green: do you really need to print this email? > > > Message: 3 > Date: Thu, 12 Dec 2013 09:32:43 -0500 > From: Randal Hale <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] Fwd: adding a CSV delimited text layer > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1"; Format="flowed" > > What if you specified a custom delimiter and used comma? I'm wondering > if something has changed in your file.... > > Can you share it? or is it sensitive? > > ----------------- > Randal Hale, GISP > North River Geographic Systems, Inc > http://www.northrivergeographic.com > 423.653.3611 [email protected] > <mailto:[email protected]> > twitter:rjhale > http://about.me/rjhale > > On 12/12/2013 08:53 AM, Marc Dupuis-Desormeaux wrote: >> >> HI! first time question. I am pretty comfortable with QGIS 1.8 but >> have just converted from 1.8 to 2.0.1 and apparently have lost my mind >> as I can't even upload a simple .csv file anymore. I am using OSX >> (Maverick). I have created my .csv file using excel in the usual way, >> by saving it from an .xlsx to a .csv as I've done many times in QGIS 1.8. >> >> The file is simple, the first row has the headings >> (DATE,SPECIES,AGE,SEX,GPSX,GPSY,COD) the rest is data but when I'm >> uploading the file QGIS is not reading each line but is treating all >> data as one long line of headings and therefore is not finding any data. >> >> Help! >> >> >> Marc >> >> >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user > > [Qgis-user] Fwd: adding a CSV delimited text layer > > On 12 Dec 2013, at 14:32, [email protected] wrote: > >> [Qgis-user] Fwd: adding a CSV delimited text layer > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
