#142 · Compare Audit & Reconcile Tool

Compare Spreadsheet Data Types

Compare column data types across two spreadsheets and download a clear CSV audit report in your browser. The original file stays unchanged.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the source files; processing begins only after you press the action button.
  2. Set the header row and the options needed for this data type comparison.
  3. Review the limited preview and statistics, then download the newly generated result.

What this tool does

This data type comparison examines the dominant value type in matching columns across two files. It performs the work locally and leaves the source file untouched.

Processing rule: analyze the dominant value type in matching columns across two files, show a bounded preview, then create a separate downloadable result.

Keep the source file and review the output before using it in a production workflow.

Supported formats

The tool accepts XLSX, XLS, CSV, and TSV. It reads cell data in the browser; macros, charts, external links, and advanced Excel formatting are outside its preservation scope.

FormatSupport
XLSX / XLSCell data and workbook structure where applicable
CSV / TSVDelimited text parsed locally

Tips for better results

  • Use a clear, single header row before running the data type comparison.
  • Check identifiers with leading zeros and date-like text in the preview.
  • Work on a copy when the workbook contains macros or advanced formatting.

FAQ

Does Compare Spreadsheet Data Types upload my workbook?

No. The data type comparison reads and processes the selected file inside your browser. Your spreadsheet is not sent to Calloffice.

Which spreadsheet formats work with this data type comparison?

XLSX, XLS, CSV, and TSV files are accepted. Older or unusually structured workbooks may lose unsupported Excel-only features in a generated output.

How are blank cells handled by the data type comparison?

Blank cells remain distinguishable from zero and text. The exact treatment is shown in the preview and described in the downloaded result.

Will formulas and formatting remain intact?

The tool focuses on cell data and its stated task. Formula text is read where relevant, but Excel calculation behavior, charts, macros, and advanced formatting are not guaranteed.

What should I check before using the downloaded result?

Review the bounded preview and open the downloaded file in a spreadsheet editor. Keep the original workbook until column names, dates, and special values have been verified.

Processing summary

StageBehavior
InputRead locally in the browser
TaskThe dominant value type in matching columns across two files
OutputNew downloadable file

Browse more office tools

Office tool hubs