Skip to content

Instantly share code, notes, and snippets.

@MrDOS
Last active February 3, 2017 16:38
Show Gist options
  • Select an option

  • Save MrDOS/f53853c4b4fbe3c60f941ab2676374b9 to your computer and use it in GitHub Desktop.

Select an option

Save MrDOS/f53853c4b4fbe3c60f941ab2676374b9 to your computer and use it in GitHub Desktop.
CSV Export is Awful in Excel for Mac 2016
Col 1 Col 2
Let's call this "1" I don't believe you
2 This field contains a newline
3, alright Sacré bleu!
We can make this file beautiful and searchable if this error is corrected: Any value after quoted field isn't allowed in line 2.
Col 1,Col 2 "Let's call this "1"""et",I don't believe you 2,"This field contains a newline" "3, alright",Sacré bleu!
Col 1 Col 2
Let's call this "1" I don't believe you
2 This field contains a newline
3, alright SacrŽ bleu!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment