Share via

Missing Data | CSV | MAC

Anonymous
2018-04-25T01:44:17+00:00

Every time I open a CSV file on my apple device the cell content is either breaking or missing. For example, a cell contains150 characters on a windows device and when I open the CSV on my apple device the same cell contains roughly 30 characters.

Is there a setting that I must adjust on my excel? How can I resolve this issue?

I hope you guys can help me.

I am using the lastest version of excel 16.12

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-04-26T15:40:06+00:00

    CSV files behave differently depending on how you open them.

    If you open them from Excel's File > Open menu, you'll get a wizard that lets you parse the data.

    If you double-click or right-click>open in finder, you Excel tries to figure it out for you.

    Which way are you opening the file?

    2 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-26T23:06:17+00:00

    Hi Guys!

    Thank you so much!

    Yes, you are right Jim CSV files behave differently depending how you open them. It is perfectly working now. It is  just weird because I use my windows device most of the time and I dont have any issues on my CSV files.

    Also, thank you so much Jerry!

    Cheers,

    Edward

    0 comments
  2. Anonymous
    2018-04-26T06:41:09+00:00

    Hi Edward1230, 

    Have the issue about missing data in CSV solved?

    If you have any further questions at this time, please feel free to contact me.

    Regards,

    Jerry

    0 comments
  3. Anonymous
    2018-04-25T08:18:16+00:00

    Hi Edward1230, 

    Based on the description, please follow the following steps to troubleshooting:

    1. Please first restart your Mac and open the Excel to see the outcome.
    2. Run your Mac in Safe Mode to see whether the issue goes away.

    Disclaimer: *Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*​​

    If this issue still exists, please perform the steps bellow to help narrow the issue.

    1. Does the same issue happen when the file saved on Windows?
    2. If the issue happens with the specific file or all csv file?
    3. Please show us a screenshot of the normal csv file and the Data missed csv file.

    4. Try copy the same content in mac excel and save again, see if it’s character problem.

    1. Try copy the same content in online excel and download it, see if it’s character problem.

    In addition, I’d like to collect the Mac version for the further assistance.

    Regards,

    Jerry

    0 comments