Free Data Tools for Business Analysts: Clean, Join and Report Without IT
Business analysts spend much of their week between systems: a CRM export here, a finance spreadsheet there, a requirement that says "combine these". Waiting for IT or a data team to do it slows everything. This guide covers the free tools a business analyst can use on their own, in the browser, for the tasks that come up every week.
The recurring jobs
- **Tidy a messy export.** Fix headers, formats and duplicates with the data transformation tool.
- **Combine two sources.** Join a CRM export with a billing export using SQL on your files, with no database.
- **Find what changed.** Use data comparison to see added, removed and changed rows between two versions of a spreadsheet.
- **Check before you present.** Run the data profiler so you do not present numbers built on duplicates.
- **Share without exposing people.** Hide emails, phones and names with data masking before a file leaves your team.
Example: reconcile two systems
Finance says there were 1,240 paid customers; the CRM says 1,198. Export both, then:
select c.customer_id from crm c left join billing b on b.customer_id = c.customer_id where b.customer_id is null;That lists customers in the CRM with no billing record. Reverse the join to find the opposite gap. Now the conversation is about 42 named records, not two conflicting totals. See also comparing financial reports for reconciliation.
Example: write requirements from real data
Profile the source file first. Facts such as "11% of phone numbers are blank" belong in the requirement, and they save a round of questions with developers.
Example: understand an inherited report
If a report is built from SQL files, load them in the SQL lineage analyzer to see which tables and columns feed each output. It reads the SQL text only, so it does not need database access.
Limits
These tools handle files, not live systems, and they do not refresh on a schedule. For recurring reports used by many people, a BI tool is a better home. Use these for the analysis and one-off checks that come before.
Related tool pages
- Compare Two CSV Files: Compare two CSV or Excel files by a key column and see added, removed and changed rows. Free, runs in your browser.
- Compare Two Excel Files: Compare two Excel (.xlsx) files by a key column and see every added, removed and changed row and cell. Free, and your files stay in your browser.
- Compare Two Parquet Files: Compare two Parquet files by a key column and see every added, removed and changed row and cell. Free, runs in your browser, nothing is uploaded.
- Compare Two JSON Files: Compare two JSON files by a key field and see which records were added, removed or changed, down to the nested field. Free, in your browser.
- Compare Two Avro Files: Compare two Avro files by a key field and list the added, removed and changed records. Reads the embedded schema, runs in your browser. Free.
- Compare CSV with Parquet: Check that a Parquet file matches the CSV it was made from: find rows and values that differ after a conversion or migration. Free, in your browser.
Also try
- Free data profiling tool for data analysts
- Free data tools for product analysts
- Free data tools for data engineers
- Analytics without a data engineer
How to use the Data Comparison: step by step
- Export each source.
- Profile and clean the files.
- Join or compare them with SQL or data comparison.
- Mask and share the result.
When to use the Data Comparison
- Reconciling two system exports
- Cleaning spreadsheets without IT
- Finding changes between versions
- Writing requirements from profiled data
Example
Input: before.csv + after.csv, key = id
Output: Added 3 · Removed 2 · Changed 5
Frequently asked questions
What free tools can a business analyst use for data?
Browser tools for cleaning and converting files, running SQL on CSV and Excel, profiling, comparing files and masking personal data cover most of the weekly work.
How do I compare two Excel files for differences?
Use data comparison: pick a key column and it lists added, removed and changed rows between the two files.
Can I use SQL on Excel files without a database?
Yes. SQL on your files runs queries directly on CSV, JSON and Excel in the browser.
Do I need IT approval to use these?
There is nothing to install, but follow your company policy on tools and data. Files are processed in your browser and are not uploaded to our servers.
Tip: Name the records behind a mismatch. "42 customers are missing from billing" gets fixed; "the totals disagree" gets debated.