How to Freeze or Pin Columns When Viewing a CSV
Keep your key columns anchored while you scroll sideways through a wide table — like Excel's Freeze Panes, but for any CSV, Parquet, SQLite, or Excel file. 100% offline on Mac & Windows.
Quick Answer
- ✓Pin columns to the left or right in FileHop — open a CSV, then use a column's menu or the pin button to Pin Left, Pin Right, or Unpin, so an ID, name, or date stays visible while the rest of the table scrolls.
- ✓It works on any data file, not just .xlsx — the same pinning works on raw CSV, Parquet, SQLite, and Excel, with no setup. By default the row-number column and first column are frozen on the left.
- ✓Pins are remembered per file and everything stays local. Reopen the same file and your pinned columns come back, and nothing is ever uploaded to a server.
Why freeze columns, and what does it do?
Once a table has 15-20 or more columns, the header labels and your key identifier column scroll off the screen the moment you move sideways, and you lose track of which row is which. Freezing the important columns — an ID, a name, a date — keeps them anchored on the left edge while the rest of the table scrolls past, so every value you read stays tied to the right record.
Excel solves this with Freeze Panes, but only for .xlsx workbooks — a raw CSV has no such feature, and neither do most quick viewers. FileHop does it for raw CSVs and other formats too, treating any tabular file the same way, and it remembers your pins per file so you don't have to set them up again next time.
How to freeze columns in FileHop
FileHop is a free desktop file browser with a built-in data viewer. Open any CSV, Parquet, SQLite, or Excel file and you can pin columns to either edge — no formulas, no setup.
Download and open FileHop
It's free for Mac and Windows and opens like Finder or File Explorer — no setup or accounts.
Open the folder with your file and click it
Click the CSV (or Parquet, SQLite, or Excel file) to preview it as a table. By default the row-number column and the first column are already frozen on the left, so you start with a sensible anchor.
Pin the columns you want to keep visible
Open a column's menu — or use its quick pin button — and choose Pin Left, Pin Right, or Unpin. Pin an ID, name, or date to the left so it stays put while the rest of the table scrolls sideways. You can also drag a column's edge to resize its width.
Your pins stick — and feed the Dashboard
Pinned columns are remembered per file, so reopening the same file restores them. They also seed the auto-chart in the viewer's Dashboard view, giving you a head start on visualizing the data.
Everything runs on your computer — your data is never uploaded, so it's safe for confidential or proprietary datasets.
Other ways to keep columns in view
FileHop isn't the only option. Here's how the common alternatives compare, and when they make sense.
Excel Freeze Panes
If your data is already in an .xlsx workbook, Excel's Freeze Panes works well and lets you freeze rows as well as columns. But it only applies to spreadsheet files — a raw .csv has to be imported first, and Excel struggles to open very large files.
Online or browser-based viewers
Some web viewers let you freeze a column with no install, but they upload your data to a third-party server and tend to choke on large files — a non-starter for confidential or multi-GB datasets.
Reorder columns instead
You might be tempted to drag columns around to group the important ones. FileHop deliberately keeps this simple: there's no free drag-to-reorder, so you reorder by pinning a column to the left or right edge instead — fewer ways to accidentally scramble your data.
Freezing columns compared
How pinning columns in FileHop compares with Excel's Freeze Panes.
| What matters | Excel Freeze Panes | FileHop |
|---|---|---|
| Works on a raw CSV (not just .xlsx) | No — import to .xlsx first | Yes — open a CSV directly |
| Pin to the left AND the right edge | Left / top only | Yes — Pin Left or Pin Right |
| Remembers your pins per file | Saved in the workbook only | Yes — restored on reopen |
| No setup or formulas | Menu + frozen-cell rules | Yes — one click to pin |
Frequently Asked Questions
How do I freeze columns when viewing a CSV?
Open the CSV in FileHop, then open a column's menu (or use its quick pin button) and choose Pin Left or Pin Right. The column stays anchored to that edge while the rest of the table scrolls sideways — no import or formulas required.
Is this the same as Excel's Freeze Panes?
It's the same idea — keeping key columns visible while you scroll — but it works on any CSV, Parquet, SQLite, or Excel file with no setup, instead of only .xlsx workbooks. FileHop lets you pin to the left or the right edge.
Can I pin a column to the right side?
Yes. From a column's menu you can choose Pin Left, Pin Right, or Unpin. Pinning to the right is handy for a status or total column you want to keep in sight at the far edge.
Which columns are frozen by default?
By default the row-number column and the first column are frozen on the left, so you always have an anchor. You can unpin them or pin additional columns from each column's menu.
Are my pinned columns remembered next time?
Yes. Your pins are remembered per file, so when you reopen the same file your frozen columns are restored exactly as you left them.
Can I reorder columns by dragging them?
Not by free drag-and-drop. FileHop keeps it simple and doesn't offer drag-to-reorder — instead you effectively reorder by pinning a column to the left or right edge, which moves it out of the scrolling area.
Does freezing columns work on Parquet and SQLite files too?
Yes. The same viewer opens Parquet and SQLite, and you can pin, sort, and filter there as well. Note that for Parquet and SQLite the viewer is read-only — you can pin, sort, and filter, but not edit cells.
Can I resize column widths?
Yes. Drag a column's edge to make it wider or narrower, which is useful for long text fields or for fitting more columns on screen alongside your pinned ones.
Do pinned columns affect the charts?
They do. Pinned columns seed the auto-chart in the viewer's Dashboard view, so the columns you care about are the ones FileHop reaches for first when it builds a quick chart.
Is my data uploaded anywhere when I pin columns?
No. FileHop reads the file directly on your computer and never uploads it, so pinning columns — like everything else in the viewer — is fully local and safe for confidential or regulated data.
Keep your key columns in view
Free desktop app for Mac and Windows. Pin columns on any CSV, Parquet, SQLite, or Excel file — no setup, no uploads.
Download FileHop Free