2

(Using Microsoft Excel form Mac version 15.18)

Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is.

I need this so that I can output a CSV all on one line for a log output but with semi colons to mark where the line endings are.

Improve this question
2
  • And where would you specify them number of fields that have been processed, Tyson?
    – therobyouknow
    Commented Feb 22, 2016 at 14:25
  • I don't think it's possible in Excel, you need to replace ; to newline in a text editor.
    – Máté Juhász
    Commented Feb 22, 2016 at 21:10

1 Answer 1

Reset to default
0

This functionality only exists in the Windows version. On the Mac, you either have to do some upfront text manipulation or open the CSV file using the OpenOffice or LibreOffice spreadsheet application. These applications have a full-featured import dialog that opens when you read a CSV file. You can specify any delimiter character which you like. Then you can save the file in the .xlsm format and open it in Excel for Mac.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .