Analysis
Spot outliers with search and sort
Use lightweight signals to find spikes, duplicates, and missing data fast.
Sort the column that should be steady
Pick a numeric field like revenue, duration, or inventory count. Sort ascending, then descending, to isolate spikes or zeros.
- Check the bottom few rows for zeros or blanks.
- Check the top few rows for spikes.
- Repeat with a second metric for comparison.
Search for missing values
Use global search to scan for placeholders like "N/A", "-", or "null". These tend to cluster and point to broken imports.
- Search for common placeholders or empty strings.
- Look for multiple spellings of the same placeholder.
- Scan for values that look truncated.
Quick CTA
Catch anomalies in seconds
Use Readable CSV to sort and scan large files without the slowdown of heavy spreadsheets.
Try the readerCompare patterns side by side
Sort by a secondary column after finding a suspicious record. This shows whether the outlier is unique or part of a pattern tied to a region, product, or owner.
- Sort by region or owner to find clusters.
- Scan adjacent rows for similar anomalies.
- Confirm if the pattern is seasonal or constant.
Document what you find
Write down the exact filter or search term that reveals the outlier. It makes it easier to reproduce the finding later or share it with a teammate.
- Record the row count after filtering.
- Capture the column you sorted by.
- Save a quick note on expected vs actual.
Key takeaway
Outliers show up fast when you combine a clean sort with a few focused searches.