How to Open & Browse a CSV File: Step-by-Step Tutorial
📄 Open the CSV Viewer and follow along with this tutorial.
Open Tool →Steps
This tutorial walks you through opening and exploring a CSV file using the free FinancialDataTools.com CSV Viewer. The tool parses your .csv or .tsv file entirely inside your browser using PapaParse — nothing is ever sent to any server.
Try the CSV Viewer — runs entirely in your browser and never uploads your files.
Open the CSV Viewer →Step 1: Locate Your CSV File
Find the .csv, .tsv, or .txt file you want to inspect. CSV files are used across virtually every financial platform:
- Brokerage transaction history and position exports
- Bank statement downloads
- Price history and market data from financial data providers
- Accounting exports from QuickBooks, Xero, or similar platforms
- Any delimited text file with column headers in the first row
The file must have column headers in the first row. Files without headers cannot be opened directly — add a header row before loading if needed.
Step 2: Open the CSV Viewer
Navigate to financialdatatools.com/viewers/csv-viewer/ in any modern desktop browser. No login, account, or installation is required.
Step 3: Load Your File
There are two ways to open your file:
- Click the green "Open File" button in the toolbar and select your file using the system file picker.
- Drag and drop your file anywhere onto the viewer window.
The viewer parses the file immediately using PapaParse. For most CSV files this is nearly instantaneous. Files with hundreds of thousands of rows may take a second or two.
The viewer automatically detects whether your file uses commas or tabs as its delimiter. The detected format appears as a CSV or TSV badge in the stats bar.
Step 4: Understand the Interface
Once your file loads, three key areas appear:
- Stats bar — shows the total row count, visible row count after filters, column count, the detected delimiter format (CSV/TSV), and any active filter badges.
- Column headers — each header shows the column name, an inferred type badge (NUM for numeric columns, TEXT for string columns), and a filter button. Click a header to sort.
- Data grid — rows from your file displayed in a spreadsheet-style table. Row numbers appear on the left. Numeric values are right-aligned and highlighted in blue.
Click any cell to open the Cell Detail Panel on the right, which shows the full untruncated value and lets you copy it to the clipboard.
Step 5: Sort Columns
Click any column header to sort the table by that column:
- First click: sorts ascending (A → Z, smallest to largest)
- Second click: sorts descending (Z → A, largest to smallest)
- Third click: returns to original file order
A small arrow in the column header shows the current sort direction, and the header changes color to indicate the active sort column. Numeric columns (those detected as NUM) sort numerically rather than alphabetically — so a column with values 1, 2, 10, 20 sorts as numbers, not strings.
Step 6: Search and Filter Rows
The CSV Viewer offers two ways to narrow down rows:
Global search — type in the search box in the toolbar to instantly search across all columns simultaneously. Any row that doesn't contain your search term in any column is hidden. Results update as you type with no need to press Enter.
Column filters — click the filter icon (funnel) in any column header for column-specific filtering. Two modes are available in the filter panel:
- Values mode: A checklist of all distinct values in that column. Uncheck values to hide rows containing them. Use the search box inside the panel to find specific values quickly in long lists.
- Conditions mode: Apply a custom condition such as "contains", "begins with", "equals", "greater than", or "is empty". You can combine two conditions with AND or OR logic for advanced filtering.
Multiple column filters are combined with AND logic — a row must satisfy all active column filters to remain visible. The pink badge in the stats bar shows how many column filters are active; click it to clear them all at once.
Step 7: View File Info
Click the Info button in the toolbar to open the file info modal. This shows:
- Total number of rows and columns
- The detected delimiter (Comma or Tab)
- A column overview listing each column name and its inferred type (NUM or TEXT)
Use the Copy Column List button to copy the column names and types as plain text — useful when setting up an import template or target database table to match your CSV structure.
Step 8: Export Your Data
Click the Export button in the toolbar to open the export dialog. Four formats are available:
- CSV — re-export as a properly quoted CSV file, useful for cleaning or filtering before re-importing
- JSON — array of objects with column names as keys, ideal for developers or API workflows
- Excel (.xlsx) — a workbook with a frozen header row and auto-sized columns, ready to share
- TSV — tab-separated export, useful when values may contain commas
Two export scopes let you control what gets exported:
- Filtered view — exports only the rows currently visible after applying your search and column filters
- Full file — exports all rows from the file, ignoring any active filters
Tip: Use the Filtered view export scope to export only the rows matching your current filters — a fast way to extract a subset of a large CSV into a new file without writing any code.