Guide
Scan a new CSV in 60 seconds
A short guide for quickly understanding a file you have never seen before.
Upload and verify headers
Drop the CSV into your viewer and check that the headers match what you expect. If you see unexpected blank headers or merged columns, the delimiter may be wrong.
- Confirm every column has a label
- Look for extra columns that shouldn't exist
- If headers look merged, try a different delimiter
Skim the first 20 rows
Scroll through a handful of rows to spot missing fields, inconsistent formats, or shifted columns that indicate problems.
- Scan for blank cells in required columns
- Check that dates and currency use one format
- Watch for rows that shift data left or right
Quick CTA
Open a CSV and confirm it fast
Readable CSV gives you instant search, filters, and clean tables so you can verify a new file in under a minute.
Open the readerSearch for a known value
Use global search to find a known value or an obvious placeholder like 'TBD'. This confirms the file is aligned correctly.
- Search for a known customer, order, or product
- Search for placeholders like TBD or N/A
- Confirm results appear in expected columns
Validate counts before you act
Before you start analysis, confirm the row count matches the source. This prevents missing records from skewing your decisions.
- Compare row counts to the export source
- Check if headers repeat mid-file
- If the count is off, investigate before proceeding
Checklist
- Headers read clearly
- No shifted rows
- At least one search confirms alignment
Key takeaway
A quick scan catches most problems before they affect your work. Make it a habit for every new file.