Analistable

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.

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.

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.

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.

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.

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.

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 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.

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 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 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.

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.