https://www.proz.com/forum/translation_theory_and_practice/33756-comparing_excel_files.html
This site uses cookies. Some of these cookies are essential to the operation of the site, while others help to improve your experience by providing insights into how the site is being used. For more information, please see the ProZ.com privacy policy.
Cookie settings

Translation - art & business » Translation Theory and Practice »
Comparing Excel files
Thread poster: Michael Deliso
Michael Deliso
Michael Deliso  Identity Verified
Local time: 10:35
Italian to English
+ ...
Jun 24, 2005

Can someone explain to me how to compare two excel files side by side so to view and compare errors and/or differences? just like it can be done with Word..
 
Prisma
Prisma
English to Swedish
+ ...
2 windows in Excel Jun 24, 2005

Michael,

1. Open the two files you would like to compare in Excel.
2. From the "Window" menu in Excel, choose "Arrange..." then "vertical".

Your files will now appear side by side.

Good Luck!
 
Can Altinbay
Can Altinbay  Identity Verified
Local time: 04:35
Japanese to English
+ ...
In memoriam
A rather indirect approach Jun 24, 2005

There's a "merge" facility in Excel, but the files have to be versions of the same file (see their Help pages for better details). I'm sure someone will come up with something more brilliant that this, but just a couple of days ago, I saved them as CSV files and put them through a diff utility. I like WinMerge, which is free from http://winmerge.sourceforge.net/. If you Google appropriately, you migh... See more
There's a "merge" facility in Excel, but the files have to be versions of the same file (see their Help pages for better details). I'm sure someone will come up with something more brilliant that this, but just a couple of days ago, I saved them as CSV files and put them through a diff utility. I like WinMerge, which is free from http://winmerge.sourceforge.net/. If you Google appropriately, you might find something that does Excel files directly, there used to be a Word comparison tool, but it cost money, and Word's merger worked well enough for me. ▲ Collapse
 
Michael Deliso
Michael Deliso  Identity Verified
Local time: 10:35
Italian to English
+ ...
TOPIC STARTER
Comparing Excel files Jun 25, 2005

Thanks for the help..I'll try either one of them..
 


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

Moderator(s) of this forum
Maria Castro[Call to this topic]
Nawal Kramer[Call to this topic]

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

Comparing Excel files


Translation news
» New project on feminist translation
(0 comments)
» Language Models Can Predict the Most Suitable Translation Techniques, Study Finds
(0 comments)
» Why Large Language Models are the future of manufacturing
(0 comments)


Forum rules
Help and orientation




Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »