Compare contents of two spreadsheets

Discuss the spreadsheet application

Compare contents of two spreadsheets

Postby prsmith » Fri Sep 18, 2009 8:41 pm

Hello,

Using 3.1.1

I have a large spreadsheet (about 650 records or rows by 50 cols or data elements) in which I maintain alumni information for my provincial branch in .xls format.

I get regular branch updates in .xls format from a national source - these updates are in the form of a total dump of branch info.

My spreadsheet includes the contents of the national spreadsheet plus many data fields unique to my province

I must determine what records have been added, deleted or changed in the last month and change my database accordingly

I presently do this process manually and it takes forever and is prone to errors as my eyes and brain get tired

Is there a software means of doing this? I do not have access to a recent version of Excel altho I do have Excel 97 - many comparison programs need Excel 2000 or later

Thanks,
Preston
OOo 3.1.X on MS Windows Vista
prsmith
 
Posts: 8
Joined: Fri May 29, 2009 9:29 pm

Re: Compare contents of two spreadsheets

Postby Robert Tucker » Fri Sep 18, 2009 10:46 pm

Edit>Compare Documents...

Or does the Excel solution here:

http://en.allexperts.com/q/Excel-1059/e ... sheets.htm

work for you with Calc?
LibreOffice 6.x.x on Fedora 28 and Ubuntu 18.04 (Dual Boot)
User avatar
Robert Tucker
Volunteer
 
Posts: 1246
Joined: Mon Oct 08, 2007 1:34 am
Location: Manchester UK

Re: Compare contents of two spreadsheets

Postby thatguy » Sun Aug 12, 2018 9:02 pm

Robert Tucker wrote:Edit>Compare Documents...

Or does the Excel solution here:

http://en.allexperts.com/q/Excel-1059/e ... sheets.htm

work for you with Calc?


Robert,

I know this is an old thread, but it seems to still be applicable.

allexperts.com appears to have gone away, probably in 2017 or 2018, but the page you linked to is still available on Wayback (archive.org).

The archive.com link is:
excel-compare-sheets.htm
OpenOffice 4.1.1 on Windows 7 Home Premium x64
thatguy
 
Posts: 2
Joined: Mon Nov 30, 2015 5:46 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 28 guests