๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
๊ธฐ๋ณธ ๋ฉ”๋‰ด
Google ์•ฑ
App Icon
Find & highlight duplicates or differences in 2 or more sheets and columns in Google Sheetsโ„ข
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2025๋…„ 2์›” 17์ผ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
14๋งŒ+
๊ฐœ์š”
Compare Google Sheetsโ„ข row by row for duplicate/unique rows, or scan them cell by cell and highlight differences in contents along with non-matching rows. 3 similar yet different add-ons for Google Sheetsโ„ข will compare multiple columns and sheets for you. 

WHY THIS TOOLSET
  - no need for formulas, macros, conditional formatting
  - comparison results are clear at first glance
  - user-friendly steps to ease the job
  - save your comparison settings as scenarios for quick later use
  - share saved scenarios with others

WHAT YOU'LL FIND

  1. Compare Sheets for Duplicates
      - compare 2 or more columns or sheets in Google Sheetsโ„ข at a time
      - match data by rows (you choose the columns to consider)
      - find duplicate or unique rows no matter their position in tables
      - quickly navigate across all found values using cross-sheet links

      HOW COMPARE SHEETS FOR DUPLICATES WORKS

      - identify the found values with color or in a status columnโ€ฆ
      - โ€ฆor clear, copy, move, delete the found values
      - mark the changes in the required sheets: main, other compared, all sheets
      - add hyperlink references to connect dupes across sheets

  2. Compare Sheets Cell by Cell
      - compare as many sheets in Google Sheetsโ„ข as you need
      - match data cell by cell
      - find cells with different values across the sheets
      - find unique rows (where no cell in a row has a match in another sheet)

      HOW COMPARE SHEETS CELL BY CELL WORKS

      - highlight differences with hues of your choice
      - label differences in a status column
      - see a short description to know what other sheets look different
      - identify the changes in every compared sheet
      - create one full report with differences grouped accordingly

  3. Compare Columns
      - compare two columns on one Google sheet
      - find dupes or uniques in a single step

      HOW COMPARE COLUMNS WORKS

      - fill cells with color or add a status column
      - copy or move them to a place of your choice
      - clear values, delete cells & shift data up, or remove entire rows from the sheet

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions please post them here: https://www.ablebits.com/docs/google-sheets-compare-sheets-cells/
We'll be happy to assist!

Compare Sheets is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspaceโ„ข. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-add-ons/index.php
โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“โ€“
WHAT'S NEW:
***** V1.1 (29 May 2023) *****
โ˜… New features: โ˜…
- Compare multiple sheets for duplicates. We enhanced 'Compare columns or sheets' so it could compare not just two but multiple sheets or columns at a time. 

Improved:
- Minor UX and UI improvements.

Fixed:
- Compare sheets for duplicates:
    1. Couldn't copy the dupes from the range returned by a formula.
    2. Couldn't run the scenario if its second sheet was protected or had a protected range within.
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ๋ฌด๋ฃŒ ์ฒดํ—˜
๊ฐœ๋ฐœ์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
Compare Sheets์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
Compare Sheets์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด Compare Sheets์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
Google Drive ํŒŒ์ผ ๋ณด๊ธฐ, ์ˆ˜์ •, ์ƒ์„ฑ, ์‚ญ์ œ
๋ชจ๋“  Google Sheets ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ™•์ธ, ์ˆ˜์ •, ์ƒ์„ฑ, ์‚ญ์ œ
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
์™ธ๋ถ€ ์„œ๋น„์Šค์— ์—ฐ๊ฒฐ
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
๋Œ“๊ธ€ ์—†์Œ