> ## Documentation Index
> Fetch the complete documentation index at: https://help.draftable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Comparing Excel files in Draftable Legal

> In direct response to user feedback, the Draftable team has built dedicated comparison algorithms to compare Excel files and produce an Excel file with changes shown as Redlined markup. Additionally, Draftable offers Excel comparison via our side-by-side comparison type.

Draftable Legal supports Excel file comparisons via two other approaches:

1. Redline in Excel (In Draftable and in Excel)
2. Side by Side comparison

This article shows you how to run both of these comparisons, export these comparisons and change Excel Redline comparison settings.

<Card title="Video Resource" icon="video" horizontal href="/hc/en-us/articles/33899677536793-Draftable-Legal-Comparing-Excel-PowerPoint-files">
  This topic is included in our specially crafted explainer video.
</Card>

## Comparing Excel files in the Redline Comparison Type in Draftable

<Steps>
  <Step>
    Open the [Draftable Legal New Comparison window](/hc/en-us/articles/19002140760217-Launching-a-Comparison-in-Draftable-Legal-A-Step-by-Step-Guide)

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-1.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=30d5bf22d83ef7d6590a724acd28f456" alt="Launcher.png" width="615" height="395" data-path="images/using-draftable-comparing-excel-files/image-1.png" />
    </Frame>
  </Step>

  <Step>
    Select the two documents you want to compare, either by browsing your files or dragging and dropping them into the compare window.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-2.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=427e1ba2dcf852d58b30a1ec274a7770" alt="" width="647" height="453" data-path="images/using-draftable-comparing-excel-files/image-2.png" />
    </Frame>
  </Step>

  <Step>
    Once the documents are selected, tick the box for **Redline in Draftable** in the comparison type row.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-3.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=b1428a51ef70122fcdb68be8ad4fd03a" alt="" width="1280" height="876" data-path="images/using-draftable-comparing-excel-files/image-3.png" />
    </Frame>
  </Step>

  <Step>
    Click the **Compare** button to run the comparison. When the comparison is complete, it will load the Redline comparison viewer. See below for an example:

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-4.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=8f259f0133fa94035405cb886c99920d" alt="" width="1980" height="1203" data-path="images/using-draftable-comparing-excel-files/image-4.png" />
    </Frame>
  </Step>
</Steps>

### Reviewing your comparison in Draftable

<Steps>
  <Step>
    The **Redline Comparison Viewer** shows all changes in a dynamic **Change List** on the right-hand side of the screen.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-5.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=0ff8975ee4c012d578043939d95e3285" alt="" width="1062" height="651" data-path="images/using-draftable-comparing-excel-files/image-5.png" />
    </Frame>
  </Step>

  <Step>
    You can scroll through the Change List and **click on any change** **to jump to its location** and have the change **highlighted with a blue box** on both versions shown.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-6.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=6a165bceb89084aa3ae20f069da1411c" alt="" width="1056" height="619" data-path="images/using-draftable-comparing-excel-files/image-6.png" />
    </Frame>
  </Step>

  <Step>
    Users can tag changes by selecting the **Tag Icon** on the top right corner of the individual change card in the change list. This will display a list of **5 tagging options** to choose from. Multi-tagging of changes is also possible.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-7.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=6e7bce7548f7feace88b9b20c5e0d5e6" alt="" width="1167" height="689" data-path="images/using-draftable-comparing-excel-files/image-7.png" />
    </Frame>
  </Step>

  <Step>
    Users can also leave **Notes** on changes by **selecting the Change Card,** writing a note at the bottom of the card and hitting **Enter** to save the Note\*\*.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-8.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=7f76bd6aeb7bb2f92c48b775ad298a69" alt="" width="1183" height="699" data-path="images/using-draftable-comparing-excel-files/image-8.png" />
    </Frame>
  </Step>

  <Step>
    Users can filter changes by using the **Interactive Filter Menu**, available at the top of the change list. This can be opened by selecting the **Details drop-down menu** in the top right corner of the Change List.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-9.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=c5393fcc82cc242d25208ce60a1a4fea" alt="" width="1176" height="696" data-path="images/using-draftable-comparing-excel-files/image-9.png" />
    </Frame>
  </Step>

  <Step>
    Users can **see filtering options** by selecting either the **Only Show** or **Do Not Show** entry forms. This will display a list of filtering options including **Change Type, Style Changes, Tags and Notes**.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-10.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=f1a6ea1729e197e29d7f2e2850f6a0b0" alt="" width="1177" height="708" data-path="images/using-draftable-comparing-excel-files/image-10.png" />
    </Frame>
  </Step>

  <Step>
    Once all review of changes is completed, users can share the comparison along with any Tags and Notes with colleagues or external parties via the **many different output options** shown in the ribbon menu.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-11.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=e2331827ef5be1ac704e3280f9f4d313" alt="" width="1153" height="696" data-path="images/using-draftable-comparing-excel-files/image-11.png" />
    </Frame>
  </Step>

  <Step>
    To share specific changes in notes and tags made in the comparison, ensure you click on the Changes Report option, in the many different output options.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-12.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=6e210ad05951999b1a0068ab9a03a9ec" alt="" width="404" height="597" data-path="images/using-draftable-comparing-excel-files/image-12.png" />
    </Frame>
  </Step>

  <Step>
    A drop-down list will provide options to export changes as a **DOCX** or **exporting to a** **.csv** using either the **All changes** or the **Matching filters**.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-13.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=1b4f0f8d859b08fe0e052ebdf2e09051" alt="" width="352" height="138" data-path="images/using-draftable-comparing-excel-files/image-13.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-14.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=caabf711c8cc5999872395bcacaf6ba8" alt="" width="350" height="161" data-path="images/using-draftable-comparing-excel-files/image-14.png" />
    </Frame>
  </Step>
