17 spreadsheet tools

Spreadsheet tools for CRM-ready data

VLOOKUP, dedupe, merge, split, compare, convert. Each tool is named after the job, shows you what will change, and returns a clean file. No CRM required.

Get started free See all tools

Free plan available · No credit card required

A finished Data Health Check in Operelio: a score of 72, fair. 2,988 of 5,875 rows have issues: Must fix 967, Should fix 1,919 and Tidy‑up 102

A completed deduplicate run in Operelio: 967 duplicates removed from 5,875 rows

Match & Pull Columns in Operelio: 4,920 rows matched between two files

The Excel to CSV tool in Operelio with contacts_export.xlsx uploaded, its four tabs listed with their row counts, and a preview of the Contacts tab as CSV.

The CSV to Excel tool in Operelio with online-orders.csv uploaded: how it's written, with a bold header row, columns sized to fit and values kept as text, so 08540 keeps its zero and 4820261009153377012 isn't turned into a number, the 12 rows and 9 columns going into online-orders.xlsx, and a preview of the workbook with the order IDs and ZIP codes as they were.

Import & Convert

Get your files into the right format

Convert between Excel and CSV without the manual work. Pick from multi-tab workbooks, auto-size columns, bold headers. Upload, click, download.

Excel to CSVFree

Pick a sheet, get a clean CSV

CSV to ExcelFree

Formatted workbook with one click

The Clean Headers tool in Operelio showing a file's rows under their new headers, each saying what it was, such as e_mail_address, was E-mail Address.

A finished Find & Replace run in Operelio on contacts_export.csv: VP replaced with Vice President and Mgr with Manager in every column, 866 cells changed in 866 of 5,875 rows, 846 for VP and 20 for Mgr, and the preview searched for Vice President showing titles such as Vice President Marketing.

Column Manager in Operelio: the output columns in order, with a merge, two renames and a column left out noted on their rows.

The Transpose / Unpivot tool in Operelio with What to do set to Transpose and a preview of the flipped file.

Clean & Transform

Fix messy data without formulas

Standardize headers, remove duplicates, find and replace, split, merge and add columns, and unpivot wide data.

Clean HeadersFree

Standardize column names

DeduplicateFree

Remove duplicate rows by any column

Find & ReplaceFree

Bulk find and replace across cells

Column ManagerFree

Rename, reorder, remove, split, merge, duplicate, or add columns

Transpose / UnpivotFree

Flip rows and columns, unpivot, or group rows across

A finished Match & Pull Columns run in Operelio: contacts_export.csv filled in from enrichment_data.csv on Work Email, 4,920 of 5,875 rows matched and 955 with no match, with the pulled Job Title, Company Size, Industry, Phone and LinkedIn columns shaded in the preview.

A finished Compare Files run in Operelio on contacts_export.csv and contacts_updated.csv, matched on Work Email: 276 new, 1,007 changed, 95 removed and 3,614 unchanged rows, the 4,992-row result ready to download, and the preview on the changed rows with each old company struck through beside the new one.

Filter & Extract in Operelio with one rule, Job Title contains Sales, keeping 83 of 592 rows.

The Merge Files tool in Operelio with three lists in order, how their columns line up, and a preview of the 1,842 merged rows.

A finished Split File run in Operelio: contacts_export.csv split into files of 1,000 rows, 5,875 rows in and 6 files out, each file listed in the preview.

Combine & Compare

Merge, split, compare, and join files

Work across multiple files. Join on shared keys, spot differences between versions, combine spreadsheets, or break large files into parts.

Match & Pull ColumnsFree

Pull matching data from a second file

Compare FilesFree

See what's added, removed, or changed

Filter & ExtractFree

Pull rows matching your criteria

Merge FilesFree

Combine multiple spreadsheets into one

Split FileFree

Break a spreadsheet by column value or row count

The Company Active Check tool in Operelio set up before a run: contacts_export.csv uploaded, the Website column found by its name, what it checks, and 65 websites ready to check across 5,875 rows.

A finished Full verification in Operelio on webinar-leads.csv: 1,207 of 1,480 addresses safe to send, with the send-ready file at a minimum score of 70 and its score chart open, and the email patterns of its first four companies.

Review, Validate & Fix

Spot bad data before it hits your CRM

Get a quality score, then fix duplicates, blanks, placeholders and formats in one click, free. Check that each company's website is still live. Verify every email so the addresses you ship to your campaign tool actually deliver, and, from Starter, screen each file against your Do Not Contact list.

Data Health CheckFree

Score your file and auto-fix common problems

Company Active CheckStarter

Check whether each company's website is live and drop the dead ones before import

Email Verifier & FinderFree + Starter

Check any email for free, verify a whole list, recover lost contacts

The CRM Formatter's Map step in Operelio, a file's columns to HubSpot fields: Full Name split into first and last name, Direct Phone and Office Phone combined into Phone, using the first one with a value, and Lifecycle Stage set to Lead on every row.

The Workflow Builder in Operelio with a saved five-step workflow on an Apollo export: Clean Headers, Deduplicate by email, Filter & Extract, Remove suppressed contacts and CRM Formatter, with Filter & Extract open on one rule, job_title contains Sales, keeping 83 of 592 rows.

Format & Push

Map columns and push straight to your CRM

Auto-detect field mappings for 8 major CRMs. Push directly to HubSpot, Salesforce, or Pipedrive: people, companies and deals. Validate every row before it hits your CRM. Chain tools into reusable workflows.

CRM FormatterFree + Starter

Map, validate, and push to your CRM

Workflow BuilderStarter

Chain tools into automated runs

Push directly to

HubSpot

Pipedrive

HubSpot contacts, companies and deals, Salesforce contacts, leads, accounts and opportunities and Pipedrive people, organizations and deals.

Trails

Now automate it. Every file, straight into your CRM.

A trail chains these tools on a canvas and leaves them running. A file or a single lead lands in a folder, by upload, email, form, webhook, API or schedule, and the trail does the rest: cleaning, verification, scoring, routing and the CRM import. The safety checks, and Bridgeant if you switch it on, hold anything that looks wrong. Let clean runs send on their own and you only hear about the runs that need you. Live the same day. Nothing to code.

Runs on every filePushes to your CRMHolds what looks wrongNothing to code

See Trails See how a trail is set up

A whole trail on the Operelio canvas: a folder trigger, Clean Headers, Deduplicate and Remove suppressed contacts, then Verify emails, CRM Formatter and Safety checks, pushing to HubSpot shared between four people.

One prompt. Every tool, in the right order.

Every tool on this page, run for you. Describe the job and Bridgeant plans the exact steps, then runs them once you approve. It reads a summary of your file, never the data itself. And whatever you run, by hand or by Bridgeant, lands on Home with your quota, your tasks, and where you left off.

Plans the jobChains the toolsYou approve every runNever reads your data

Meet Bridgeant Take a tour of Home

Bridgeant's five-step plan for tradeshow-leads.csv: Filter & Extract 90 rows, Deduplicate 182, Remove suppressed contacts 28, Find & Replace 425 cells, CRM Formatter for HubSpot

Reads a summary, never your data

15 tools free. No credit card required.

Get started free See pricing

Free plan available · No credit card · Cancel anytime

Looking for the full picture? See all features →