0
edits
Changes
no edit summary
In order to export data containing special characters to Excel use one of the procedures outlined below.
==Import Data==
* Open a blank worksheet in Excel
* From the '''Data''' menu select '''Import External Data''' followed by '''Import Data'''
::* This will vary slightly depending on your version of Microsoft Excel. Check the Microsoft Website or Help Menu in Excel for assistance.
:[[File:ExcelImportData.png]]
* Browse to the location of the exported report .txt file and click '''Open'''
* Select '''Unicode (UTF-8)''' as the '''File Origin''' and click '''Finish''' (UTF-8 normally appears near the bottom of the list)
:[[File:ExcelFileOriginUTF8.png]]
* Choose the cell you wish to place the data and click OK.
==Copy and Paste from Notepad/Wordpad==
'''Note:''' Notepad will not open very large reports, so another text editor such as Wordpad or Notepad++ should be used. Microsoft Word is not recommended.
'''Note:''' When using the Copy and Paste method for '''csv''' exported files you will need to use the '''Text to Columns''' function of Excel after following the above procedure.
==See Also==