University of Alberta

Login Sign up

Changing Computer Setting to Automatically Open and Format CSV Files in Excel

Modified on: Fri, 24 May 2024 3:33 PM

Introduction

This article is intended to assist users who are attempting to open comma separated value (CSV) files automatically into Microsoft excel or similar spreadsheet programs formatted correctly. 

 


Applicability

The intended audience of this article is users who are encountering difficulties with their PC system opening CSV files automatically formatted into Microsoft excel or similar spreadsheet programs.

 


Procedure

  1. Open the Control Panel
  2. Select the Region settings
  3. Select Additional Settings
  4. For the List Separator setting, use the drop-down box to select the comma
  5. Click OK on the Customize Format window
  6. Click OK on the Region window

 

Comma separated value (CSV) files should now open automatically formatted into excel or similar spreadsheet program.

 


Keywords: csv, comma., separated, value, excel, spreadsheet, open, error, automatic, pc, settings, computer, laptop, bear tracks, instructor, final, grades, upload, download, roster, class, format, formatted, formatting, grade, approver
Was this answer helpful?