Windows Preview available. Pro checkout is not open yet. Plans and capability details →
RowCoveAccount ↗

CSV guide

A useful first look
at a large CSV.

Start with a bounded page, understand the columns, then narrow the full source. Your spreadsheet does not have to be the first tool you open.

How can I inspect a large CSV locally?

Open it in RowCove, verify delimiter and encoding, inspect the first page and use the full-file filter/query workflow for source-wide questions. Preview is read-only and limited to up to 100 records; Pro enables supported full-file operations.

1. Check the source before trusting the grid

Choose Open data and select the CSV in the native file picker. Review Dataset information. A semicolon-delimited file opened as comma-delimited data can look like one giant column; an encoding mismatch can look like corrupt text. Correct the setup before interpreting the contents.

The first page helps you orient. It does not require a complete row count. Look for an unexpected header, shifted fields, quoted separators, empty cells and suspicious type detection.

2. Read complete values, not only clipped cells

Select a cell and use the record inspector to examine its full value. This matters for long IDs, timestamps, decimal prices and embedded JSON. Do not infer equality from two truncated strings that look identical in the table.

For quantitative data, check the timestamp unit and timezone, whether prices retain the intended precision, and what a missing value means. A file extension cannot establish those semantics for you.

3. Distinguish page search from source filtering

Find loaded rows searches what is already loaded. Finding no match there does not prove a value is absent from the file. Use the supported full-file filter/query workflow to answer a source-wide question.

  1. Project a small set of useful fields, such as symbol, time and the measure you are checking.
  2. Choose one symbol or category and a short time interval.
  3. Inspect the result scope and source provenance.
  4. Expand the interval or add a sort only when the smaller query answers the right question.

Cold indexing and query preparation can take time. Review progress and cancellation rather than repeatedly starting the same operation.

4. Save a separate copy of supported edits

Switch to Edit only when you intend to stage changes. Review and undo changes as needed, then use Save copy and choose a new destination. Reopen the output and inspect representative values before using it in another workflow.

Keep the source as evidence. Never assume that changing the display formatting changes the underlying value or that every reader has the same export capabilities.

What this workflow does not guarantee

A first page is a sample, not a data-quality certificate. Large-file latency depends on storage, hardware, encoding, query shape and cache state. RowCove does not promise a universal “instant open” time or complete statistical analysis from a small preview.

Read the performance model, compare Preview and Pro, or use the MCP tutorial to build a bounded assistant workflow.

Try the first page on your own data.

Start with the free Windows Preview: source information and up to 100 records, read-only. Review reader capabilities before planning a full-file Pro workflow.

Pro checkout is being prepared. The initial Windows install enables signed in-app updates for later versions.