</Steps>

## Comparing Excel files in the Redline Comparison Type in Excel

<Steps>
  <Step>
    Open the [Draftable Legal New Comparison window](/hc/en-us/articles/19002140760217-Launching-a-Comparison-in-Draftable-Legal-A-Step-by-Step-Guide)

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-15.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=023d95dd759be3d721add7a3a3e68d60" alt="Launcher.png" width="615" height="395" data-path="images/using-draftable-comparing-excel-files/image-15.png" />
    </Frame>
  </Step>

  <Step>
    Select the two documents you want to compare, either by browsing your files or dragging and dropping them into the compare window.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-16.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=6430ace5947cabf2159264475779d45f" alt="" width="647" height="453" data-path="images/using-draftable-comparing-excel-files/image-16.png" />
    </Frame>
  </Step>

  <Step>
    Once the documents are selected, tick the box for **Redline in Excel** in the comparison type row.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-17.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=b0734b95c3df8c460b4761800cbc5754" alt="" width="742" height="525" data-path="images/using-draftable-comparing-excel-files/image-17.png" />
    </Frame>
  </Step>

  <Step>
    You will be prompted to either **save** or **open** the Redlined Excel comparison. For this example, lets open the Redline Excel comparison.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-18.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=c71c6419dbf3dc2c53e3080eda4294c8" alt="" width="693" height="240" data-path="images/using-draftable-comparing-excel-files/image-18.png" />
    </Frame>
  </Step>
</Steps>

### Reviewing your comparison in Excel

<Steps>
  <Step>
    Your Redlined Excel document will open within Excel itself

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-19.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=fd8d2c0509a56242d7d92226ff758a6c" alt="" width="1375" height="949" data-path="images/using-draftable-comparing-excel-files/image-19.png" />
    </Frame>
  </Step>

  <Step>
    All changes are shown as Redline, where deletions and insertions are shown per cell, and formula changes are shown as comments with the cell highlighted

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-20.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=425aad146567c611d6962df748da0e8e" alt="" width="394" height="488" data-path="images/using-draftable-comparing-excel-files/image-20.png" />
    </Frame>
  </Step>

  <Step>
    If you wish to change the way the Redline comparisons are run for you, please see the section below regarding "How to configure settings for Excel Redline compare"
  </Step>
</Steps>

## Comparing Excel files in the Side by Side Comparison Type

<Steps>
  <Step>
    Open the [Draftable Legal New Comparison window](/hc/en-us/articles/19002140760217-Launching-a-Comparison-in-Draftable-Legal-A-Step-by-Step-Guide)

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-21.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=8a4e60c531d9e55ace3411145572aafe" alt="Launcher.png" width="615" height="395" data-path="images/using-draftable-comparing-excel-files/image-21.png" />
    </Frame>
  </Step>

  <Step>
    Select the two documents you want to compare, either by browsing your files or dragging and dropping them into the compare window.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-22.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=780172a45805dee63ab1f81db241c6a5" alt="" width="647" height="453" data-path="images/using-draftable-comparing-excel-files/image-22.png" />
    </Frame>
  </Step>

  <Step>
    Once the documents are selected, tick the box for **Redline in Excel** in the comparison type row.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-23.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=e0d0f37bde1db90359b287d26591b0fc" alt="" width="667" height="442" data-path="images/using-draftable-comparing-excel-files/image-23.png" />
    </Frame>
  </Step>

  <Step>
    Click the **Compare** button to run the comparison. When the comparison is complete, it will provide a side-by-side comparison, which will open within the Draftable comparison viewer.

    <Frame>
      <img src="https://mintcdn.com/draftable/2IMrETQ06NwfLteK/images/using-draftable-comparing-excel-files/image-24.png?fit=max&auto=format&n=2IMrETQ06NwfLteK&q=85&s=a75c923e5c3d70ba6ceb7cfccf619731" alt="" width="2154" height="1201" data-path="images/using-draftable-comparing-excel-files/image-24.png" />
    </Frame>
  </Step>
</Steps>

