Skip to content

Export CSV files to Excel

Jump to bottom
Mika Tompuri edited this page Dec 15, 2022 · 2 revisions

This page is guide for opening CSV files downloaded from courses.mooc.fi so that the data is easily editable in Excel. Notice that if you simply open the CSV file by double clicking it, the CSV file will be opened in a format that is hard to edit.

  1. Download the CSV file you'd like to view or edit from courses.mooc.fi.
  2. Open MS Excel.
  3. On the Data tab select From Text (see image below)

2022-12-15_excel_data_from_text

  1. In the dialog that opens (Import text file) select the file you want to open and click Import.
  2. In the Text Import Wizard set the following:
  • File type: Delimited
  • Fire origin: 65001 : Unicode (UTF-8) (Start from the bottom and scroll up to find this faster)
  • My data has headings: check the box (see image below)

2022-12-12_text_import_wizard_step-1

  1. Click next.
  2. Check comma as delimiter. Uncheck tab from the list of delimiters. (See image below). Click next.

2022-12-12_text_import_wizard_step-2

  1. On the last page of the Text Import Wizard, click Finish
  2. On the Import data dialog that opens, click OK.

Your data should now be in an easily editable format. Remember to save your new file!

Clone this wiki locally