--- title: "How to save CSV files as \"UTF-8\"?" description: Learn how to save your CSV files using UTF-8 encoding to ensure proper character support in Virtualbadge. Follow simple steps for both Windows and macOS to avoid import errors. --- [Skip to content](https://help.virtualbadge.io/article/how-to-save-csv-files-as-utf-8#main-content) - [English](https://help.virtualbadge.io/article/how-to-save-csv-files-as-utf-8) - [Deutsch](https://help.virtualbadge.io/de/article/wie-speichert-man-csv-dateien-als-utf-8) English Show submenu for translations [Contact Support](https://help.virtualbadge.io/article/kb-tickets/new?hsLang=en) [![Virtualbadge.io White-2](https://help.virtualbadge.io/hs-fs/hubfs/logo/Virtualbadge.io%20White-2.png?width=300&height=40&name=Virtualbadge.io%20White-2.png)](https://www.virtualbadge.io/) Open main navigation Close main navigation - - [English](https://help.virtualbadge.io/article/how-to-save-csv-files-as-utf-8) - [Deutsch](https://help.virtualbadge.io/de/article/wie-speichert-man-csv-dateien-als-utf-8) English Show submenu for translations - [Contact Support](https://help.virtualbadge.io/article/kb-tickets/new) - [Go to Admin Dashboard](https://admin.virtualbadge.io/) [Go to Admin Dashboard](https://admin.virtualbadge.io/) Hello! How can we help you? - There are no suggestions because the search field is empty. 1. [Help Articles Virtualbadge.io](https://help.virtualbadge.io/article?hsLang=en) 2. [FAQs](https://help.virtualbadge.io/article/faqs?hsLang=en) 3. [Email & Delivery Issues](https://help.virtualbadge.io/article/faqs?hsLang=en#email-delivery-issues) # How to save CSV files as "UTF-8"? ## Ensure Successful Upload of Recipient Information If you're encountering issues uploading recipient information, it might be due to special characters, extra spaces, or incorrect CSV formatting. In this guide, we’ll show you how to save your CSV file as "UTF-8" to ensure smooth uploading of your recipient details for certificates or badges. Here’s why you might face issues when uploading recipient information and how to resolve it: Special characters or extra spaces in your CSV file can cause the upload to fail, or you might see an error code like **4332**. To avoid these issues, follow the steps below to ensure your CSV file is properly formatted. #### **Steps to Upload Recipients Correctly:** 1. **Download the Sample CSV** A quick and easy solution is to use the "Sample CSV" file. This file already contains the correct headings (dynamic fields) for the certificate or badge design, so all you need to do is enter your recipient details. The sample CSV is pre-formatted as **CSV UTF-8**, so you don't need to make any additional changes. ![](https://help.virtualbadge.io/hs-fs/hubfs/grafik-png-Jun-05-2024-09-31-07-5204-AM.png?width=334&height=321&name=grafik-png-Jun-05-2024-09-31-07-5204-AM.png) **2. Using Your Own Excel Sheet:** - **Save as CSV with UTF-8** If you’re working with your own Excel sheet, ensure that your file is saved as **CSV UTF-8**. This ensures compatibility with the system and prevents issues with special characters. Your CSV should include at least the recipient’s name and email, but feel free to add additional columns for any custom dynamic fields in your design. To save your Excel sheet as CSV UTF-8, follow the instructions in the image provided (or refer to Excel’s “Save As” option and choose **CSV UTF-8**). ![](https://help.virtualbadge.io/hs-fs/hubfs/grafik-png-Jun-05-2024-09-20-54-6693-AM.png?width=274&height=57&name=grafik-png-Jun-05-2024-09-20-54-6693-AM.png) To save your Google Sheets file as a CSV in UTF-8 format, follow these steps: 1. Click on **File** in the top-left corner of your Google Sheets window. 2. Select **Download** from the dropdown menu. 3. Choose **Comma-separated values (.csv, current sheet)**. This will export your file as a CSV, ensuring the proper formatting for upload. ![](https://help.virtualbadge.io/hs-fs/hubfs/google%20sheets%20csv-gif.gif?width=300&height=266&name=google%20sheets%20csv-gif.gif) - **Match Headings with Dynamic Fields** Make sure the column names in your Excel file match the dynamic fields you've used in your certificate or badge design. The column headings don't have to match exactly, but they should align with the dynamic fields in your template. This helps the system map the recipient data correctly when you upload the CSV. ![](https://help.virtualbadge.io/hs-fs/hubfs/Email%20mapping%20fields(1)-png.png?width=1116&height=493&name=Email%20mapping%20fields(1)-png.png) **3. Use Virtualbadge.io’s CSV Converter** If you haven't added recipients yet, you can use the **UTF-8 Converter** available in the **Recipients Tab**. To access it: - Go to the **Recipients Tab** in your account. - Click on the **UTF-8 Converter** and upload your Excel sheet.![](https://help.virtualbadge.io/hs-fs/hubfs/grafik-png-Jun-05-2024-09-23-25-3896-AM.png?width=688&height=40&name=grafik-png-Jun-05-2024-09-23-25-3896-AM.png) - Download the converted CSV file and re-upload it. If you've already added recipients and want to convert your file, click **"Add Recipients"** in the top right corner, then select **"Add List"** and follow the same process. ![](https://help.virtualbadge.io/hs-fs/hubfs/image-png-Mar-17-2025-09-45-01-2255-AM.png?width=688&height=217&name=image-png-Mar-17-2025-09-45-01-2255-AM.png) By saving your CSV file as **UTF-8** and following these simple steps, you can ensure your recipient information is properly formatted and uploaded to Virtualbadge.io. This will help you avoid errors and guarantee that your recipients are correctly added to your certificates and badges.     - [Onboarding & Setup](https://help.virtualbadge.io/article/onboarding-setup?hsLang=en) - [Features](https://help.virtualbadge.io/article/features?hsLang=en#main-content) - [Managing Credentials](https://help.virtualbadge.io/article/features?hsLang=en#managing-credentials) - [Recipient Management](https://help.virtualbadge.io/article/features?hsLang=en#recipient-management) - [Email Delivery & Customization](https://help.virtualbadge.io/article/features?hsLang=en#email-delivery-customization) - [Sharing & Social Integrations](https://help.virtualbadge.io/article/features?hsLang=en#sharing-social-integrations) - [Security & Verification](https://help.virtualbadge.io/article/features?hsLang=en#security-verification) - [Insights & Reporting](https://help.virtualbadge.io/article/features?hsLang=en#insights-reporting) - [Credential Design](https://help.virtualbadge.io/article/credential-design?hsLang=en) - [Access & Share Credentials](https://help.virtualbadge.io/article/access-share-credentials?hsLang=en) - [Trainer Module](https://help.virtualbadge.io/article/trainer-module?hsLang=en#main-content) - [Trainer module settings](https://help.virtualbadge.io/article/trainer-module?hsLang=en#trainer-module-settings) - [Creating a Training](https://help.virtualbadge.io/article/trainer-module?hsLang=en#creating-a-training) - [Recipients in the Trainer Module](https://help.virtualbadge.io/article/trainer-module?hsLang=en#recipients-in-the-trainer-module) - [Integrations & API](https://help.virtualbadge.io/article/integrations-api?hsLang=en) - [Account & Billing](https://help.virtualbadge.io/article/account-billing?hsLang=en#main-content) - [Billing](https://help.virtualbadge.io/article/account-billing?hsLang=en#billing) - [Organisation Settings](https://help.virtualbadge.io/article/account-billing?hsLang=en#organisation-settings) - [User Settings](https://help.virtualbadge.io/article/account-billing?hsLang=en#user-settings) - [Element Library](https://help.virtualbadge.io/article/account-billing?hsLang=en#element-library) - [Organisation Hub](https://help.virtualbadge.io/article/organisation-hub?hsLang=en) - [FAQs](https://help.virtualbadge.io/article/faqs?hsLang=en#main-content) - [Credential Management](https://help.virtualbadge.io/article/faqs?hsLang=en#credential-management) - [Trainer Module](https://help.virtualbadge.io/article/faqs?hsLang=en#trainer-module) - [Email & Delivery Issues](https://help.virtualbadge.io/article/faqs?hsLang=en#email-delivery-issues) [![Chill listening crop-3](https://help.virtualbadge.io/hs-fs/hubfs/Virtualbadge.io%20Dark%20(2).png?width=181&height=24&name=Virtualbadge.io%20Dark%20(2).png "Chill listening crop-3")](https://www.virtualbadge.io/) Virtualbadge.io Help Center Copyright © 2026, FutureNext GmbH