There is a work around which might work without using Windows. Do you have Office 2011 (Excel 2011) installed on your Mac ?
If you have Excel, then there is a option to save a Mac CSV to Windows which might work on the website. Let me know if you have Excel and we can try that first.
I just received this advice fro another source - what is your opinion?
sorry I forgot to include the advice
Hello,I would recommend not using Crossover and instead get TextMate http://macromates.com/ and open your .csv files in that and then do a File>Save As and you can set the returns to be Windows-style CRLF linefeeds. Your .csv should then open correctly in the Windows version of Excel.
Yes I have Excel for MAC 2008
And I would be MOST grateful to take you up on your offer in case I run into trouble with TextMate. I will install it tomorrow - it is getting late here in France ;) and will in any case let you know how I am doing.
I have tried to import the data from the website to an Excel file on my computer with the file formatting you suggested but apparently it did not work.
therefore I'll now buy the TextMate and try again with that. I'll let you know the result asap
I did download the trial version but have no idea how to use it.
May be my problem is that I first need to get the data (mailing lists) from a website to my computer (download and save) and then upload them into another website.
If you can guide me with either Excel or TextMate I would very much appreciate it.
Standing by ...
I was able to open them after chosing All Files
yes I can see the mailing list
Unfortunately the same problem: an error message: root element missing
Yes that's in the Excel dropdown menu - I'll try that and get back to you
Did all that but no success; what else can I try?
Web Service Error:
Server was unable to process request ---> Root element is missing
... I have no other CSV files to try; the ones I am working with are what I need to get loaded and analysed by the website.
I will grab some food and return to the screen promptly
When I select Open in TextMate it gives me the choice to open a fine ON MY COMPUTER. But I need to first get the Data from a website. If I download the data from the website onto my desktop the formatting changes and the problem is there just like with Excel.
How can I get the lists directly from the website into TextMate??
in fact I did download the data files again to the desktop and then into TextMate and that resulten in same problem. So I'll try your Safary in PC mode and get back to you...
I did everything, the Safari in IE mode, the TextMate save as etc. and i still have the same problem.
I have to take a break
If you have any other ideas ...?
There is also another application like Text Mate, the name of that app is File Maker. See here : http://www.filemaker.com/products/filemaker-pro/
I tried copy/pasting in Excel with no positive results
Now downloading trial of File Maker but have to get some sleep - will continue tomorrow
Thx for all the help so far