Comma Separated Values are a great way to log multiple pieces of data into the same record. However there are some important points to note regarding formatting.
Generally speaking, if you have simple data types and commas between each value, you're all set. For more complicated situations where you need to embed commas or quotes, read on.
To embed a comma, you will need to use double quotes around the value. For spaces, quotes are not required. We also support the escape character \ (backslash) for embedding double quotes or backslashes directly into your values. If you want to ignore a line complete, e.g. the header line, simply prefix the line with a hash (#).
Here are some examples of valid CSV input:
# This line will be ignored
Field 1,Field 2,Field 3
Field 1,"Field 2, with comma",Field 3
Field 1,Field 2 with \"embedded quote\",Field 3
Field 1,Field 2 with embedded \\,Field 3