Open CSV and Excel files that are too big for Excel
Excel stops at 1,048,576 rows, and big CSV files often freeze it or open with rows missing. This large CSV file viewer opens files with millions of rows right in your browser, and it’s fast enough to scroll, sort and filter them without waiting.
It’s more than a viewer. You can filter, search, find and remove duplicates, group and add up rows, make pivot tables, join two files like VLOOKUP, combine monthly exports, clean up columns, make charts and download the result as CSV, Excel and other formats.
It’s free, there’s no sign-up and nothing is uploaded. Your files are read on your own computer, so it’s safe for customer lists, sales exports, logs and other private data.
Want to try it first? Choose Try a sample with 1 million rows on the start screen. It opens a made-up store’s orders and a product list, so you can try every tool on real-sized data. How to use at the top opens a short step-by-step guide.
What files can it open?
- CSV and text files: comma, semicolon, tab or pipe separated (.csv, .tsv, .txt, .tab, .psv). The separator, the text encoding and the header row are found automatically, and you can change them with Import settings at the bottom.
- Excel: .xlsx and .xlsm, including workbooks with several sheets (you pick which ones to open), and older .xls files.
- JSON: an array of objects, or JSON Lines (.jsonl, .ndjson). Nested fields become columns like
user.name. - Compressed files: a .csv.gz opens directly, and a .zip of CSV files opens each file in its own tab.
- Pasted data: copy rows from Excel or Google Sheets and choose Paste data.
How big a file you can open depends on your computer’s memory, not on a row limit. Most computers handle files of 1 to 2 GB, which is often 10 million rows or more. If a file is too big, the tool keeps the rows that fit and tells you.
How to open a large CSV file
- Open the file. Drop it anywhere on the page or choose Open a CSV, Excel or JSON file. A progress bar shows how far it got, and you can stop it at any time. Open more files with the + button. Each one gets its own tab.
- Look around. Scroll the grid like a spreadsheet. Click a column name to sort it, or use the ▾ button on a column for its menu. The bar at the bottom shows the number of rows and columns, and the sum, average and count of the cells you select.
- Find what you need. Type in the search box to look in every column at once, or use Filter for exact rules.
- Change it. Remove duplicates, clean columns, add formula columns or edit cells by double-clicking them. Ctrl+Z undoes any change.
- Download. Choose Download and pick CSV, Excel, JSON, SQL, Markdown or HTML. You get the rows you see, in the order you see them, without hidden columns.
Filter, sort and search millions of rows
Filter shows only the rows that match. Text columns can be filtered by *contains*, *is*, *starts with*, *is one of* (pick values from a list with counts), *is empty* and even a regex pattern. Number columns have *greater than*, *between*, *top 10* and *above average*, and date columns have *between*, *before* and *after*. Add as many filters as you like: a row must match all of them.
Sort by one column or several, like State and then Total from largest to smallest. Numbers sort as numbers and dates as dates, and blank cells always go last.
Search looks in every cell of every column at once and highlights the matches. Click a value in a cell’s right-click menu to filter to it in one step.
Find and remove duplicate rows
Choose Duplicates, tick the columns that should match (all of them, or just Email, for example) and choose Find duplicates. You’ll see how many extra copies there are. Then you can show every duplicate, show only the extra copies, show the unique rows, or remove the duplicates and keep the first copy of each row. There’s an option to ignore upper and lower case and extra spaces, so “Ann Lee” and “ann lee ” count as the same.
Group, add up and make pivot tables
Group adds rows up by one or more columns, like a pivot table in Excel. Count orders by state, sum sales by product, or find the average order value by month. Dates can be grouped by year, quarter, month, week, day or day of the week. Switch to Pivot table to put a second column across the top, such as categories down the side and years across. The result opens in a new tab, where you can sort it, chart it or download it.
Column summary (in each column’s menu) shows the count, blanks, number of different values, the most common values and, for numbers and dates, the sum, average, median, smallest, largest and a small histogram.
Join two files like VLOOKUP
Open both files, choose Join and pick the column they share, like Product or Customer ID. You can keep every row of the first file (like VLOOKUP), keep only rows that match, keep everything from both, or find the rows that have no match. Pick which columns to bring over. Matching can ignore upper and lower case and extra spaces, which fixes most “why doesn’t this match” problems.
Combine does the other kind of merge: it stacks files that have the same columns, like twelve monthly exports, into one table. Columns are matched by name, so their order can differ, and a column with each row’s file name can be added.
Make charts from big data
Choose Chart to make a column, bar, line, area, pie, histogram or scatter chart. Pick what to group by and what to add up, such as the sum of Total by month. Charts use all the rows that match your filters, so you can chart millions of rows and then filter to compare. Hover for exact numbers, and save the chart as a PNG image.
Clean up data and add columns
- Clean trims spaces, removes hidden characters, changes text to UPPER, lower or Title Case, fills empty cells, fills down, turns “$1,234.50” or “12%” into plain numbers, rounds, rewrites dates as YYYY-MM-DD, adds text before or after, and pulls out part of a value with a pattern.
- Split a column at a comma, space or any other separator, like splitting full names or “City, State”.
- Replace finds and replaces text in one column or all of them, with options for whole cells, matching case and regex.
- Add column makes a new column from a formula, written like Excel:
[Price] * [Quantity],IF([Total] > 100, "Large", "Small"),YEAR([Order Date])orUPPER(TRIM([Name])). There are more than 60 functions for math, text, logic and dates, and you see the first results as you type. - Columns shows, hides, renames and reorders columns, freezes the first ones while you scroll, and changes a column’s type if numbers or dates were read as text.
Split a big file for Excel
If a file has more rows than Excel can open, choose Split file. It makes several smaller CSV or Excel files, each with the header row, either every so many rows (like 1,000,000) or one file for each value of a column (like one file per state). You get them all in one .zip download. Downloading as Excel also spreads extra rows over more sheets automatically.
Your data stays private
Everything happens in your browser. Files are read on your device and never sent to a server, and closing the tab clears them from memory. Nothing is saved unless you download it, so remember to download your changes before you close the page.
Tips for very large files
- Close other tabs before opening a file of several gigabytes. That gives your browser more memory.
- Use a computer for the biggest files. Phones and tablets work too, but have less memory.
- Download as CSV for the fastest, smallest files. Excel files take longer to build.
- Filter first, then download to get a smaller file with just the rows you need.
Related tools
- Check and fix JSON before you open it with the JSON Validator.
- Hide names, emails and other personal details in text before you share it with Redact Text.
- Need to edit a PDF report instead? Try the Online PDF Editor.
