Why Excel cannot open it
An Excel worksheet holds at most 1,048,576 rows by 16,384 columns (Microsoft, "Excel specifications and limits"). When a CSV file is larger, Excel stops at the last row and shows a warning. The remaining rows never reach the sheet, so anything that happens late in the file stays hidden.
Even within the limit, time-series data brings other friction:
- One chart can hold at most 255 series.
- Line charts with many points can be slow to create, zoom and pan.
- You rebuild the same chart every time you open a new file.
Your options compared
| Method | Good for | Keep in mind |
|---|---|---|
| Split the file and open the parts in Excel | Looking at one period only | You cannot see the whole run at once, and you have more files to manage |
| Load it into the Excel Data Model with Power Query | Summaries with PivotTables | The data does not appear on a sheet; not suited to browsing waveforms |
| Python (pandas, matplotlib, etc.) | Automated processing | Requires a Python environment and code, which may not be installable on company PCs |
| A time-series viewer (such as LOGADEC) | Seeing the whole run and zooming straight to the moment that matters | You need the software (LOGADEC requires no installation) |
Opening a huge CSV file in LOGADEC
LOGADEC is time-series viewing and analysis software that runs from a single HTML file. It needs no installation or administrator rights. There is no worksheet-style row limit, so CSV files load without splitting.
- Start it from Try it in your browser, or download the free version and open the extracted HTML file in Google Chrome or Microsoft Edge.
- Click CSV/Excel and choose your file (or drag it onto the window).
- Delimiters, encoding, header and unit rows are detected automatically. Under "Columns to show" on the right, select only the columns you need.
- Click [Import]. For large files, a chart from part of the data appears first while the rest loads in the background.
- In the [Series] tab, click [Select all] to show the data. Zoom with the mouse wheel and drag to pan to the moment you care about.
The import window is explained in detail in the user manual: Loading Data.
Tips for large files
- Load only the columns you need: fewer columns means faster loading and less memory.
- Spikes survive the full view: when there are more points than pixels, LOGADEC keeps the minimum and maximum of every pixel column, so short spikes stay visible even when the whole run is on screen.
- Time-domain analysis uses every point: outlier and change-point detection use all points in the range, without decimation.
- Join split logs into one: logs split by day or hour can be imported together with [Folder] and joined into one in time order.
- Capacity depends on your computer: how much you can load depends on the number of columns, the data, your memory and the browser. The free version loads up to 1,000 channels.