How to Open a Large CSV or Excel File That Won't Open
When a CSV or spreadsheet is too big for Excel, open it in a fast desktop table viewer instead — millions of rows, instant search and filter, 100% offline on Mac & Windows.
Quick Answer
- ✓Excel can't hold more than 1,048,576 rows per sheet — so a big CSV literally can't fully load, and large workbooks freeze, crash, or open with rows silently cut off.
- ✓Open it like a spreadsheet in FileHop instead. CSV files are read with DuckDB and open almost instantly no matter the size; you can search, sort, and filter without anything freezing.
- ✓Everything stays on your device. FileHop reads the file locally, so confidential exports are never uploaded to a server.
Why won't a big CSV or Excel file open?
A CSV is just a plain text file, so it has no row limit of its own — but the apps you open it with do. Excel stops at 1,048,576 rows per sheet, so a CSV with more than that simply can't load in full; you get a truncation warning, or rows quietly disappear. Even below that ceiling, a few hundred thousand rows of formulas and formatting are enough to make Excel slow to a crawl, beachball, or run out of memory and crash.
Excel and OpenDocument workbooks (.xlsx, .xls, .ods) are heavier still: the whole file has to be unpacked and parsed before you see a single cell, so a large workbook can hang for minutes or fail to open at all. The fix isn't a faster spreadsheet — it's a tool built to stream large data files instead of loading everything into memory at once.
How to open a large CSV or Excel file in FileHop
FileHop is a free desktop file browser with a built-in data viewer. CSVs are read with DuckDB and open almost instantly regardless of size, and big workbooks can be converted to a fast columnar format in a click.
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 a .csv to preview it. FileHop reads the data on demand with DuckDB — about 1,000 rows per page — so even a multi-gigabyte CSV with millions of rows opens almost instantly without loading everything into memory.
For big Excel files, convert to Parquet when prompted
Excel and ODS workbooks are parsed in-app, so FileHop estimates the row count and warns at 10,000, 100,000, and 500,000 rows. Around 500,000+ it offers to convert the workbook to Parquet — a fast columnar format — and it then opens in under a second with instant search and filter. You can also choose Load Anyway.
Search, sort, and filter without freezing
Press Cmd/Ctrl+F to search across every column, click a header to sort, or open a column's menu to filter (equals, contains, greater than, and more) — each runs as a fast query. Pin key columns to the left, or flip to Transpose to read one wide record field-by-field.
Everything runs on your computer — your data is never uploaded, so it's safe for confidential or proprietary exports.
Other ways to open a large CSV or Excel file
FileHop isn't the only option. Here's how the common alternatives compare, and when they make sense.
Split the file into smaller pieces
You can split a giant CSV into chunks small enough for Excel and open them one at a time. It works, but you lose the full picture, can't search or sort across the whole dataset, and re-joining the pieces is tedious.
Online big-file viewers
Browser-based viewers open a file with no install, but they upload your data to a third-party server and tend to choke on very large files — a non-starter for confidential or multi-GB exports.
Load it into a database or Python
Importing into SQLite, DuckDB, or pandas handles huge files well if you're comfortable with code. But installing a toolchain and writing a script just to look at a file is overkill when you only need to view, search, and filter it.
Excel vs FileHop for large files
How opening an oversized CSV or workbook in FileHop compares with trying to force it into Excel.
| What matters | Excel | FileHop |
|---|---|---|
| Opens files over 1M rows | No | Yes |
| Opens in seconds | Slow or crashes | Yes |
| Search & filter without freezing | Often freezes | Yes — fast queries |
| Data stays on your device | Yes — but limited by row cap | Yes — 100% local |
Frequently Asked Questions
Why won't my large CSV open in Excel?
Excel allows a maximum of 1,048,576 rows per sheet. A CSV with more rows than that can't load in full — Excel shows a truncation warning and silently drops the extra rows. FileHop has no such limit for CSV, so the whole file opens.
How big a CSV can FileHop open?
There's no fixed limit. FileHop reads CSV with DuckDB and loads about 1,000 rows per page on demand, so files with millions of rows or several gigabytes open almost instantly without loading everything into memory.
Why does my Excel file freeze or crash when it opens?
Excel and ODS workbooks have to be fully unpacked and parsed before anything appears, and hundreds of thousands of cells of formulas and formatting use a lot of memory. That's why large workbooks hang, beachball, or run out of memory. FileHop estimates the size up front and offers to convert big workbooks to Parquet so they open fast.
What is the Parquet conversion prompt for large Excel files?
Because Excel and ODS files are parsed in-app, FileHop estimates the row count and shows performance warnings at 10,000, 100,000, and 500,000 rows. At about 500,000+ rows it shows a dialog offering to convert the workbook to Parquet — a fast columnar format — after which it opens in under a second with instant search and filter. You can also choose Load Anyway.
Does the big-file warning apply to CSV files too?
No. CSVs are read directly with DuckDB and open fast at any size, so they don't need the warning or the convert-to-Parquet step. The performance warnings and the 500,000-row prompt apply only to Excel and ODS workbooks, and the trigger is estimated from the file size.
Can I search and filter a huge file without it freezing?
Yes. Search (Cmd/Ctrl+F), per-column filters such as equals, contains, and greater-than, and click-to-sort all run as fast queries rather than scanning the whole file in memory, so they stay responsive even on millions of rows.
Is my data uploaded anywhere?
No. FileHop reads the file directly on your computer and never uploads it. That makes it safe for confidential, proprietary, or regulated exports that can't leave your machine.
Can I edit a large file in FileHop?
FileHop's data table is mainly a fast viewer. CSV and XLSX support adding rows, while Parquet and SQLite open read-only. For full spreadsheet-style editing, view and filter the data here, then export the part you need. For heavier processing, see the Work with Large Files guide.
What other large data files can FileHop open?
The same table viewer opens CSV, Excel (.xlsx and .xls), OpenDocument (.ods), JSON, Parquet, and SQLite databases (.db, .sqlite, .sqlite3, .db3) — so you can inspect almost any oversized data file without special software.
Does it work on both Mac and Windows?
Yes. FileHop is free and runs on both macOS and Windows, opening large CSV and Excel files the same way on each.
Open any oversized file in seconds
Free desktop app for Mac and Windows. View, search, and filter files too big for Excel — no row limits, no uploads.
Download FileHop Free