Changing Computer Setting to Automatically Open and Format CSV Files in Excel
Modified on: Fri, 24 May 2024 3:33 PMIntroduction
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
-
Open the Control Panel
-
Select the Region settings
-
Select Additional Settings
- For the List Separator setting, use the drop-down box to select the comma
-
Click OK on the Customize Format window
-
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