Excel reports on Mac issue

My first guess is that your system "CSV delimiter" option is different between the two computers. I don't know how to check this on Macs -- in Windows, it is something like "list separator" in "region and language" settings.

How are you opening the file? You might try renaming the file with a .txt extenstion, which should prompt Excel to bring up the text import wizard on opening. When it opens into one column, you should be able to execute a "text to columns" command to parse the data into columns using a comma as delimiter.

I suspect it isn't an error, as such. When I open your csv file on my Windows PC, it splits the data across the columns as you obviously want it. On checking the parameters for Text to Columns, the default delimiter is a Tab.

So, I'm guessing that it's something as simple as setting a default for your Excel configuration. However, I know nothing about Macs so I can't really offer advice there.

Having got the data into Excel, all in one column, have you tried using Text to Columns with a Tab as the delimiter? Might be worth a go.

Regards, TMS

Glad you were able to resolve the issue.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.