How to open or export a abcddb file in Windows 7 Excel

The file is actually an SQLite 3 datafile.

The closest match would be Access, but it will not open the file as such. You will have to install an ODBC connector, set up a connection and open each table. Not trivial, I am afraid, but doable.

Check http://www.ch-werner.de/sqliteodbc/ for an SQLite ODBC connector. Note: some antivirus show a heuristics alert for the executable, it is probably safe.

Command line: If you have access to the sqlite3 command line tool (comes standard in OS X), you can list the tables (there are 24) with

echo .tables | sqlite3 file.abcddb

and you can export each table to CSV with

sqlite3 -csv -header file.abcddb "SELECT * FROM TABLE;" > TABLE.csv

and open it with Excel or Access.

Of course, you can "play" with SQL SELECTs. A CSV list of Name, Surname, Phone (with a line for each phone number, hence possibly more than a line for each person) can be got with:

sqlite3 -csv -header file.abcddb "SELECT ZABCDRECORD.ZFIRSTNAME AS 'First Name', ZABCDRECORD.ZLASTNAME AS 'Last Name', ZABCDPHONENUMBER.ZFULLNUMBER AS 'Phone' FROM ZABCDRECORD INNER JOIN ZABCDPHONENUMBER ON ZABCDPHONENUMBER.ZOWNER = ZABCDRECORD.Z_PK;" > telephones.csv

ZABCDRECORD is the "main" table with a row for each contact. But data that cn be multiple for each contact (phone numbers as above, email addresses, physical address, URLs...) is in separate tables, each containing a ZOWNER column that "points" to column Z_PK (autonumeric) in ZABCDRECORD (technically, they have it as a foreign key).

Alternative GUI software: you may download DB Browser for SQLite for OS X or Windows (PortableApps package available too for the later). Just open the file then use File->Export->Table(s) as CSV file.