TransWikia.com

Apple Mail adds blank rows to CSV file

Ask Different Asked by 01000101.sh on December 7, 2020

I’m having an odd problem. I’ve recently decided to try Apple Mail as my default mail platform. Everything is being great until a coworker noticed that the .csv files I send come out with blank rows in between.

  • This is the original file (randomly generated for this example).
    enter image description here

  • This is the file sent by another mail platform (Outlook Desktop for example),
    and opened with TextEdit app or Notepad in windows.
    enter image description here

  • This is the file sent with Apple mail on Mac, and opened with TextEdit app or Notepad in windows.
    enter image description here

I’ve been looking into resources, and apparently there is some different with formats using such as CR in Mac, and CRLF in windows but I still can’t answer this questions.

  1. Why does this happen?
  2. Is there a setting I can correct in Excel?
  3. Is there a setting I can correct in the Mail app?
  4. Will this happen with other types of files?

Any help on this is appreciated!

Note: File also has blank rows when opening in Excel, or Numbers after it was sent through Apple Mail. Before this, the file looks normal in all apps mentioned above.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP