Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Highly Technical Question

Oct 2, 2006 3:41AM PDT

Hi,
I am using Excel in MAC. My company is using a system that accepts CSV files as saved formats for uploading to an internal database. This function has no issues in Windows. In MAC however, after saving the file as Windows CSV, the file does not have the carriage return and line feed at the end of the file. Without this final carriage, the file is failing as our system is set to read that as the end of the file. I have already tried saving as a CSV comma delimited, but it causes more issues. So in this format, working from a Mac, does anyone know how to have the carriage? I can do it in windows, (By deleting the last line in CSV and reinserting,) but we are trying to find a MAC solution.

Discussion is locked

- Collapse -
First thought? UNIX2DOS for Mac. Links.
Oct 2, 2006 3:44AM PDT
- Collapse -
Response
Oct 2, 2006 4:49AM PDT

How will this help? I can read the file in DOS which is how I can see the missing carriage. What will this do?

- Collapse -
Hint: it adds what you want.
Oct 2, 2006 5:13AM PDT

It's a very common issue.

bob

- Collapse -
Excel in Mac
Oct 2, 2006 4:48AM PDT

You don't mention what version of Excel or what version of the Mac OS you are using.
I seem to recall, I'll be able to check later, that there was an option in Excel that enabled you to choose what end of record and EOF functions to use.

P

- Collapse -
Excel
Oct 2, 2006 5:16AM PDT

Excel 2003 Mac OS X 10.3.9

Excel in Mac gives that option? Where?