Work with a CSV or text file with special characters

Jump to section

Import a file into Microsoft Excel

Import a file into Notepad2

CSV or text files that you export from Möbius are permitted to contain special characters (Example — Japanese characters).

You can ensure that the special characters appear as expected when importing the desired file into Microsoft® Excel® or Notepad2 by selecting the correct encoding option.

NOTE: This method formats the CSV or text file with the correct BOM (byte order mark) so that special characters will appear properly.

Import a file into Microsoft Excel

To import a CSV or text file with special characters into Microsoft Excel:

  1. Open a new document in Microsoft Excel, and then select the Data tab.

  1. Select Get Data from the ribbon, then select From File and select From Text/CSV.

  1. Browse to file path where you have your CSV spreadsheet saved. Select the file and click on Import.

  1. A new window will open. Select the 65001: Unicode (UTF-8) option in the File Origin drop down menu. This will give you a preview of the data with the correct foreign/non-Latin characters. Click Transform Data.

  1. The Power Query Editor window will open. Click the drop-down menu of the table icon The table icon is a table in the upper left corner of the data table in the Power Query Editor in Microsoft Excel. in the upper left-hand corner of the data table and select the Use First Row as Header option.

  1. Click Close & Load in the upper left corner of the Power Query Editor ribbon.

  1. Select the File tab of the main Microsoft Excel ribbon and click Save As, and then select the Browse option. Save the file wherever you want and be sure to select CSV UTF-8 (Comma delimited)(*.csv) option from the Save as type drop-down menu.

  1. Click Save.

  1. Close Microsoft Excel and open the new saved file. The data now appears as expected with the non-Latin characters appearing correctly.

Import a file into Notepad2

To import a CSV or text file with special characters into Notepad2:

  1. Open a new document in Notepad2.

  1. Select the File menu and select Open. Browse to import the desired CSV or text file and click Open.

  1. Select the File menu and select Encoding, and then select the UTF-8 with Signature option.

  1. Save the Notepad2 file.

  1. Close Notepad2 and open the new saved file. The data now appears as expected with the non-Latin characters appearing correctly.

 

Not what you were looking for? Try these: