Compare text online and get the difference

xlCompare Logo
CHOOSE FILE TYPE
XLSX\XLSM
CSV
TEXT
XML
LANGUAGE
ENG
日本語
한국인
中国語
DEU
ESP
РУС
УКР
Maximize width of the worksheet panels to the size of the browser windowMAXIMIZE
REPORT
Copy to Clipboard
Copy list of differences into clipboard
Copy To ClipboardCopy
Save
Save list of differences on disk as HTML file
Save On DiskSave ...
Close Report
Close comparison report and back to the original data
Exit From ReportClose Report
FILE 1
Import to Table
Select delimiter and import text into spreadsheet
Import Table From TextImport 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.
Remove Duplicate RowsDedup
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.
Remove Empty CellsDel Empty
Sort rows by primary key columns or by selected columns.Sort CellsSort
Trim strings in selected cells.Trim CellsTrim
Copy entire table to clipboard.
Use this command to export data into Excel,Numbers,etc.
Copy Cells To ClipboardCopy
KEY
A
KEY
B
HDR
1
HDR
2
FILE 2
Import to Table
Select delimiter and import text into spreadsheet
Import Table From TextImport 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.
Remove Duplicate RowsDedup
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.
Remove Empty CellsDel Empty
Sort rows by primary key columns or by selected columns.Sort CellsSort
Trim strings in selected cells.Trim CellsTrim
Copy entire table to clipboard.
Use this command to export data into Excel,Numbers,etc.
Copy Cells To ClipboardCopy
KEY
A
KEY
B
HDR
1
HDR
2
Select Delimiter for Text Values
Ok
Cancel
Close ReportClose Report
Save Report on DiskSave Report
Compare TablesCompare Tables
Compare Columns (VLOOKUP)VLOOKUP
Merge TablesMerge Tables
Common RowsCommon Rows
Compare Text FilesCompare Text
Please, help us to improve xlCompare.com
Rate quality of our service
Rating Star
Rating Star
Rating Star
Rating Star
Rating Star
Last ratings and reviews from our users
Rating StarRating StarRating StarRating Star
2024-07-26
 
Rating StarRating StarRating StarRating StarRating Star
2024-07-25
 
Rating StarRating StarRating StarRating StarRating Star
2024-07-23
 
Rating StarRating StarRating StarRating StarRating Star
2024-07-09
 

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):
Select text for comparison

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.
Find difference between two text files

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.
New lines in FILE 1
In FILE 2 every new line has a red background.
New lines in FILE 2
If row contains only few changed characters – they are highlighted with an orange color.
Changed lines
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.
Save Report button
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.

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:
Text data

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:
Import Table Window
After import is completed, you get 2 tables on your screen. In our example result has the following look:
Tables imported from text files

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.
Comparison Report for two 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.

I have a question about xlCompare

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