Spreadsheet guides
Practical guides for joining, combining and analysing data across Google Sheets, Excel and CSV files.
How to answer questions across multiple spreadsheets
Analyse data spread across several spreadsheets: when to stack and when to join, the four question patterns, and worked examples with formulas and SQL.
- Ad spend roll-up template
Free Excel template that rolls Google Ads and Meta Ads exports into one weekly table of spend, clicks, conversions and blended cost per acquisition.
- Are any invoice numbers missing from the sequence?
Stack invoice lists from several files and find gaps in the number sequence — missing or deleted invoices — with SEQUENCE and a recursive SQL query.
- ChatGPT vs Analistable for asking questions about spreadsheets
ChatGPT uploads your file and runs Python on it; Analistable runs SQL on it in your browser. Where each wins on privacy, joins and repeatable answers.
- Have any suppliers billed us twice?
Spot duplicate supplier invoices: exact duplicates on vendor, invoice number and amount, and near-duplicates with the same amount a few days apart.
- How did each product grow from last month to this month?
Compare two monthly sales files product by product: revenue change, growth %, new and discontinued items — with XLOOKUP and a full outer join in SQL.
- How do sales reps rank across all regions?
Stack regional sales files and rank every rep by revenue and by percentage of target, overall and within each region — formulas and SQL.
- How do two quotes compare, line by line?
Put two quotes side by side by item, compare line totals, and catch items included in one quote but not the other before choosing a supplier.
- How fast is each product's stock turning over?
Join a stock report to a sales export by SKU to calculate inventory turnover and days of cover per product, and spot slow movers.
- How much has each customer spent, net of refunds?
Calculate each customer's net lifetime revenue by joining an orders export to a refunds export — formula, SQL and a worked example.
- How much of our revenue does GA4 actually record?
Join your shop's daily sales to GA4's daily purchase revenue to measure tracking coverage and spot days where tracking broke.
- How to blend Search Console data across multiple sites
Roll up Search Console clicks and impressions from several properties into one table with a site column, then compare sites and shared queries.
- How to build a cross-channel marketing report from CSV exports
Normalise date, campaign, spend and conversion columns from several ad and email CSV exports into one cross-channel marketing report you can trust.
- How to combine agency client reports into one spreadsheet
Roll up per-client report exports into one cross-client view: add a client column, map metric names, stack the files and compare clients fairly.
- How to combine clinic appointment exports into one spreadsheet
Combine appointment exports from several clinics or booking systems to measure utilisation and no-show rates, while keeping patient data minimal.
- How to combine donation exports into one spreadsheet
Combine donations from fundraising platforms, card payments and bank transfers into one table so each donor's giving is counted once.
- How to combine event ticket exports into one spreadsheet
Merge ticket sales exports from several events or ticketing platforms into one table to see repeat attendees, revenue by event and ticket type.
- How to combine LinkedIn Ads and HubSpot lead data
Join LinkedIn Campaign Manager spend to HubSpot contacts and deals by campaign to get cost per lead, cost per opportunity and cost per customer.
- How to combine Meta Ads, TikTok Ads and Google Ads spend in one sheet
Map column names, currencies and attribution windows across Meta, TikTok and Google Ads exports so spend and conversions sit in one comparable sheet.
- How to combine quarterly survey waves into one spreadsheet
Stack quarterly survey exports into one table with a wave column, line up questions that were reworded or added, and chart trends across waves.
- How to combine Search Console exports from multiple date ranges
Work around Search Console's 1,000-row export and 16-month history by stacking period exports with a period column, then compare queries across periods.
- How to combine YouTube Analytics and GA4 data
Link YouTube Studio video performance with GA4 sessions and key events from YouTube referrals to see which videos send visitors who convert.
- How to join Google Ads search terms with Search Console queries
Find queries where you pay for clicks and already rank organically by joining the Google Ads search terms report to Search Console query data.
- How to merge Amazon Ads and Seller Central reports by ASIN
Join Amazon Ads spend by ASIN to Seller Central sales by ASIN to calculate TACoS and see which products depend on advertising to sell.
- How to merge email campaign results with GA4 conversions
Join your email platform's sends, opens and clicks to GA4 sessions and key events by utm_campaign to see which emails actually drive conversions.
- How to merge keyword rankings with Search Console data
Join a rank tracker export to Search Console clicks and impressions by keyword and URL to see which tracked rankings actually bring traffic.
- How to merge two tables and summarise them with a pivot
Join an orders table to a lookup table, then pivot the result by region or category without double counting order headers or totals.
- How to merge UTM campaign data with CRM leads
Clean inconsistent utm_source, utm_medium and utm_campaign values, then join them to CRM leads to see which sources produce qualified leads and revenue.
- Marketing channel report template
Free spreadsheet template that joins ad spend exports with CRM leads and revenue by channel, then works out cost per lead and ROAS for each channel.
- Microsoft Copilot in Excel vs Analistable
Copilot works inside the open Excel workbook; Analistable answers questions across several files and Google Sheets. Licensing, data rules and trade-offs.
- The best AI tools for spreadsheet analysis, judged on what matters
An honest roundup of AI tools for spreadsheet analysis, judged on privacy, multi-file questions, accuracy you can check and how much setup each needs.
- What is our repeat purchase rate?
Calculate the share of customers who ordered more than once, across one or several order exports: formula, SQL, and the choices that change the number.
- What sells best, and who spends most, across all our stores?
Combine order exports from several stores or brands to rank products and customers overall, and find customers who buy in more than one store.
- When did each customer first and last order?
Stack order exports from several files or stores and get each customer's first order, last order and order count — with MINIFS, MAXIFS and SQL.
- Which customers are new this month?
List customers who appear in this month's orders but in no earlier month: a COUNTIF formula, the SQL query, and why you need full history, not just last month.
- Which customers stopped ordering this month?
Compare two monthly order exports to list customers who ordered last month but not this month — with a COUNTIF formula, the SQL anti join and pitfalls.
- Which invoices are more than 30 days overdue?
Join invoices to payments to get the outstanding balance per invoice and days overdue, then list invoices more than 30 days past due — formula and SQL.
- Which keywords do both sites rank for?
Join two Search Console or rank-tracker exports on query to find keywords both sites rank for — overlap, cannibalisation between your own sites, and gaps.
- Which leads never became customers?
Match a lead export to your customer list by email to find unconverted leads and lead-to-customer conversion rates by source — formula and SQL.
- Which orders got a discount without a promo code?
Audit an order export for discounts given without a promo code — manual price overrides and unauthorised discounts — with FILTER and SQL.
- Which orders were refunded but still shipped?
Join a refunds export to shipping data by order ID to find orders refunded before they shipped — goods sent for free — with formulas and SQL.
- Which products are most often bought together?
Find cross-sell pairs from order line exports: a self-join on order ID counts how often two products appear together, plus support and confidence.
- Which products are returned more than average?
Combine sales and returns from several marketplaces, calculate return rate per product and channel, and flag products above the average.
- Which suppliers deliver late, and by how much?
Join purchase orders (promised dates) to delivery records (actual dates) to measure on-time delivery and average days late per supplier.
- Why don't these two reports add up to the same total?
Two reports disagree on a total? Join them on the grouping column to find which rows differ and which exist in only one report — formula and SQL.
- Zapier vs manual exports for combining data
Should you automate data combining with Zapier or keep exporting CSVs by hand? Costs, complexity and failure modes compared with a worked example.
How to combine data in Google Sheets
Combine data from multiple tabs or files in Google Sheets with array literals, VSTACK, QUERY and IMPORTRANGE, and join sheets by a key with XLOOKUP.
- Coefficient alternatives for Google Sheets: a fair comparison
A fair look at Coefficient's Google Sheets connectors and the alternatives: Supermetrics, Connected Sheets, Apps Script, IMPORTDATA and browser tools.
- Excel vs Google Sheets for combining data, feature by feature
Power Query against IMPORTRANGE and QUERY: how Excel and Google Sheets compare for combining data, with size limits, joins and collaboration.
- How to combine multiple IMPORTRANGE formulas
Stack data from several Google Sheets files with VSTACK and IMPORTRANGE, filter it with QUERY, and fix access errors, slow loading and size limits.
- How to link two Google Sheets
Link two Google Sheets: reference cells, pull rows with IMPORTRANGE, and match records by ID with XLOOKUP or VLOOKUP — for one cell or a whole column.
- How to match Google Forms responses to a master list
Check which people on a master list have submitted a Google Form, bring their answers next to their names, and list who still needs a reminder.
- How to merge Google Sheets into one
Merge tabs or whole Google Sheets files into one: VSTACK and array literals, QUERY to drop blanks, a source column, and IMPORTRANGE for other files.
- How to merge sheets with Google Apps Script
A copy-ready Google Apps Script that merges tabs or files into one sheet with a source column, plus how to run it on a schedule with a time-driven trigger.
- How to SUMIF across multiple sheets in Google Sheets
Sum with a condition across several tabs in Google Sheets: add SUMIFs together, use QUERY over stacked tabs, or MAP with INDIRECT for a list of sheet names.
- How to use QUERY with multiple ranges in Google Sheets
Run one QUERY over several tabs or ranges in Google Sheets: stack them in { ; }, use Col1 notation, group and sum, and avoid the common errors.
- IMPORTRANGE not working: every error and how to fix it
Fix IMPORTRANGE #REF! errors, the 'You need to connect these sheets' prompt, permission errors, wrong range strings, endless Loading and size limits.
- Why QUERY across multiple Google Sheets returns errors or misses rows
Fix QUERY errors over stacked ranges in Google Sheets: NO_COLUMN, array literal errors, header rows mixed in and rows silently dropped by mixed types.
How to combine Excel sheets into one
Combine multiple Excel sheets into one sheet: VSTACK, Power Query Append, Consolidate, pivot tables and copy-paste, with examples and when to use each.
- #SPILL! when stacking sheets with VSTACK: causes and fixes
VSTACK returns #SPILL! when its output range is blocked, sits in a table or merged cells, or runs off the sheet. Find the cause and fix each one.
- Combined sheet has blank rows: why it happens and how to fix it
Blank rows or rows of zeros after combining sheets come from oversized ranges, formatted empty cells and VSTACK padding. Filter them out at the source.
- Combining data with VSTACK, HSTACK and other dynamic arrays
Use Excel's dynamic array functions to combine data: VSTACK and HSTACK across sheets, add a sheet-name column, drop blank rows, dedupe and sort in one formula.
- Combining files with merged header rows: flatten first, then stack
Report exports with two-row or merged headers don't stack cleanly. Flatten them into single, unique column names first in Excel, Power Query or pandas.
- Dates change format when combining Excel files: find and fix them
Fix day and month swapping, dates stored as text and wrong sort order after combining Excel or CSV files from UK and US sources, with formulas and Power Query.
- How to add a source column when combining files or sheets
Add a column showing which file or sheet each row came from when you combine Excel data, using Power Query, VSTACK, Python or VBA.
- How to combine tables in Excel
Combine Excel tables by stacking them with VSTACK or Power Query Append, or by joining them on a key with Merge Queries. Structured references explained.
- How to combine two pivot tables in Excel
Excel can't merge two pivot tables directly. Combine their source data, relate them in the Data Model, or build a side-by-side report with GETPIVOTDATA.
- How to combine two sheets in Excel
Combine two sheets in one Excel workbook: stack them with VSTACK or copy-paste, or match them side by side with XLOOKUP. Examples and the pitfalls to avoid.
- How to create a pivot table from multiple sheets
Three ways to build one pivot table from several sheets: stack them first, use the Data Model with relationships, or the Multiple Consolidation Ranges wizard.
- How to merge every Excel table into one sheet
Use Power Query's Excel.CurrentWorkbook to stack every table in a workbook into one sheet, including tables added later, with a column naming each source.
- How to pull data from multiple sheets into one summary sheet
Pull a value or row from many Excel sheets into one summary sheet with INDIRECT and a sheet list, 3D references or VSTACK — and the trade-offs of each.
- Why and how to unpivot wide reports before merging
Month-per-column reports can't be stacked or joined reliably. Unpivot them to long format in Power Query, pandas or SQL, then merge on clean keys.
How to compare two spreadsheets for differences and matches
How to compare two Excel sheets or lists: find differences, matches, missing rows and duplicates with formulas, conditional formatting, Power Query or a tool.
- Customer churn comparison template
Compare two customer lists to see churned, new, expanded and contracted accounts, with logo churn rate and net revenue retention. Free Excel download.
- Duplicate checker template
Free Excel duplicate checker: paste a list, and formulas clean the key, count repeats, mark the first occurrence to keep and summarise how many rows to remove.
- How to combine duplicate rows in Excel
Merge duplicate rows in Excel into one row per value: sum numbers with a pivot table or GROUPBY, join text with TEXTJOIN, or use Power Query Group By.
- How to compare two columns in Excel
Compare two columns in Excel row by row or as lists: = and EXACT, Ctrl+\ for row differences, conditional formatting, COUNTIF and XMATCH to find missing values.
- How to compare two Excel sheets for differences
Find every difference between two Excel sheets: a difference formula, conditional formatting, View Side by Side, Spreadsheet Compare and key-based checks.
- How to compare two price lists
Compare two price lists by SKU — old vs new, supplier vs supplier, or shop vs supplier: price changes and %, new and discontinued items, cheapest supplier.
- How to do case-sensitive matching between two lists
Excel lookups ignore case, so ABC and abc match. Use EXACT with XLOOKUP, XMATCH or FILTER for case-sensitive matches, or decide to normalise case instead.
- How to find matches between two lists in Excel
Find values that appear in both lists, or only in one, with COUNTIF, MATCH and ISNUMBER, XMATCH and FILTER — across columns, sheets or workbooks.
- How to merge an old and new list and flag new, removed and changed rows
Combine last month's and this month's list with a full outer join and a status column marking each row new, removed, changed or unchanged.
- How to merge contact lists without duplicates
Combine Mailchimp, HubSpot, Klaviyo or LinkedIn lead exports into one list: normalise emails, pick which record wins, and never lose an unsubscribe.
- How to merge two spreadsheets and remove duplicates
Combine two Excel lists into one without duplicates: UNIQUE and VSTACK, Remove Duplicates, keeping the newest row, and a refreshable Power Query version.
- Master customer list template
Free workbook that merges customer lists from your CRM, web shop and newsletter into one master list, deduplicated by email, with no macros.
- Price comparison template
Free supplier price comparison workbook: paste each supplier's price list, compare unit prices side by side and see the cheapest supplier per item.
- The best tools to compare two spreadsheets
Excel formulas, Spreadsheet Compare, Power Query, diff tools, add-ins and browser tools for comparing two spreadsheets: what each finds and its limits.
- Two-list comparison template
Free Excel template that compares two lists by key: flags rows in both, only in list A or only in list B, and spots names that changed between lists.
How to consolidate data in Excel
Consolidate data in Excel from multiple sheets or rows: the Consolidate tool, 3D SUM, SUMIFS, pivot tables and Power Query Group By, with worked examples.
- Cash flow consolidation template
Free Excel template that rolls up cash flows from several entities into one group view, with opening and closing cash and an intercompany check.
- Consolidation template for Excel
General-purpose Excel consolidation template: stack data from any number of sources in one sheet and get a category-by-source grid with totals and checks.
- Excel Consolidate not working: why it doesn't update or ignores rows
Excel Consolidate not updating or ignoring rows? Fix static results, labels that don't match, ranges that miss new data and text stored as numbers.
- Expense consolidation template
Free Excel template that stacks expense claim lines from every employee, checks each line against category limits and totals spend by category.
- How to append monthly files without duplicates
Monthly exports often overlap. Append them each month and remove repeats on a natural key in Power Query, Excel formulas or Python, keeping the latest version.
- How to build a consolidation worksheet template in Excel
Download a free consolidation worksheet template for Excel, or build your own: identical input sheets, 3D SUM formulas and check totals that catch errors.
- How to combine branch inventory counts into one spreadsheet
Combine stock count sheets from every branch into one company-wide view by SKU, with branch totals, gaps and over-stock visible side by side.
- How to combine class and enrolment lists into one master roster
Combine class lists and course enrolment exports into one master roster, with one row per student and no duplicates from students in several classes.
- How to combine franchise P&L and department budget files into one rollup
Roll up franchise P&Ls and department budgets that use different account lines by mapping each line to a shared chart of accounts first.
- How to combine monthly bank statements into one spreadsheet
Stack monthly bank and fuel card statement exports into one table with consistent dates and signs, and remove transactions duplicated across overlaps.
- How to combine monthly expense claims into one spreadsheet
Turn a folder of per-employee expense claim sheets into one ledger you can approve, total by category and check against policy limits.
- How to combine monthly, store and country sales reports into one spreadsheet
Stack monthly, per-store and per-country sales files into one table with period, store and currency columns so you can total and compare them.
- How to combine project status trackers into one spreadsheet
Roll up each team's project tracker into one portfolio view with consistent statuses, owners and dates, without asking teams to change tools.
- How to combine property rent rolls into one portfolio rent roll
Build a portfolio rent roll from per-property spreadsheets, then report occupancy, passing rent and arrears for every building in one table.
- How to combine weekly timesheets into one spreadsheet
Stack weekly timesheet files from every person into one long table so payroll hours and project hours both come from the same source.
- How to merge rows in Excel without losing data
Merge several rows into one in Excel without losing data: TEXTJOIN into one cell, Fill → Justify for text blocks, and consolidating rows that share a key.
- How to use SUMIFS across multiple sheets
Sum with criteria across many Excel sheets: 3D SUM for same-layout sheets, SUMPRODUCT with INDIRECT and a sheet list, or FILTER and VSTACK in Microsoft 365.
- How to use the Consolidate function in Excel
Use Excel's Data → Consolidate to combine and summarise ranges from several sheets or workbooks: by position or by label, with links, and its limits.
- Inventory consolidation template
Free workbook that combines stock counts from several locations into one table: quantity per site, total stock value and a reorder flag per SKU.
- Monthly reporting consolidation template
Free Excel template that combines monthly figures from each unit into one report of revenue, costs, profit, margin and headcount, with a submission check.
- Multi-entity P&L consolidation template
Free Excel template that converts each entity's P&L to one currency, applies intercompany eliminations and builds a consolidated P&L by line.
- Multi-store sales template
Free multi-store sales workbook that rolls up sales lines from every shop into units, revenue, % of target and a ranking per store and region.
- Sales by region roll-up template
Free workbook that stacks regional sales exports, totals each region with SUMIFS and compares it with target, variance and share of total sales.
- Student grades roll-up template
Free Excel and Google Sheets template that rolls marks from every assessment into one total and percentage per student, and flags missing work.
- Timesheet consolidation template
Free Excel template that stacks timesheet entries from every employee, compares hours with contracted hours and totals time by project.
- Why totals double after consolidating, and how to audit them
Consolidated total twice what it should be? Check for subtotal rows, a summary sheet inside the 3D range, overlapping ranges and one-to-many joins.
How to join spreadsheets on a common column
Join two spreadsheets on a shared column with XLOOKUP, Power Query Merge or SQL-style joins. Learn join types, key cleaning and how to check every match.
- Airtable vs spreadsheets for linked data
Airtable linked records against spreadsheet lookups: how each handles related tables, where spreadsheets still win and when it is time to move.
- Alteryx alternatives for occasional spreadsheet joins
Alteryx is excellent for complex, repeatable data workflows. For occasional spreadsheet joins, these lighter options may do the same job for less.
- Commission calculation template
Free sales commission template: looks up a rate per product line for each deal, totals commission per rep and adds an accelerator above quota.
- How to combine data from multiple sources
Bring CRM, billing, ads and spreadsheet data together: choose a common key, build a mapping table, align time and currency, then stack or join.
- How to combine GA4 properties into one report
Combine GA4 properties into one report: roll-up properties (Analytics 360), Looker Studio, or stacking exports in a sheet — and which metrics add up.
- How to combine Google Analytics and Search Console data
Join GA4 landing page data with Search Console clicks and queries: the built-in link, matching URLs correctly, and estimating conversions per search query.
- How to combine student grades and attendance records
Join class lists, grades and attendance by student ID to spot students at risk, find missing assignments and compare attendance with results.
- How to combine supplier price lists into one spreadsheet
Stack price lists from several suppliers into one table, map their codes to your SKUs and see the cheapest supplier for every product.
- How to compare event registrations with attendance
Match a registration list to check-ins or webinar attendance: attendance rate, no-shows to follow up, walk-ins to add, and which leads attended.
- How to do an inner join in Excel
Keep only rows that match in both tables. Do an inner join in Excel with Power Query Merge, or with one FILTER + XMATCH formula in Microsoft 365.
- How to find pages losing clicks, and which ones matter
Compare two periods in Search Console to find pages losing clicks, then join GA4 conversions to fix the ones that matter most first. Formulas included.
- How to fix mismatched IDs before joining two spreadsheets
IDs like CUST-0042, cust42 and 42 refer to the same record but never join. Normalise prefixes, padding, dashes and case with formulas, Power Query or SQL.
- How to join on dates and date ranges
Match each transaction date to the price, rate or fiscal period valid on that day with XLOOKUP, SUMIFS, FILTER or a SQL BETWEEN join.
- How to join on the closest match with an approximate lookup
Find the band, tier or rate for a value with approximate-match lookups in Excel and Sheets, what sorting they need, and ASOF joins in SQL.
- How to join tables with Excel's Data Model
Use Excel's Data Model to relate tables instead of VLOOKUP: create relationships, build a PivotTable across tables, and know the requirements and limits.
- How to join two lists on email addresses safely
Normalise case, whitespace and aliases before matching contact lists on email, avoid false matches, and keep personal data handling in check.
- How to join two spreadsheets on a common column
Three reliable ways to join two spreadsheets by a shared ID or email: XLOOKUP, Power Query merge and a SQL-style join — plus the mistakes that break matches.
- How to join two tables in Excel
Join two Excel tables on a shared column with Power Query Merge Queries or XLOOKUP: step-by-step, choosing a join kind, and checking the result.
- How to join two tables on two columns at once
Match rows on two or more columns with a helper key, XLOOKUP boolean arrays, a Power Query multi-column merge or a SQL composite key.
- How to match an employee list to training records
Check training compliance in Excel: join the HR employee list to training records, find who's missing a course, and list certifications expiring soon.
- How to match CRM deals to invoices
Find closed-won deals that were never invoiced and invoices with no deal: match CRM exports to your invoice list by deal ID, customer and amount.
- How to match Google Ads conversions to CRM deals
Check which Google Ads leads became revenue: store the GCLID in your CRM, join deals to campaigns, and compare reported conversions with closed revenue.
- How to match HubSpot contacts to Stripe customers
Join HubSpot contacts to Stripe customers by email: normalise addresses, handle duplicate Stripe records, find paying leads and payers missing from the CRM.
- How to match names that are spelled differently across sheets
Match company or customer names with typos and different spellings using normalisation, similarity scores and a review queue, without Power Query.
- How to match support tickets to customer accounts
Join a Zendesk or helpdesk ticket export to customer accounts by email domain to see ticket volume by plan, revenue and priority, and spot at-risk accounts.
- How to match survey responses to your customer list
Join survey answers to customer data by email to analyse results by plan, region or spend, calculate NPS per segment, and see who hasn't responded.
- How to match timesheet hours to projects and invoices
Roll up time logged in Jira or a timesheet tool by project, compare it with budgeted hours and with hours invoiced, and find unbilled work.
- How to merge GA4 data with ad cost data
Combine GA4 conversions and revenue with Google Ads, Meta or LinkedIn cost data by date and campaign to calculate ROAS and cost per conversion in a sheet.
- How to merge product data from several sources
Merge product catalogues and feeds from suppliers, your shop and your ERP on SKU or GTIN, and decide which source wins when attributes conflict.
- How to return every match in one cell with TEXTJOIN
XLOOKUP returns only the first match. Use TEXTJOIN with FILTER to list every matching value in one cell, in Excel and Google Sheets, with older-version options.
- How to use XLOOKUP with another workbook
Look up and link data from another Excel workbook with XLOOKUP and external references: syntax, closed files, updating links and fixing broken ones.
- How trailing and non-breaking spaces break matches between spreadsheets
Invisible trailing spaces and non-breaking spaces stop values matching across sheets. Detect them with LEN and CODE, then clean with TRIM and SUBSTITUTE.
- Lead to customer match template
Free Excel template that matches a lead list to a customer list by email, flags which leads converted and totals conversion rate and revenue by source.
- Left join vs XLOOKUP: when and why the results differ
A left join can return more rows than XLOOKUP, show blanks where XLOOKUP shows 0, and miss matches XLOOKUP finds. Why, and which behaviour you want.
- Numbers stored as text stop lookups working — how to fix it
A number and the same digits stored as text never match in VLOOKUP, XLOOKUP or a join. Spot text-numbers, convert them, or cast keys to one type.
- Project hours vs budget template
Free Excel template that totals timesheet hours and cost per project, compares them with budgeted hours and flags projects at risk or over budget.
- Reusable lookups with LET and LAMBDA
Make long lookup and join formulas readable with LET, then turn them into your own reusable Excel function with LAMBDA and the Name Manager.
- SEO report template for GA4 and Search Console
Free SEO report workbook that joins Search Console page data with GA4 landing pages by URL path, showing CTR, engagement, key events and flags.
- Survey merge template
Free spreadsheet template that joins survey responses to your customer list by email, adds segment and region, and summarises scores by segment.
- VLOOKUP returns #N/A across sheets: every cause and its fix
A checklist of every reason VLOOKUP or XLOOKUP returns #N/A between sheets or files — ranges, match mode, types, spaces, missing keys — with a fix for each.
- VLOOKUP vs Power Query vs SQL: which should you use to join sheets?
Choose between VLOOKUP, Power Query and SQL to join spreadsheets by data size, how often you repeat the job and how comfortable you are with each.
- VLOOKUP vs XLOOKUP vs INDEX MATCH: which should you use?
A clear comparison of VLOOKUP, XLOOKUP and INDEX MATCH: syntax, limitations, compatibility, and when a lookup isn't enough and you need a join.
- Why a lookup fails on numbers with decimals
Exact-match lookups compare stored values, not what the cell shows. Hidden decimals and floating-point noise break numeric keys; ROUND or TEXT fixes them.
- Why you get duplicate rows after joining two tables
A join that returns more rows than you started with has a non-unique key. Find the duplicate keys, then dedupe or aggregate before you join.
- XLOOKUP returns the wrong row after merging — how to find and fix silent mismatches
XLOOKUP can return a value from the wrong row without any error: duplicate keys, approximate match, misaligned ranges and wildcards. How to catch each.
How to merge cells, columns and text in Excel
Merge cells, combine columns and join text in Excel and Google Sheets without losing data: Merge & Center, &, CONCAT, TEXTJOIN, Flash Fill and alternatives.
- How to combine text from multiple cells in Excel
Combine text from two or more cells in Excel: &, CONCAT and TEXTJOIN, separators and line breaks, skipping blanks, formatted numbers, and joining by condition.
- How to combine two columns in Excel
Combine two columns in Excel into one without losing data: the & operator, CONCAT, TEXTJOIN, Flash Fill and Power Query Merge Columns, plus dates and numbers.
- How to concatenate in Google Sheets
Combine text in Google Sheets with &, CONCATENATE, CONCAT, TEXTJOIN and JOIN: differences, separators, skipping blanks and filling a whole column.
- How to merge and unmerge cells with VBA
Merge cells with VBA using Range.Merge and MergeCells, keep every value instead of only the top-left, and unmerge and fill a whole sheet in a loop.
- How to merge cells in Excel
Merge cells in Excel with Merge & Center, Merge Across or Merge Cells, unmerge them, find merged cells, and keep every value by combining the text first.
- How to merge cells in Google Sheets
Merge cells in Google Sheets horizontally, vertically or all at once, unmerge them, and combine the contents of cells without losing any data.
- How to use Center Across Selection in Excel
Centre a heading over columns without merging cells. Exact steps, a keyboard shortcut workaround, the Google Sheets equivalent and why it beats Merge.
- How to use Merge & Center in Excel
Merge and Center in Excel with the Alt+H+M+C shortcut, fix it when it's greyed out, avoid losing data and use the safer Center Across Selection.
- Merged cells break sorting and filtering: unmerge and fill down
Why merged cells stop Excel sorting, hide rows from filters and break combines, and how to unmerge and fill down the values safely in a few steps.
How to merge CSV files into one
Merge multiple CSV files into one: in Excel with Power Query, on Windows or Mac from the command line, in Python, or in your browser. Headers handled correctly.
- Combining CSV files with different delimiters without shifted columns
Comma, semicolon and tab CSVs in one folder make columns shift when stacked. Identify each delimiter, handle quoted commas and normalise before merging.
- CSV encoding problems when combining files: UTF-8 vs ANSI
Garbled accents like é or a stray  after combining CSVs? Detect each file's encoding (UTF-8, ANSI, BOM) and re-save every file as UTF-8 before merging.
- How to combine CSV files in Excel
Combine multiple CSV files into one Excel sheet or workbook with Power Query From Folder, and fix delimiter, encoding, leading-zero and date problems.
- How to combine CSV files into one on a Mac
Merge CSV files on a Mac with one Terminal command that keeps a single header row, or with Excel's Power Query, or in the browser. Copy-ready commands.
- How to join a big CSV to a small lookup table
Enrich a CSV too big for Excel with a small mapping table using Power Query, pandas or DuckDB, without hitting the 1,048,576-row limit.
- How to join two CSV files by a common column
Join two CSV files on a shared column with Excel Power Query, csvkit's csvjoin, pandas or DuckDB — inner and left joins, examples and pitfalls.
- How to merge CSV files on Windows
Merge CSV files on Windows 10 or 11 with one Command Prompt or PowerShell command, keep a single header row, and avoid encoding and end-of-file problems.
- How to merge large CSV files
Merge CSV files too big for Excel: command-line concatenation, DuckDB, pandas in chunks, or Power Query into the Data Model — with sizes each method handles.
- How to split a large file into chunks and rejoin it safely
Split an oversized CSV into chunks with one header each, then recombine them later without duplicate headers, missing rows or broken quoted lines.
- Leading zeros lost when merging CSV files: how to keep IDs intact
Why Excel strips leading zeros and turns long IDs into scientific notation when you merge CSV files, and how to keep every ID as text from start to finish.
- Merged CSV has duplicate header rows: why and how to remove them
Combining CSVs with copy or cat repeats the header from every file. Skip header lines when merging, or strip the repeats afterwards in Excel or Power Query.
- The best free ways to merge CSV files
Free ways to merge CSV files compared: command line, Excel Power Query, Python, csvkit, Google Sheets and browser tools — headers, columns, size and privacy.
How to merge data in pandas, R and SQL
How to merge and join tables in pandas, R (merge, dplyr) and SQL: join types, keys, stacking vs joining, and the same examples side by side.
- How to combine two tables in SQL
Combine two tables in SQL side by side with JOIN or stacked with UNION and UNION ALL: syntax, examples, column rules and how to choose.
- How to join multiple tables in SQL
Copy-paste examples for joining 3 or more tables in SQL: chain JOIN … ON, mix INNER and LEFT joins safely and avoid double-counted totals.
- How to merge CSV files in Python
Merge CSV files in Python: stack a folder of CSVs with glob and pandas.concat or the csv module, or join two CSVs on a shared key column.
- How to merge data frames in R
Merge data frames in R with base merge() or dplyr joins: inner, left, full and anti joins, different key names, and stacking with rbind or bind_rows.
- How to merge DataFrames in pandas
Merge two pandas DataFrames on a key with merge(): inner, left, outer and anti joins, different key names, validate, indicator, and when to use concat.
- How to merge datasets in SAS
Merge datasets in SAS with DATA step MERGE and BY: sorting, IN= flags for inner, left and anti joins, one-to-many merges, and PROC SQL alternatives.
- How to merge datasets in Stata
Merge datasets in Stata with merge 1:1, m:1 and 1:m, read the _merge variable, keep only matches, and stack datasets with append. Examples included.
- How to use MERGE (upsert) in BigQuery and Snowflake
Use MERGE in BigQuery and Snowflake to upsert: WHEN MATCHED and NOT MATCHED clauses, deletes, and why you must dedupe the source table first.
- Python vs Excel for merging files: when pandas is worth it
When pandas beats Excel and Power Query for merging files, and when it does not: size, repeatability, sharing and the skills each route needs.
- Why a SQL join returns too many rows, and how to fix it
A SQL join returns too many rows when keys repeat or a join condition is missing. Count keys first, then aggregate in a CTE before joining.
- Why pandas merge creates duplicate rows, and how to stop it
pandas merge multiplies rows when a key repeats on both sides. Find the culprit with validate= and indicator=, then dedupe or aggregate before you merge.
- Why R merge() drops rows unexpectedly, and how to keep them
R's merge() is an inner join by default, so unmatched rows vanish. Fix it with all.x, consistent key types, trimmed text and careful NA and factor handling.
How to merge data in Power BI, Power Query and Tableau
How Power Query merges and appends data in Excel and Power BI, how Tableau joins, relationships and blends differ, and which to use for your data.
- How to combine datasets in Amazon QuickSight
Join datasets in Amazon QuickSight data prep: add data, choose join type and keys, and avoid duplicate rows and failed cross-source joins.
- How to combine files from a folder with Power Query
Combine every Excel or CSV file in a folder with Power Query: the helper queries it creates, filtering files, adding the file name and fixing refresh errors.
- How to combine files with different sheet names in Power Query
Combine workbooks whose sheet names differ in Power Query: pick the sheet by position or Kind, match names loosely, and leave hidden sheets out.
- How to combine multiple files into one table with Power Query parameters
Make a Power Query folder combine reusable: put the folder path and file filters in parameters or a worksheet cell, and turn the logic into a function.
- How to join data sources in Tableau
Combine data sources in Tableau: relationships (the default), joins and cross-database joins in the physical layer, unions, and blends — when to use each.
- How to merge columns in Power Query (Excel and Power BI)
Join two or more columns into one in Power Query with Merge Columns or a Text.Combine custom column, handling separators, nulls and numbers.
- How to merge columns in Tableau
Merge two columns in Tableau with a combined field or a calculated field using + and STR(), and handle nulls with IFNULL so labels don't go blank.
- How to merge Power BI reports
There is no merge button for .pbix files. Combine Power BI reports by copying visuals, sharing one semantic model, or bundling reports in an app.
- How to merge Tableau workbooks
Merge Tableau workbooks with Import Workbook or by copying sheets, then reconcile duplicate data sources, calculated fields and dashboards.
- How to merge tables in Power BI
Merge two tables in Power BI with Merge Queries in Power Query, or relate them in the model instead. Steps, join kinds, DAX options and how to choose.
- How to use Append Queries in Power Query
Stack two or more tables with Power Query Append in Excel or Power BI. Append vs Append as New, mismatched columns and a source column,, step by step.
- How to use fuzzy merge in Power Query
Match names that are spelled differently with Power Query fuzzy merge: similarity threshold, ignore case, transformation tables and how to check the matches.
- Power BI alternatives for joining spreadsheets
Power BI is built for dashboards and data models. When all you need is to join a few spreadsheets, these simpler options are often the better fit.
- Power Query Combine Files errors and how to fix each one
Fix Power Query Combine Files errors: column not found, DataFormat.Error, key didn't match and silently skipped files, traced to the sample transform.
- Power Query Merge Queries: every join kind explained
Left outer, right outer, full outer, inner, left anti and right anti joins in Power Query Merge Queries, with the same example for each and when to use them.
- Tableau Prep alternatives for small teams
Tableau Prep is a capable data preparation tool. Lighter options for small teams that mostly join and clean spreadsheets, compared fairly.
- Why Power Query merge returns nulls, and how to fix it
Merged columns full of null in Power Query? Check key types, spaces, case, the join kind and duplicate keys, with a worked example and an M fix for each.
- Why Power Query refresh is slow with many files, and how to speed it up
Speed up a slow Power Query folder combine: filter files before opening them, cut repeated steps, switch off background previews and buffer with care.
How to merge Excel files: every method compared
Merge Excel files into one workbook or one sheet: copy-paste, Move or Copy, Power Query, VBA, Power Automate and browser tools compared, with when to use each.
- Alternatives to the Ablebits Merge Tables Wizard
Alternatives to Ablebits Merge Tables Wizard for matching and merging Excel tables: XLOOKUP, Power Query Merge, and Analistable — features and trade-offs.
- E-commerce marketplace sales roll-up template
Free workbook that stacks Amazon, eBay and Etsy order exports and rolls them up by marketplace and SKU: orders, units, fees, refunds and net sales.
- Excel “file format and extension don’t match” when merging files
The file format and extension don't match error means an .xls is really HTML, XML or CSV. Identify the real format and convert it before you merge.
- How to combine Excel files on a Mac
Combine Excel files on a Mac with Power Query From Folder in Microsoft 365, Move or Copy, or a browser tool, plus what's different from Excel for Windows.
- How to combine Excel files with different columns
Merge Excel files whose columns differ in order, name or number. Stop Power Query dropping columns, align headers fast, or combine them free online.
- How to combine multiple Excel files into one automatically
Three ways to merge Excel files automatically: Power Query refresh on open, a VBA macro that loops through a folder, or a scheduled Power Automate flow.
- How to combine multiple Excel files into one spreadsheet
Combine multiple Excel files into one sheet with Power Query From Folder: every step, how to handle different sheet names, and a no-formula alternative.
- How to combine two Excel files into one
Combine two Excel files into one: stack rows when columns match, copy sheets into one workbook, or join side by side on a shared ID. Steps for each case.
- How to combine workbooks with Office Scripts
Use two Office Scripts and a Power Automate flow to combine Excel workbooks in OneDrive or SharePoint quickly, with copy-ready TypeScript code.
- How to merge data from closed workbooks in Excel
Pull data from closed Excel workbooks: what external references can do, why INDIRECT returns #REF!, and when Power Query is the better route.
- How to merge Excel files with Power Automate
Build a Power Automate flow that merges Excel files from OneDrive or SharePoint into one master table on a schedule, plus the limits that trip people up.
- How to merge Excel files without uploading them
Most online Excel mergers upload your files. Learn which methods keep data on your computer, how to check whether a tool uploads, and why it matters.
- Kutools Combine alternatives: built-in Excel and browser options
Kutools for Excel's Combine wizard against built-in Excel features and browser tools: what each handles, platform limits and when the add-in is worth it.
- Merging files larger than Excel’s row limit
Merged data over 1,048,576 rows, Excel crashing or a file too large to open? Load to the Data Model, keep queries as connections, or query the files instead.
- Power Query vs Analistable for combining files
Power Query or Analistable for combining spreadsheets? Compare setup, repeatability, joins, Google Sheets support, privacy and when each is the better choice.
- The best tools to merge Excel files, compared
Excel's Power Query, VBA, Power Automate, add-ins like Ablebits and Kutools, Python and browser tools for merging Excel files: features, limits and fit.
How to reconcile data in Excel
Reconcile two spreadsheets in Excel: clean the keys, match on IDs or date and amount, find what's missing on each side and explain the differences.
- Bank reconciliation template
Free bank reconciliation workbook: paste bank and ledger lines, match them by reference and amount, and see the adjusted balance and any unexplained difference.
- Budget vs actual template
Free budget vs actual workbook: paste your budget and transaction lines, and SUMIFS builds the variance by cost centre and account with a review flag.
- Event attendance reconciliation template
Free template that matches event registrations to check-in scans by email to find no-shows, duplicate scans and walk-ins, with an attendance summary.
- How to compare budget vs actuals in Excel
Compare budget with actuals in Excel across files: map accounts, calculate variance and variance %, and flag favourable and adverse lines.
- How to do a bank reconciliation in Excel
Do a bank reconciliation in Excel: match the bank statement to the cash ledger, list outstanding cheques and deposits in transit, and prove the balances agree.
- How to do a three-way match in Excel
Three-way match in Excel: compare purchase orders, goods received notes and supplier invoices line by line, and flag quantity and price differences.
- How to match a membership list to payment records
Find members who haven't paid, payments from non-members and failed direct debits by matching a membership list to payment exports in Excel.
- How to match Amazon FBA fees to your orders
Turn Amazon's settlement report into one row per order — item price, referral fee, FBA fee, refunds — and match it to your order report to check every fee.
- How to match donations to Gift Aid declarations
Check which donations can be included in a Gift Aid claim: match donations to declarations, apply date rules, calculate the claim and find lapsed donors.
- How to match Stripe payments to accounting invoices
Match Stripe payments to invoices exported from QuickBooks or Xero: use the invoice number, handle partial and combined payments, and list unpaid invoices.
- How to merge two sheets and keep the latest record per ID
Combine two sheets and keep only the most recent row for each ID with sort plus Remove Duplicates, MAXIFS, or ROW_NUMBER in SQL.
- How to reconcile a rent roll with rent payments
Match rent received in the bank to the rent roll: identify payers by reference, handle partial and combined payments, and produce an arrears list.
- How to reconcile a stock count with inventory records
Compare a physical stock count with system inventory by SKU and location: variances in units and value, items not counted, and consolidating two warehouses.
- How to reconcile a VAT return with your sales ledger
Check a UK VAT return against the sales ledger: rebuild Box 1 and Box 6 from invoices, split by VAT rate, and explain differences from credit notes and timing.
- How to reconcile delivery app payouts with your till
Match Uber Eats, Deliveroo and Just Eat payouts to orders in your till: commission, adjustments, refunds and missing orders, with formulas and a worked example.
- How to reconcile expense claims with card statements
Match expense claims to company card transactions (Revolut, Amex, bank cards): amount and date matching, foreign currency, missing receipts, duplicates.
- How to reconcile PayPal transactions with your bank statement
Reconcile PayPal activity with your bank: separate sales, fees and transfers, match withdrawals to bank deposits, and handle holds and currency conversions.
- How to reconcile payroll with timesheets
Check payroll against approved timesheets and the rota: match employees and periods, compare hours and overtime, and find shifts without clock-ins.
- How to reconcile shipping carrier invoices with your orders
Check carrier invoices against your shop orders by tracking number: weight adjustments, surcharges, duplicate charges and shipping you charged customers.
- How to reconcile shop orders with Stripe payouts
Match Shopify or WooCommerce orders to Stripe payouts: link orders to charges, group them by payout, account for fees and refunds, find what's missing.
- How to reconcile Square sales with bank deposits
Match Square card sales to the deposits in your bank account: group sales by deposit, account for processing fees and refunds, and spot missing deposits.
- Invoice to payment matching template
Free workbook that matches customer payments to invoices by reference and marks each invoice paid, part paid, overpaid or unpaid, plus unmatched receipts.
- Payroll reconciliation template
Free payroll reconciliation workbook: check gross-to-net on the payroll register and match net pay to bank payments per employee, flagging every gap.
- Stock reconciliation template
Free stock reconciliation template that compares physical count sheets with system stock by SKU, values each variance and flags short, over and uncounted items.
- Vendor statement reconciliation template
Free Excel template that matches a supplier statement to your payables ledger by invoice number and explains the balance difference line by line.