Yahaay CodeStash

How to open a semi-colon separated values file in MS EXCEL?

For Excel 2013:

  1. Open Blank Workbook.
  2. Go to DATA tab.
  3. Click button From Text in the General External Data section.
  4. Select your CSV file.
  5. Follow the Text Import Wizard. (in step 2, select the delimiter of your text)

Leave a Reply

Your email address will not be published. Required fields are marked *