To ensure that your CSV file displays international and special characters correctly across browsers and systems, it's crucial to save it with UTF-8 encoding. Here's how to handle this in both Microsoft Excel and Google Sheets:
Using Microsoft Excel
Current Versions of Excel:
Open your CSV file in Excel.
Go to the "File" menu and select "Save As."
Choose "CSV UTF-8 (Comma delimited) (*.csv)" from the "Save as type" dropdown menu.
Click "Save."
This option ensures that your CSV file is saved with the correct UTF-8 encoding.
Older Versions of Excel (e.g., Excel 2007):
Open your CSV file in Excel.
Click on the "File" menu and select "Save As."
In the "Save As" window, click the "Tools" button (located near the "Save" button).
Select "Web Options" from the dropdown menu.
Go to the "Encoding" tab.
Choose "Unicode (UTF-8)" from the "Save this document as" dropdown menu.
Click "OK" and then "Save."
Note: For versions prior to Excel 2007, UTF-8 encoding support may be limited. In such cases, using another tool or method to ensure proper encoding is recommended.
Using Google Sheets
Create a new Google Spreadsheet.
Go to the "File" menu, select "Import," and then choose "Upload."
Upload your CSV file from your computer.
Once the file is imported, go to the "File" menu again and select "Download as."
Choose "Comma-separated values (.csv, current sheet)."
The downloaded file will now be a properly encoded CSV file with UTF-8 format.
By following these steps, you can ensure that your CSV files are correctly encoded and that special characters are displayed properly across different platforms and systems.