On some operating systems, opening the csv file in Excel misrenders any special characters in the data (for example, characters with accents). If you are working in the newest version of Excel, you can take the following steps to ensure that special characters appear as intended:
- Open a blank workbook in Microsoft Excel
- Under the Data tab, navigate to Get Data (Power Query)
- A pop-up window will open. Select Text/CSV and then click Browse to select and upload the applications.csv file you downloaded
- Click Next
- A Preview file data window will open. Confirm that following settings are selected:
- File origin: 65001: Unicode (UTF-8)
- Delimiter: Comma
- Data type detection: Based on first 200 rows
- Click Load
In older versions of Excel, you can achieve the same results by taking the following steps:
- Open a blank workbook in Microsoft Excel
- Under the Data tab, navigate to Get External Data > From Text
- A pop-up window will open. Select the applications.csv file you downloaded
- Click Get Data
- A Text Import Wizard window will open. Select Delimited. From the File origin drop-down menu, select Unicode (UTF-8)
- Click Next >
- Under Delimiters, select Comma
- Click Next >
- Under Column data format select General
- Click Finish
- A pop-up window labeled Import Data will appear. Select the sheet where you want the data to be imported to and click OK
Comments
0 comments
Article is closed for comments.