How to Open a CSV File Online or on Desktop

Opening CSV files sounds straightforward, but using default applications like Excel can cause unintended data corruption—such as stripping leading zeros from zip codes or converting long ID numbers into scientific notation (e.g. `1.23E+11`).

### 1. Open CSV in Your Web Browser (Safest & Fastest)

Using a browser-based utility like **OnlineCSV** guarantees your data is displayed without implicit type conversions:
1. Navigate to the [OnlineCSV Viewer](/csv-viewer).
2. Drag and drop your `.csv` file into the drop zone.
3. View, search, filter, and inspect your data with frozen headers and instant search.
4. Your file stays private on your local machine.

### 2. Open CSV in Microsoft Excel

To prevent Excel from corrupting IDs or dates:
1. Open a blank Excel workbook.
2. Go to **Data > Get Data > From File > From Text/CSV**.
3. Select your CSV file and click **Import**.
4. Set Data Type Detection to **Do not detect data types** to preserve exact values.
5. Click **Load**.

### 3. Open CSV in Google Sheets

1. Open Google Sheets and create a blank spreadsheet.
2. Click **File > Import > Upload**.
3. Select your CSV file.
4. Set **Convert text to numbers, dates, and formulas** to *No* if you wish to preserve exact raw strings.