Compare text online and get the difference

CHOOSE FILE TYPE

XLSX\XLSM

CSV

TEXT

XML

LANGUAGE

ENG

日本語

한국인

中国語

DEU

ESP

РУС

УКР

MAXIMIZE

REPORT

Copy to Clipboard
Copy list of differences into clipboard

Copy

Save
Save list of differences on disk as HTML file

Save ...

Close Report
Close comparison report and back to the original data

Close Report

Cell

Cell

FILE 1

Click to select Text file on your computer

Browse for Excel (XLSX,XLSM) or CSV file on your computer

Open ...

Import to Table
Select delimiter and import text into spreadsheet

Import to Table

Remove duplicate rows in table by key columns or by selected columns.
If there are no key columns and no selected columns - all cells in a row are used to find duplicates.

Dedup

Remove rows with empty cells in key columns or in selected columns.
If there are no key columns and no selected columns - only completely empty rows are removed.

Del Empty

Sort rows by primary key columns or by selected columns.

Sort

Trim strings in selected cells.

Trim

Copy entire table to clipboard.
Use this command to export data into Excel,Numbers,etc.

Copy

Report

Cell

Cell

	KEY A	KEY B
HDR 1
HDR 2

Cell

Sheet

FILE 2

Click to select Text file on your computer

Browse for Excel (XLSX,XLSM) or CSV file on your computer

Open ...

Import to Table
Select delimiter and import text into spreadsheet

Import to Table

Remove duplicate rows in table by key columns or by selected columns.
If there are no key columns and no selected columns - all cells in a row are used to find duplicates.

Dedup

Remove rows with empty cells in key columns or in selected columns.
If there are no key columns and no selected columns - only completely empty rows are removed.

Del Empty

Sort rows by primary key columns or by selected columns.

Sort

Trim strings in selected cells.

Trim

Copy entire table to clipboard.
Use this command to export data into Excel,Numbers,etc.

Copy

Cell

Cell

	KEY A	KEY B
HDR 1
HDR 2

Cell

Sheet

Close Report

Save Report

Compare Tables

VLOOKUP

Merge Tables

Common Rows

Compare Text

Please, help us to improve our application

Rate quality of our service

Last ratings and reviews from our users

rating...

Step-by-step instruction how to compare text online

Paste two texts or open 2 files and compare text online in one click! Get the perfect presentation report, that can be saved on disk or sent by email.

xlCompare is very easy to use. Follow the instructions below to compare text online and get the results.

1. Select your files or paste text

To start you need to select the text file on your computer using the Open button. Also, you can just drop your file into FILE 1 area from Windows Explorer.

If your text is in the Clipboard – paste it into window using FILE 1 area by pressing Ctrl+V or using Paste command from the context (right-click) menu.

Repeat the same action for the right panel FILE 2.

In our example we've pasted the following text (example of the Visual Basic Code):

2. Compare text

When text in areas FILE 1 and FILE 2 is ready to be compared – click the Compare Text button.

This button starts the comparison procedure and presents you with a comparison report on your screen.

3. How the comparison report looks for 2 text files

The result of comparison is a window that contains all the differences highlighted with color. Every new line in FILE 1 is highlighted with a green background color.

In FILE 2 every new line has a red background.

If row contains only few changed characters – they are highlighted with an orange color.

Rows in the report are aligned side-by-side, so the corresponding rows are always placed on the same level.

Opposite to the inserted row (highlighted with red or green color), xlCompare inserts empty rows without number for alignment. It is filled with gray color.

4. How to save the results

If you need to save the report on disk for future use or to send it by email, use the Save Report command. This button became enabled after you get the comparison report on your screen.

Save Report command saved results of the comparison into the Downloads folder in HTML format.

Now you can save this file by email or open it and copy the contents into another document.

5. We value your privacy

Important question that matters all our users – do you load our data on your server? Our answer – NO. All the operations are performed in your browser on your computer. If you have any doubts – disable the Internet connection and you will be able to use our server in your browser.

6. How much it costs?

xlCompare application is FREE. Here you can compare text files and get the report for free. We distribute our application to compare Excel files for a fee. All other services offered on this website are free.

7. Video instruction on how to find differences in text online

Whatch a short 40 seconds videos to see how this service works.

Import and compare tables stored in the text files

xlCompare will help you in case if you task is to compare two tables, saved in the text format. Values in text files are separated one from another with a delimiter character. Typically, this is space character or tabulation.

1. Select files or paste your data

We will start with loading text on this webpage. Use the Open command to open files on your computer. Also, you can use Paste command to insert data in the FILE area.

In our example data looks like this one:

2. Select delimiter for text values

The Import into Table command converts text data into the table. For this purpose, it asks you to select the delimiter character. You need to select one of the following or enter your own in the last field:

After import is completed, you get 2 tables on your screen. In our example result has the following look:

3. Working with tables

When you are working with tables on xlCompare.com you can use all set of commands and operations available for Excel files:

Remove empty rows
Remove duplicate rows
Sort cells in table by column
Trim cells (remove leading and trailing spaces text values)
Remove rows and columns you don't need from your table

If your table doesn't require preprocessing – just skip this step and go forward.

4. Compare two tables

Usually, tables stored with delimiters have headings and key columns. The heading area contains field names of the columns. This is important to get accurate comparison results.

Set the Headings area in your table by clicking the HDR marker in the row heading area.

To select key columns – click the KEY marker in the column heading.

If your table doesn't have Headings or Key Columns – just skip this step.

Now click the Compare Tables button to get the comparison report.

By pressing this button xlCompare presents you a report with differences found in the opened tables.

5. What are the operations I can do with tables?

For the tables xlCompare gives following commands:

Compare values in two columns with VLOOKUP command.
Create a report for the compared files.
Filter added rows.
Filter deleted rows.
Filter completely equal rows.
Filter rows with changed cells.
Filter common rows.

6. How to save the comparison results

To save comparison results on your computer use the command Create Report.

xlCompare creates reports in the form of HTML file, that is saved in the Downloads folder.

You can send it by email as an attachment or copy its contents to clipboard to paste into Word document or e-mail.

Also, xlCompare gives you a Copy to Clipboard command for each table.

This is a flexible and ultimate ability to transfer tables from the web page into any application, like Excel, Word, or Numbers.

7. Video instruction on how to import text with delimiter and compare it online

Compare Text With Delimiter Online - Watch on Youtube

Our benefits – why xlCompare is the best choice to compare text files

xlCompare gives you a free and complete set of tools to compare text files and create reports. Here you quickly find an answer where the difference is between two fragments of text.

This application works in your browser on your computer WITHOUT transmitting your data into the Internet. All the operations you are doing here are confidential.

We will be happy to receive your feedback about our online application.

I have a question about xlCompare

Please, describe your question or inquiry in the form below. We will be happy to respond you!

Name:

E-mail:

Question: