ProZ.com global directory of translation services
 The translation workplace
Ideas

 
User
Thread poster: Alexandre Chetrite
How to compare 2 Excel files for changes

Alexandre Chetrite
France
Local time: 15:24
English to French
Feb 14, 2011

Hello,

I have hust received my translation modified by an editor (Excel format) and I wish to see the differences between my original translation, and the editor changes.

How can I do this in Excel?

I thought the editor would highlight the lines where changes have been made but he didn't and I do not wish to scan the 1410 Excel cells manually for changes.

All I need is for the edited cells to be highlighted, along with my original translation next to it.

Good day.


Direct link Reply with quote
 

Daniel Grau  Identity Verified
Argentina
English to Spanish
This is what I'd do Feb 14, 2011

Export each Excel sheet (in the old and new file) to a Word file. To do this, select the cells with data, copy to them to the clipboard and paste each sheet in a Word document. Don't select the whole sheet, as you will end up with a very large table. You should repeat this for each sheet in each Excel file (check the row of tabs at the bottom).

Once you've done this (you'll have OLD.doc and NEW.doc), in Word choose Tools > Track Changes > Compare Documents (pay attention to which should be the new and the old file). The result will be your visual guide.

If the original tables are complex, I would advise not to reverse the process to get your Word edits back into Excel, as they won't paste correctly. Instead, enter any changes directly in Excel.

Regards,

Daniel


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 16:24
Member (2006)
English to Turkish
+ ...
Notepad++ Feb 14, 2011

You can select all text, copy and paste into a new file in Notepad++ for each file (old and new versions) and then easily see the changes using the Compare function. All differences are highlighted.

Selcuk


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 15:24
English to Hungarian
in Excel Feb 14, 2011

If you can copy the two different versions into column A and B (aligned), resp., write in cell C1:

=IF(A1=B1,"","!")

OK, then click twice on the „filling plus” when it appears over the lower right corner of C1.

As a result, you will get „!” in lines where the two versions are different.


[Módosítva: 2011-02-14 13:57 GMT]


Direct link Reply with quote
 

Paula Hernández
United Kingdom
Local time: 14:24
English to Spanish
+ ...
Or... Feb 14, 2011

Use Excel compare:
http://www.formulasoft.com/xlsc.html


Direct link Reply with quote
 

Rose Newell  Identity Verified
Germany
Local time: 15:24
German to English
+ ...
Perhaps a better method.... Nov 17, 2012

In my case, I had full worksheets that had been corrected that needed to be shown with track changes to my client, so adding in additional columns etc. would have been too messy and complicated.

So, instead, I developed this method. Maybe it will help others in the future.

The Translator's Teacup Tech Tip: Compare two Excel documents without an add-on


Direct link Reply with quote
 
jambo and jambo
United Kingdom
Dedicated tool Aug 1, 2013

I use dedicated tool to compare excel files.

Excel Diff
http://www.suntrap-systems.com/ExcelDiff/


Direct link Reply with quote
 
amit1870
India
Compare Excel online Aug 11

I have found http://cloudyexcel.com/ tool to compare excel sheets online .

[Edited at 2014-08-11 15:49 GMT]


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

How to compare 2 Excel files for changes






SDL Trados Studio 2014 Starter Edition
Translation software for only €99 per year

The Starter Edition is an affordable but scaled down version of the industry’s leading translation software, SDL Trados Studio 2014 Freelance. It enables translators to join the largest supply chain at a reduced price.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »