Compare text online and get the difference
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 clipboardCopy
Copy list of differences into clipboardCopy
Save
Save list of differences on disk as HTML fileSave ...
Save list of differences on disk as HTML fileSave ...
Close Report
Close comparison report and back to the original dataClose Report
Close comparison report and back to the original dataClose Report
FILE 1
Import to Table
Select delimiter and import text into spreadsheetImport to Table
Select delimiter and import text into spreadsheetImport 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
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
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
Use this command to export data into Excel,Numbers,etc.Copy
A | B | |
---|---|---|
1 | ||
2 |
FILE 2
Import to Table
Select delimiter and import text into spreadsheetImport to Table
Select delimiter and import text into spreadsheetImport 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
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
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
Use this command to export data into Excel,Numbers,etc.Copy
A | B | |
---|---|---|
1 | ||
2 |
Select Delimiter for Text Values
Ok
Cancel
Close Report
Save Report
Compare Tables
VLOOKUP
Merge Tables
Common Rows
Compare Text
Please, help us to improve xlCompare.com
Rate quality of our service
Last ratings and reviews from our users
2024-07-26
2024-07-25
2024-07-23
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):
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.
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.
I have a question about xlCompare
Please, describe your question or inquiry in the form below. We will be happy to respond you!