Changes

Jump to: navigation, search

Open CSV in Excel

898 bytes added, 13:31, 5 April 2015
no edit summary
Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.}}
<ol><li>[[ExportSearch Result]].</li><li>Open a new Excel file.</li><li>Open the .CSV file with a text editor e.g. Notepad++.</li>Copy[[Image:Csv copy text.png|500px|center]]Select cell A1<div align="center"> Method 1Click on Paste buttonSelect ''Use Text Import Wizard"Copy '''all''' text''</div>Method 2Paste into ExcelSelect column <li>Copy all rows with Ctrl+A.</li>Use function ''Text <li>Switch back to columns'' on Data ribbonExcel and click in cell A1.</li>
<li>Open the Text import wizard by one of following methods:
[[Image:Csv paste method.png|175px|center]]
<div align="center">
'' Paste method''
</div>
: '''Paste method'''
<ol type="1">
<li>Click on lower part of the Paste button.</li>
<li>Select ''Use Text Import Wizard'' in the drop-down menu.</li>
</ol>
: '''Text to Columns method'''
<ol type="1">
<li>Paste into Excel with Ctrl+V.</li>
<li>Select column A.</li>
[[Image:Csv text to columns method.png|500px|center]]
<div align="center">
'' Text to Columns method''
</div>
<li>Use function ''Text to columns'' on Data ribbon.</li>
</ol>
Same steps
<li>The wizard starts[[Image:.png|500px|center]]<div align="center">'' Country ''</div><li>Click '''Next'''<li>Change ''Delimiters'' to '''Comma'''[[Image:.png|500px|center]]<div align="center">'' Country ''</div><li>Click '''Next'''<li>Change ''Column data format'' to ''Text'' and verify that the format is set[[Image:.png|500px|center]]<div align="center">'' Country ''</div><li>Click '''Finish'''<li>Save as xlsx<li>Close and open the file in order to verify that the data still has the correct format</ol>
{{NavBox Technical Notes}}
[[Category:NAA]]
6,632
edits

Navigation menu