Displaying the Euro Symbol Correctly in Excel with Ad Badger CSVs

When opening CSV files downloaded from Ad Badger software in Excel, you may notice that the euro currency symbol (€) is incorrectly displayed as €. This is due to a difference in character encoding between the CSV file and Excel's default settings.

Here is the way to ensure the euro symbol displays correctly:

1. Launch the Text Import Wizard:
   1. Open Excel.
   2. Go to the Data tab.
   3. In the Get External Data section, click From Text/CSV.
   4. Locate and select the UTF-8 file you want to import.
   5. Click Import.
2. Specify File Origin and Delimiter:
   1. In the Delimiter section, select Comma delimited.
   2. Under File Origin, choose 65001: Unicode (UTF-8) from the dropdown list.
   3. Click Load.

If you have further questions or require additional assistance, don't hesitate to reach out to our PPC team. We're here to help you make the most of your campaigns!