## How do I open a CSV file (Mac OS)?

Use this guide to open any CSV without any problems and also to use the optilyz Mailing List.

Using the column filters, for example, empty records/contents can be found and each column and record can be checked. Detailed information about the optilyz Mailing List can be found in [this article](https://help.optilyz.com/en/support/solutions/articles/43000658119-checking-the-quality-of-the-data-set-using-the-optilyz-mailing-list).

**Step 1**

To open a CSV file correctly, first open Excel and create a blank workbook.

**Step 2**

Select „Data“ in the ribbon.

**Step 3**

Now click on „Get External Data“ in the ribbon.

**Step 4**

Next click on „From Text“.

**Step 5**

Select the file you want to open.

**Step 6**

In the first step in the opened window select the file origin in order for all special characters to be displayed correctly, as shown in the pictures below (for a “recipients” file the file origin is “Unicode (UTF-8)”).

**False file origin:**

**Correct file origin:**

In the second step select the delimiter for the date being separated, as shown in the pictures below (for a “recipients” file the delimiter is “Comma”).

**False delimiter:**

**Correct delimiter:**

**Step 7**

Select “Text” as column data format for all columns and click on “Finish”.

**Step 8**

If a window pops up, click on “OK”.