File Formats

CSV

This is one of the oldest and most common file formats, it does have some serious issues but it's flexibility and cross platform compatibility make it a frequent lowest common denominator.

Recently I have been using CSV files with Microsoft Excel and a couple of noteworthy points came to light. First Microsoft Excel cannot cope with numbers longer than 15 digits. Oh and it does not warn you about this, it will just take the first 15 digits starting from the left and drop the rest. Secondly it is hard to get ID numbers with leading zeros into Excel as text, this is true with mobile phone numbers for example but also IDs like 0001, which becomes 1. There are two options, you can write ="01" into your CSV file or "="01"", which whilst looking odd does actually work.

Markdown

Files with the extension ".MD" which contain Markdown are becoming increasingly common. GitHub uses them as does Stash from Atlassian. However GitHub openly admit they use their own format of Markdown. Here are some handy hints:

  • New Line: this is achieved by typing space, space, enter
  • New Paragraph: you need two new lines for this
  • Bullet List: start the line with "- ", "+ " or "* ", any will do
  • Numbered List: I would recommend starting all the items with "1. " that way they all come out with their own unique number and reordering is easy
There is some good documentation at Daring Fireball: Markdown which is the "original" Markdown, however there are several variants and it is not always clear which is in use. Use Mastering Markdown · GitHub Guides for "GitHub Flavoured Markdown" or GFM. Atlassian | Software Development and Collaboration Tools use CommonMark. I believe the community is moving towards CommonMark as the accepted standard, for example GitHub are moving that way.

If you visit Babelmark 2 - Compare markdown implementations and try your Markdown, you will see how different engines parse things slightly differently, but this is a helpful resource.