Guides to large CSV, Excel and MATLAB files
Practical answers for CSV and Excel files that are too big for spreadsheets, and for MATLAB .mat files when you don’t have MATLAB. Each guide covers the options that work today, including tools other than ours, with honest pros and cons.
All guides
- CSV too large for Excel? How to open every rowOpen every row of the file right on the page, then why Excel stops at 1,048,576 rows and six other ways around the limit, with honest pros and cons.Updated · 9 min read
- How to merge CSV files into oneSix ways to combine CSV files, from a one-line command to pandas, and the pitfalls that break merges: repeated headers, encodings, line endings.Updated · 9 min read
- How to plot a large CSV file with millions of rowsWhy big files are hard to chart, why thinned-out charts can hide spikes, and which tools cope with millions of rows.Updated · 9 min read
- Plot frequency data from a CSV on a log X axisPut the Hz column on a log X axis, with an example file to try: zero and DC rows, dB on a linear Y axis, why Excel’s line chart has no log X, and when an FFT, PSD or FRF comes first.Updated · 6 min read
- Plot multiple CSV files on one graphOverlay separate runs on one chart, each series labelled with its file, with three example runs to try: columns and units, dated and elapsed times, gaps and sample rates.Updated · 8 min read
- How to open a .mat file without MATLABFive free ways to open MATLAB .mat files, from your browser to Python, Octave, MATLAB Online and VS Code, and what to do with v7.3 files.Updated · 10 min read
- How to convert CSV to a MATLAB .mat fileFour ways, from your browser to MATLAB, Python and GNU Octave, with tested code, and the pitfalls: column names, text, empty cells, dates and the 2 GB limit.Updated · 12 min read
- What is a .mat file?What a MATLAB .mat file is and what it holds, with its four versions (4, 6, 7 and 7.3) side by side: releases, compression and the largest variable.Updated · 4 min read
- How we measure speed on large CSV filesThe method behind our speed figures: the test files, the laptop and browser, cold and warm opens, five repeats each, and the limits. Make a file of the same shape and try it yourself.Updated · 4 min read
Coming soon
- How to split a CSV into multiple files
- How to compare two CSV files
Is there a question about big data files you would like answered?
Related tools and guides
- CSV plotterPlot CSV, Excel, MATLAB, Parquet and TDMS files
- Large CSV viewerScroll every row of a CSV too big for Excel
- Merge CSV filesCombine many CSVs, even if the columns differ
- Split CSV filesCut a big CSV into files Excel can open
- MATLAB .mat file viewerOpen .mat files, v4 to v7.3, without MATLAB
- CSV to MATSave a CSV, Excel or Parquet file as .mat