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

Introduction

This article is intended to assist PC 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 Clock and Region settings

3. Select Region

4. Select Additional Settings

5. In the Customize Format window, use the drop-down box to select the comma for the List Separator setting on the Numbers tab

6. Click OK to save your selection on the Customize Format window

7. Click OK on the Region window

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