MCP App Store
by KeenEthics
Zovo Spreadsheet Checker icon

Zovo Spreadsheet Checker MCP Server for ChatGPT

By Zovo

Overview

Check a spreadsheet for errors before you import it, send it or report from it. Zovo Spreadsheet Checker reads a CSV or Excel file (or a table you paste) and lists each problem cell with its row, column and the value as written, so you can fix the file instead of hunting through it. With no setup it works out what each column holds from its values and headings, then runs the checks that fit. It finds dates that do not exist (February 30, April 31, month 13, February 29 in a non-leap year), dates written in the other day/month order or in a different format than the rest of the column, ambiguous dates, invalid email addresses and likely domain typos such as gmial.com, phone numbers with the wrong number of digits, duplicate IDs and duplicate rows, blank cells in columns that are otherwise filled, text and placeholders like N/A in number columns, numbers stored as text, mixed decimal marks (12,50 next to 12.50), leading and trailing spaces, the same category spelled two ways (Open and open), IDs and ZIP codes that lost their leading zeros or turned into 1.2E+15, formula errors such as #N/A, and row totals that do not add up (Q1 + Q2 + Q3 + Q4, or quantity times unit rate), compared with decimal math that does not round. For data validation you can add your own rules such as required columns, unique columns, allowed values per column, numeric ranges and total formulas like Amount = Qty * Rate. You get a health score per column, counts per check, the first issues in the chat, an Excel copy with problem cells highlighted (red for errors, yellow for warnings) plus an Issues sheet and a Summary sheet, and a CSV of all issues found. For an Excel file the copy is your own workbook with the flagged cells filled in and two sheets added, so formulas, number formats and the other sheets stay as they were. For a CSV file the copy keeps each value as text, as it was read. Good for CRM and email-list imports, payroll and invoice exports, survey results, inventory lists and any spreadsheet you are about to send to someone else. It works with CSV, TSV and .xlsx files (save older .xls files as .xlsx), one sheet per check, up to 50,000 rows and 200 columns. It checks format and consistency; it cannot confirm that an inbox or phone line exists. Formulas are read as their last saved values.

How to connect

  1. ChatGPT: Open the Zovo Spreadsheet Checker listing in the ChatGPT app directory and choose Connect. ChatGPT listing Zovo Spreadsheet Checker exposes 2 tools here.

Tools

check_spreadsheet

ChatGPT
Use this when the user wants to check a spreadsheet for errors or validate data before importing or sending it: "check spreadsheet for errors", "data validation excel", "find duplicates in excel", "check this csv for errors", "find invalid dates", "are there bad emails in this list". Attach a CSV, TSV or .xlsx file or paste the table. With no rules it detects column types from the values and checks impossible, ambiguous and mixed-format dates, invalid emails and email typos, phone digit counts, duplicate IDs and duplicate rows, blank cells in mostly filled columns, text in number columns, numbers stored as text, mixed decimal marks, leading/trailing spaces, IDs that lost leading zeros or became 1.2E+15, formula errors and row totals that do not add up. Optional rules: required_columns, unique_columns, allowed_values, ranges, total_rules. Returns each issue with row, column and cell value, counts per check, a column health score, an Excel copy with problem cells highlighted plus an Issues sheet, and an issues CSV. Does not edit or clean the data, does not verify that mailboxes or phone lines exist, and does not compare two files (use a comparison tool for that).

list_spreadsheet_columns

ChatGPT
Use this when the user wants to see what is in a spreadsheet before validating it, or asks which columns, types or values it has: "what columns are in this file", "profile this csv", "which column is the ID", "suggest validation rules". Attach a CSV, TSV or .xlsx file or paste the table. Returns each column's letter, name, detected type (date, email, phone, ID, ZIP, number, money, percent, text), filled and blank counts, unique values, examples, min/max for numbers, short value lists, and suggested rules to pass to check_spreadsheet. Does not report errors (use check_spreadsheet) and does not change the file.

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/zovo-spreadsheet-checker"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/zovo-spreadsheet-checker)