FileAccord.Spreadsheet data quality checks Back to checks

How can we help?

Choose a file. Set your checks. Review the results.

Start here

  1. Choose filesSelect CSV or Excel (.xlsx) files.
  2. Set your checksReview the suggested checks or use Add check. Only selected checks run.
  3. Run checksReview the findings and download a report.
Checking a folder?

Use Choose folder. The same checks run on each CSV or XLSX file, one at a time. On phones without folder support, select several files together.

Excel uses the first data worksheet unless you choose a name in Excel worksheet options. Stop keeps completed results and marks unfinished files as not checked.

Common questions

What do my results mean?
  • Passed: the selected checks found no issues.
  • Needs attention: review the findings and suggested corrections.
  • Could not check / partial: read the reason and try again. These are not passes.

Fix and check again

Fix your original files, choose Check corrected files or Check corrected folder, then run again. Your checks are retained.

Reports and recheck details

Issue report contains all findings, beyond the preview. Check report records a clean single-file check. Summary lists every file’s outcome.

Preview filters do not change the full report. Rechecks compare finding counts for matching filenames and unchanged checks; they do not identify individual rows that were fixed. Select corrected originals, not an issue report.

Keep a run record

Download run record keeps the exact requirements, settings, dates and outcomes. Keep source and comparison files separately; the record contains their names, not their contents.

How do I save or share checks?

Choose Save checks and give your set a name. Next time, select it from Check set. Saved sets stay in this browser.

Share with your team

Use Copy checks link or Download requirements. Your team selects their own files and runs the same checks. Requirements files open with Import requirements.

Sharing includes readable requirements, never your files or results.

Saving and editing details

Shared checks are a fixed revision; later edits do not change earlier links. Choose Make an editable copy to change received checks. Select comparison files again when reusing checks.

Choosing or importing checks keeps selected files. You can also create checks first using exact column headings. Save or cancel unfinished edits before running. There is no fixed check-count limit; larger sets take longer. Clearing site data removes saved sets.

Shared links do not synchronize files or approve deliveries. Share source files through your usual channel.

How do I create a template?
  1. Create or select checks with the column headings you need.
  2. Choose Download Excel template.
  3. Fill the Data sheet, then check the completed workbook.

The separate Instructions sheet explains the requirements and which checks Excel supports. Dropdowns and entry limits help prevent mistakes while typing. Pasting or clearing cells can bypass them—always check the completed file in FileAccord. Your source rows are not included.

Template settings

Complete enabled settings before downloading. For a batch with a named worksheet, use Data. Use Required column heading for a column that may contain empty cells. A row-count-only set needs a column-based check to create a template.

Can I compare files or check totals?

Yes. In Add check → More checks, choose comparisons, column totals, row counts or duplicates across files. Settings appear for the check you choose.

Compare files

Add a comparison file and choose the identifier and value columns. Comparisons look from your selected file into that file; swap them to find removals.

Check limits and details
  • Row count: excludes headings and fully empty rows. Empty files cannot be checked.
  • Column total: checks each file or group. All groups use the same expected total; missing expected groups are not detected. Amounts must be plain numbers with up to 18 whole digits and 8 decimal places.
  • Duplicates across files: needs at least two readable files with the expected column. Ordinary duplicate checks work within a file.
  • Text-format checks skip blanks. Add Missing information when blanks must fail. Email checks validate formatting, not ownership.
Why won’t my file or check run?
  • Give every data column a unique, non-empty heading. Match the capitalization in your checks.
  • Remove formulas: export a values-only XLSX or CSV.
  • Read the explanation beside Run. Complete missing settings and save or cancel edits.

Fix the original file, then select it again. For very large Excel files, try CSV.

Privacy and file details

Files are processed on your device. No signup is needed. Empty trailing Excel columns caused by formatting are ignored; named columns are kept.

Reports may contain source values. Shared links contain readable requirements, not encrypted data. Temporary browser storage may remain after an abnormal tab closure; clearing site data removes it.

Can I try it with sample data?

Open Try a sample → Simple example, then Run checks. Expect 4 findings across 6 rows. Review the corrections or download the issue report.

Try a sample →
Try a folder-style example

Invoice delivery example checks two fictional files for duplicates, row counts and totals. Expect four findings. Download both files from Try the corrected examples, select them with Check corrected files, and run again. Both should pass.

Give feedback

Tell us what worked or what could be easier. Send from the form when available, or use email/copy. Direct sending uses Cloudflare verification. Your files are not attached.