### Reviewing your comparison in Draftable

<Steps>
  <Step>
    The **Comparison Viewer** shows all changes in a dynamic **Change List** on the right-hand side of the screen.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-25.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=149d7c4a5bd307b07c586d506e87bd94" alt="" width="1449" height="800" data-path="images/using-draftable-comparing-excel-files/image-25.png" />
    </Frame>
  </Step>

  <Step>
    You can scroll through the Change List and **click on any change** **to jump to its location** and have the change **highlighted with a blue box** on both versions shown.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-26.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=e1434032a2e9f9674e562d01ccce3342" alt="" width="1444" height="796" data-path="images/using-draftable-comparing-excel-files/image-26.png" />
    </Frame>
  </Step>

  <Step>
    Users can tag changes by selecting the **Tag Icon** on the top right corner of the individual change card in the change list. This will display a list of **5 tagging options** to choose from. Multi-tagging of changes is also possible.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-27.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=1356a147d473e74cd2337c2df189edab" alt="" width="1454" height="791" data-path="images/using-draftable-comparing-excel-files/image-27.png" />
    </Frame>
  </Step>

  <Step>
    Users can also leave **Notes** on changes by **selecting the Change Card,** writing a note at the bottom of the card and hitting **Enter** to save the Note\*\*.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-28.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=3af74f7e1b7fcb0cf5157b13a0418b39" alt="" width="1472" height="797" data-path="images/using-draftable-comparing-excel-files/image-28.png" />
    </Frame>
  </Step>

  <Step>
    Users can filter changes by using the **Interactive Filter Menu**, available at the top of the change list. This can be opened by selecting the **Details drop-down menu** in the top right corner of the Change List.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-29.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=ada63b3087d7ba3cb428baf80a7f69b5" alt="" width="1454" height="792" data-path="images/using-draftable-comparing-excel-files/image-29.png" />
    </Frame>
  </Step>

  <Step>
    Users can **see filtering options** by selecting either the **Only Show** or **Do Not Show** entry forms. This will display a list of filtering options including **Change Type, Style Changes, Tags and Notes**.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-30.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=b74e9cb06a28360c505b2eda6d805815" alt="" width="1435" height="790" data-path="images/using-draftable-comparing-excel-files/image-30.png" />
    </Frame>
  </Step>

  <Step>
    Once all review of changes is completed, users can share the comparison along with any Tags and Notes with colleagues or external parties via the **many different output options** shown in the ribbon menu.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-31.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=7d4115d4e9e85e5dbf1a2c43d37619d1" alt="" width="1447" height="795" data-path="images/using-draftable-comparing-excel-files/image-31.png" />
    </Frame>
  </Step>

  <Step>
    To share specifically changes in notes and tags made in the comparison, ensure you click on the Changes Report option, in the many different output options.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-32.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=c6f5dcd9c35b569d0bfed085bf6944d1" alt="" width="404" height="597" data-path="images/using-draftable-comparing-excel-files/image-32.png" />
    </Frame>
  </Step>

  <Step>
    A drop-down list will provide options to export changes as a **DOCX** or **exporting to a** **.csv** using either the **All changes** or the **Matching filters**.

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-33.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=5a33df0c25afd539e971ffe5d2a14439" alt="" width="352" height="138" data-path="images/using-draftable-comparing-excel-files/image-33.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-34.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=7d918b2faf33fd74a20e8ed27685b1dd" alt="" width="350" height="161" data-path="images/using-draftable-comparing-excel-files/image-34.png" />
    </Frame>
  </Step>
</Steps>

## How to configure settings for Excel Redline compare

Settings for the Excel Redline comparisons can be found within the Redline tab of the settings menu. There are many options specific to Redline comparisons.

<Frame>
  <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-35.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=8a6abf27b2454a7e253209a156396ebd" alt="" width="769" height="466" data-path="images/using-draftable-comparing-excel-files/image-35.png" />
</Frame>

Below is an explainer of each of these options:

**Compare type:** Specifies what type of content is detected within the Excel Redline comparison, these options are Values, Formulas or both.\*\*

<Frame>
  <img src="https://mintcdn.com/draftable/q7ELnB8ptoc2c73b/images/using-draftable-comparing-excel-files/image-36.png?fit=max&auto=format&n=q7ELnB8ptoc2c73b&q=85&s=e139c4f93bab6397c6dad2a0223df23e" alt="" width="296" height="87" data-path="images/using-draftable-comparing-excel-files/image-36.png" />
</Frame>

**Detect Row Edits:** Enables detection of changes found in row edits.

**Detect Column Edits:** Enables detection of changes found in column edits.

**Show unchanged content in greyscale:** Marks unchanged content in greyscale for easier readability.

**Show formula change notes:** Turns on change notes for formula changes found within cells.

**Limit the number of changes per sheet:** Set a limit on the number of changes found within a given sheet. This setting can be toggled on or off, and if turned on, a number of changes can be specified.
