Is there a way to download the data on all people in a family tree from Family Tree Maker (I'm using version 2012 on PC, file format is .ftmb) so that the data can be seen in a spreadsheet (including dob, dom, dod, spouse, etc)?
This would be very useful for checking data, statistical analysis, etc.
If you're willing to export to GEDCOM as Colin suggests, another option would be to use the free Family Tree Builder program from MyHeritage.
Family Tree Builder has a specific report to export all or selected people and all or selected fields to a csv (comma delimited file) that spreadsheet programs will open:
The resulting information will look like this:
Credit: The screenshots are from the July 17, 2018 MyHeritage Webinar: Everything you need to know about Genealogical Charts and Reports by Uri Gonen, MyHeritage Product Manager
There is an online help page titled Save a chart or report as an external file in Family Tree Maker that says under Saving a report as a file that you can use the Share button to:
Export to CSV: This format organizes information into fields (comma-separated values) and is meant to be imported into spreadsheet programs. Only reports that use column formats can be exported to CSV.
As commented by @lkessler:
Different reports give different data. The Person Custom Report will give Birth, Marriage, Death dates and places along with Facts and Notes, but not the spouse's name. The Person List of Individuals report will give the birth, marriage and death dates along with the spouse's name, but not the places. No report gives everything, but each report gives something useful.
Another way to do this is to export as a Gedcom and then use the old but still working programme GedXlate available from GedMagic. This will include spouses and you can configure which columns that you want in your spreadsheet.
