How to Open CSV Files | Step-by-Step Guide for Windows, Mac & Mobile

Received a CSV file but not sure how to open it? If you work with data, you've likely been there. This guide walks you through how to open CSV files on Windows, Mac, and mobile (iPhone/Android) with clear, step-by-step instructions.

What Is a CSV File?

CSV stands for "Comma-Separated Values" — a text file that separates data values with commas (,). The file extension is .csv, and CSVs are widely used for exchanging business data such as customer lists, sales records, and product catalogs.

Since the contents are plain text, CSVs can be opened in Excel, Google Sheets, Notepad, browser-based tools, and many other applications.

Opening CSV Files on Windows with Excel

The most common approach on Windows is opening a CSV in Excel. However, double-clicking may cause issues like leading zeros being dropped or values being converted to dates.

Method 1: Import via "Get Data" (Recommended)

For accurate data import, this is the reliable approach.

1. Launch Excel and open a blank workbook
2. Go to "Data" tab → "From Text/CSV"
3. Select the target CSV file
4. Verify the encoding and delimiter in the preview
5. Click "Transform Data" or "Load"

This method lets you specify data types per column, preserving leading zeros in phone numbers and postal codes.

Method 2: Double-Click to Open

Quick and convenient, but carries a risk of automatic data conversion. Fine for a quick look, but use Method 1 for editing business data.

Opening CSV Files on Mac

On Mac, double-clicking a CSV launches Numbers by default.

Using Numbers

1. Double-click the CSV file (Numbers launches automatically)
2. The data is automatically displayed in table format

Numbers is free but offers limited control over encoding and import settings.

Using Excel on Mac

If you have Excel for Mac installed, the workflow is similar to Windows:

1. Right-click the file → "Open With" → "Microsoft Excel"
2. Use the Text Import Wizard to set encoding and delimiter

Changing the Default App to Excel

To make Excel the default app for CSV files on Mac:

1. Right-click any CSV file → "Get Info"
2. Under "Open with," select Excel from the dropdown
3. Click "Change All"

Opening CSVs in Google Sheets

With a Google account, you can open CSVs for free without any installation.

1. Go to Google Sheets
2. "File" → "Import" → "Upload"
3. Drag and drop the CSV file
4. Confirm the delimiter setting and click "Import data"

Great for team collaboration and sharing. Note that files are uploaded to Google's servers, so exercise caution with personal or confidential data.

Opening CSV Files on Mobile (iPhone & Android)

Need to view a CSV on your phone? You can do it in the browser without installing any app.

iPhone

iPhones cannot display CSVs in table format with built-in apps alone. These options work well:

• Browser-based CSV Viewer (recommended): Open sakutto's CSV Viewer in Safari and select your file — instant table display, no app needed
• Google Sheets app: Install from the App Store to open CSVs
• Files app: Offers basic text-level viewing only

Android

Browser-based tools are the most convenient option on Android as well:

• Browser-based CSV Viewer (recommended): Open sakutto's CSV Viewer in Chrome
• Google Sheets app: Pre-installed on many devices
• Microsoft Excel app: The free version supports CSV viewing

The Fastest Way to Open CSVs — No Installation Required

A browser-based CSV viewer provides the same experience across every OS and device.

With sakutto's CSV Viewer, open any CSV in seconds:

1. Visit sakutto's CSV Viewer in your browser
2. Drag and drop the CSV file, or use the file picker
3. The data appears in table format automatically

Key Features

Safe for CSVs containing personal or confidential information.

Fixing Garbled Text in CSV Files

If opening a CSV produces unreadable characters, a character encoding mismatch is the cause.

How Encoding Mismatches Happen

CSV files use character encodings like UTF-8 or Shift_JIS. When the file's encoding differs from what the opening application expects, text appears garbled.

How to Fix It

• Use sakutto's CSV Encoding Converter (fastest): Drop the file in to convert between UTF-8 and Shift_JIS in seconds
• Change encoding in Notepad: Open in Notepad → "Save As" → change encoding to "UTF-8 (BOM)"
• Specify encoding in Excel's "Get Data": Select the correct encoding in the preview during import

Changing the Default App for CSV Files

If double-clicking a CSV opens the wrong application, here's how to change it.

Windows

1. Open "Settings" → "Apps" → "Default Apps"
2. Find "Choose default apps by file type"
3. Locate .csv and select your preferred app (Excel, Notepad, etc.)

Mac

1. Right-click any CSV file → "Get Info"
2. Under "Open with," select your preferred app
3. Click "Change All" to apply to all CSV files

Frequently Asked Questions

What apps can open a CSV file?

Excel, Google Sheets, Numbers, Notepad, and browser-based CSV viewers can all open CSVs. As a type of text file, CSV requires no special software.

Why does my CSV show garbled text?

The file's character encoding (UTF-8 or Shift_JIS) doesn't match what the opening app expects. sakutto's CSV Encoding Converter resolves this with a quick conversion.

How do I open a CSV on iPhone?

Open sakutto's CSV Viewer in Safari and select the file. It displays instantly in table format with no app installation required.

Can I open a CSV without Excel?

Yes. Browser-based CSV viewers, Google Sheets, and LibreOffice Calc are all free options. sakutto's CSV Viewer runs in any browser with zero installation.

How do I change the default app for CSV files?

On Windows: Settings → Apps → Default Apps → change the .csv association. On Mac: right-click a CSV → Get Info → Open with → Change All.

Summary

CSV files can be opened in many ways across every OS and device. The key is choosing the right method for your environment.

Whatever method you choose, use sakutto's encoding converter for garbled text and sakutto's CSV Viewer for quick table-format viewing.