I work on a MAC. Everyone in finance works on PCs. We download our credit card statements in .csv format, edit in Excel, save and send those edited .csv files to Finance. When they open the files I send from my MAC, there are blank lines between each line of actual data. We did not add those lines, so where do they come from and how do we fix this so it stops happening every month?
MacBook Pro 15”, macOS 10.15
For anyone else encountering this, looks like Saving As Macintosh Comma Separated (.csv) fixes the problem (in Office Excel 2019 for MAC).
For anyone else encountering this, looks like Saving As Macintosh Comma Separated (.csv) fixes the problem (in Office Excel 2019 for MAC).
Great advice from VikingOSX, but might try opening in...
Free LibreOffice, it handles MS Office files…
Apple macOS (Mac OS X)
The software and hardware prerequisites for installing on a Apple macOS computer are as follows:
• LibreOffice 6.3.x: macOS 10.10 (Yosemite) or higher
• LibreOffice 6.2.x: macOS 10.9 (Mavericks) or higher
• Intel processor
• 512 MB RAM
• Up to 800 MB available hard disk space
• 1024x768 graphic device with 256 colors (higher resolution recommended)
It is a recommended best practice to back-up your system and data before you remove or install software.
Notes:
• For certain features of the software - but not most - Java is required. Java is notably required for Base.
• Due to an issue, there are the following restrictions with Java: on macOS 10.10 and newer, JRE isn't found, JDK is required
• LibreOffice 4.3 can still run on OS X 10.6+, but please understand that this support ended when 4.3 was retired on May 27, 2015.
https://www.libreoffice.org/get-help/system-requirements/#Apple
Feature Comparison of LibreOffice v6.4 with Office 365/Office 2019 for Mac
https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office
Office 19 Excel for MAC is what we are working with on MAC OS Catalina, if that makes a difference. I've tried saving as both .csv and UTF-8 CSV both add the extra lines.
You don't mention if you are using Office 365 Excel, or Office 2019 Excel for Mac. If so, do either offer an export option to Microsoft Excel CSV as opposed to just UTF-8 CSV?
Macs by default are UNIX systems beneath the Finder, and the default line ending is newline, often abbreviated as LF. Excel on Windows expects the default Windows line endings which are carriage-return,linefeed pairs, often abbreviated to CRLF.
Good work, thanks for the report! :)
.csv files from MAC to PC - adding extra lines
