CSV Encoding In Excel

Owned by Alex Do (Unlicensed)
Aug 17, 2023
2 min read

spaceOS exports data in CSV files. It is organized, but to view it in a proper table in Microsoft Excel, you'll need to encode it first so that all symbols are displayed correctly.

To do that:

  • Open Microsoft Excel

  • Go to the Data tab

  • Click on the Get Data -> From Text/CSV

  • Choose the File Origin (Unicode UTF-8) and delimiter and click Load

To save the file as Excel Workbook with UTF-8 encoding:

  • Click on File and select Save As

  • Choose the file type Excel Workbook (*.xlsx)

  • Click on More Options

  • In the dialog box, click on the Tools dropdown menu and select Web Options

  • In the Web Options dialog box, select the Encoding tab and choose Unicode (UTF-8) from the dropdown menu

  • Click OK to close the box, and then click Save

Â