Understanding your results
How to read a job's page: the figures, the settings line, the notes, the files table, the preview, and what each download gives you.
By Operelio team · Updated October 20, 2026
On this page9
Results page layout
After a job finishes, you land on its page. At the top are the tool's name and, on a finished job, Run again, which opens the tool again. Below it, the Summary card puts the figures first, then the settings you used in one line and any notes, such as the row-limit note.
Below the Summary card, a Files table lists each file the job made and the file you ran it on, each named by what it holds (for example "Without the duplicates" and "Your file before deduplicating"), with its rows and the date it's kept until: download any of them, or, on Starter and up, send a file the job made to Files (a Data Health Check report stays with its job). The preview pages through every row on every plan, with a view for each file, search, and Go to row. A Workflow Builder run adds one row per step, with its rows before and after.
Settings line
Under the figures, one line says what the job did with your settings, for example "Replaced N/A with blank in every column." or "Stacked 3 files, matching columns by name." Notes under it point out anything to know, such as a rule that was skipped.
The figures
The Summary card opens on the job's key figures. Where they add up, they read as a sum, such as rows in, minus the rows removed, equals rows out. The figures vary by tool:
| Tool | Stats shown |
|---|---|
| Excel to CSV | Rows and columns. For a workbook with more than one tab, a line names the tab it read and a note counts the other tabs. |
| CSV to Excel | Rows, columns. |
| Clean Headers | Headers, minus the ones renamed, equals the ones unchanged. The Headers view lists every header before and after. |
| Deduplicate | Rows in, minus the rows removed, equals rows out. The preview's Groups view counts the duplicate groups. |
| Find & Replace | Cells changed, rows changed, and rows in the file. A line under them says what was replaced in which columns, and with more than one rule, the cells each rule changed. |
| Filter & Extract | Rows in, minus the non-matching rows, equals rows out. A line under them says the rules that ran. |
| Column Manager | Columns in, minus the columns removed, equals columns out, with the renames beside them. With a split, merge, copy or added column the counts stand side by side. A line under them names each change. |
| Transpose / Unpivot | Transpose: rows and columns in and out. Unpivot: rows in, times the value columns, equals rows out. Group across: rows in, groups, and sets per row. A line under them says how the file was reshaped. |
| Match & Pull Columns | Matched, no match (Dropped, no match with Only matching rows) and rows out, plus Only in Pull from when you kept all rows from both files. The Files table gives each file's rows. |
| Compare Files | New rows, removed rows, changed rows, unchanged rows. |
| Merge Files | Files, rows out and columns. Anything to know, like a file that was skipped, is a note under them. |
| Split File | Rows in and files (or tabs) created, and, when there is more than one, the rows in the largest. |
| Data Health Check | How many rows have issues, the score, and every row under what it needs: Must fix, Should fix, Tidy‑up or Ready. Then the Issues list, with every issue and what its rows need. |
| Apply Fixes | The score before and after, how many rows still have issues and every row under what it needs, the rows in, removed and out, then the issues left to fix. |
| Company Active Check | How many companies have an active website, with a download of those rows beside it, then one bar of every row: active, uncertain, inactive and no website. A line under it names the column it checked and how many unique websites, each checked once, and another says why the uncertain and inactive ones landed there. The Active companies file keeps the rows scoring 70 or more; Change sets a different score. |
| CRM Formatter | Rows in, minus the rows removed, equals rows out. A line under them names the CRM format and how many fields were filled from your columns, and a note says what was removed: repeated rows, blank rows and, on a paid plan, people on your Do Not Contact list. |
| CRM Formatter, pushing | Before the push: what will be created, updated or not sent, with the reason for each row not sent (on Salesforce, each row not sent or refused), adding up to your rows out. After it: Created, Updated, Refused and Not sent. |
Settings you used
The line under the figures says the settings you chose: which columns, which matching mode, how many rules, and so on. It helps you remember your exact configuration if you want to run the same job again on a different file.
Preview table
A read-only preview of your output appears further down. It pages through every row on every plan. Search it, or go to a row. Columns scroll if the file is wide.
The preview is for checking, not editing. To work with the data, download the file.
Extra output files
Some tools produce more than one output file. On a job's page, each one is its own row in the Files table, with a Download button:
| Tool | Extra file |
|---|---|
| Deduplicate | A separate file with only the removed duplicate rows. |
| Filter & Extract | A file with the rows that did not match your filter. |
On paid plans, CRM Formatter also gives you a file of Do Not Contact rows, the people your Do Not Contact list held back, so you can see who was kept out of the export and the push.
Warnings
An amber note appears in the Summary card if a limit was hit during processing. The most common: your file exceeded your plan's row limit, so only the first N rows were processed (the CRM Formatter cleans the whole file, then keeps the first N rows). The note names your file's total row count, the row limit that was applied, and how many rows were processed, and, where you can upgrade, says which plan processes more.
Other warnings: an advanced pattern was invalid and was skipped, or duplicate keys were found in your lookup file. Warnings do not mean the job failed. The job ran, but something was capped or skipped. A job that runs longer than 10 minutes is stopped, fails with a message saying so, and saves nothing; run it again on a smaller file, or split the file first. (A key column that does not exist fails the job outright with an error, before any rows are processed.)
Downloading your output
Click Download to save the file. The format depends on the tool: most tools give you back the format you uploaded, CSV or Excel (.xlsx). Merge, VLOOKUP and Compare Files return an Excel workbook, CRM Formatter and Excel to CSV return CSV, and in the Workflow Builder you pick CSV or Excel. Excel output is on every plan, Free included.
The download link stays active until the file is deleted. Files are deleted after your plan's retention window: 24 hours on Free, 30 days on Starter, 30 days on Pro, 90 days on Agency.
Finding past jobs
Every job you run is listed on Home's Activity tab, with the tool used, the input file name, the time, and the status. Click a row's file name to see the steps its file took, or Open at the end of the row to go back to its results page. On Starter and above you can delete a file from Files.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.