How should a CSV file look?

What is the correct format for a CSV file?

A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.

What is the most common CSV format?

The version of Excel provided with Office 365 has the largest number of format options, including the largest number of CSV options.CSV UTF-8 (Comma delimited)CSV (Comma delimited)CSV (Macintosh)CSV (MS-DOS)Different CSV Formats - Excel ribbon tips

Why does my CSV file look weird?

If you have opened a csv file and found weird characters in it, chances are you are using Excel. All of WebCollects exports are in the "UTF8" character set, which covers all international characters correctly. Some versions of Excel have trouble opening csv files that use UTF8 format.