Currently Being ModeratedJan 14, 2013 6:47 PM (in response to JLyn53)
Have you tried downloading it as an Excel file and then opening it with Numbers? That works for all of my 'simple' files.late-2012 27" i7 iMac, 32GB, 3TB Fu, OS X Mountain Lion, iPad '4'; ATV3; mid 2012 MBA;
Currently Being ModeratedJan 14, 2013 7:15 PM (in response to crh24)
Yes but with no luck. In example of a list of claims, I find an Excel icon with a "download" link on a website. If I click that link, the information then appears in my download area as Name.xls. If I open the document all I see is <TABLE><tr><... and import warning that this is a tab delimited document, and not a valid Excel document, and that data might look different.
I can click/expand the TABLE and see what appears to be the data with column headings and information separated by >< throughout. I really don't want to have to hand type all the info into Numbers so any suggestions appreciated. Would Excel for Mac be a reasonable avenue?
Currently Being ModeratedJan 14, 2013 10:17 PM (in response to JLyn53)
I'm using Numbers '09 version 2.3 (554)--purchased from the App store--and being an old Excel user I haven't had the time or inclination to really learn Numbers. I create all of my spreadsheets in Excel 2011 for Mac. I also read the files using Numbers so I can save them to the cloud where I can retrieve them for use with my iPhone and iPad. So far I have been able to use Numbers to read every Excel file I have created without a problem.
The file containing HTML (or more likely XML) icould be what is confusing Numbers. All of the files I create are binary and not text files.
Are there any other downloading options for your files?
Office 2011 for Mac works pretty well but then I only use it for simplistic things, I don't use all of the features of the various packages.late-2012 27" i7 iMac, 32GB, 3TB Fu, OS X Mountain Lion, iPad '4'; ATV3; mid 2012 MBA;
Currently Being ModeratedJan 15, 2013 6:06 AM (in response to crh24)
Same background here - I am a previous heavy duty Excel user (pre-Mac days) and also have Numbers '09 v 2.3 (554); it came with the iMac. No other downloading option for those files that I know of. Would really like to find something that works without trial and error/wasting money approach. If I expand the box of 'stuff' that appears once the data appears in Numbers, it is there but everything is interspersed with those >< symbols within one cell. I have also tried opening it as text - same result. Downloading and dropping onto the Numbers icon - same result. This should not be that difficult.
And the user guide for Numbers doesn't give an answer either. Guess I need something that gets into more detail...
Message was edited by: JLyn53
Currently Being ModeratedJan 15, 2013 10:06 AM (in response to Csound1)
I am using that approach - file open of an xls document. It opens in Numbers but all the data is in one cell with each piece interspersed with the >< symbols, actually </th><th> between content of every piece in what would be Column Headings, and later (in what would be cells under respective columns) the 'th' becomes 'TD'. From the user guide, it sounds as though all the data should go to respective column headings and cells in respective rows, but that isn't happening. And after opening in Numbers, the Document Warning message is still "Import Warning - This is a tab delimited document, not a valid Excel document. The data might look different."
Currently Being ModeratedJan 15, 2013 10:09 AM (in response to JLyn53)
Get a better spreadsheet, Excel is excellent and does not exhibit any of Numbers oddities, if Excel is too expensive then download Open Office, it is free and much better than Numbers at handling Excel files.
Currently Being ModeratedJan 15, 2013 10:13 AM (in response to Csound1)
Ah, that is what I was wondering. I don't object to getting Excel or Open Office but wanted to make sure they would do the job. Sales pitches are just that - pitches. I tend to want to know if what I want to buy will do the job Really don't want to go back to a totally Windows computer now that I have the Mac. Thanks for the advice.