Search for content in message boards

Exporting a custom report to Excel

Exporting a custom report to Excel

Posted: 1300313084000
Classification: Query
This post was deleted by the author on 21 Apr 2011 2:07AM GMT

Re: Exporting a custom report to Excel

Posted: 1300313582000
Classification: Query

Rich,

What version of Family Tree Maker are you using? Version 2008 and newer have a Share, Export to a .CSV file. EXCEL will open that .CSV file.

Russ

Re: Exporting a custom report to Excel

Posted: 1300314287000
Classification: Query
FTM Version 16.0.350

Open the custom report then in File --> Export Report --> you have several options including export to a csv file.

Re: Exporting a custom report to Excel

Posted: 1300315543000
Classification: Query
Edited: 1300315599000
1) Make your Custom Report the way you want it with the individuals you want.

2) Click on the Share button at the upper right of the Publish > Custom Report Screen.

3) Select CSV.

4) Select to put data into coloumns (not rows). Usually the default choice.

5) Open the file in Excel.

6) Immediately go to File > Save as and save it in excel format.

7) Review your columns. In some cases, you will want to parse text within a column to separate columns. In some case (like places) that may be rather messy and require some clean-up.

Good luck!!


Re: Exporting a custom report to Excel

Posted: 1300321863000
Classification: Query
This post was deleted by the author on 21 Apr 2011 2:08AM GMT

Re: Exporting a custom report to Excel

Posted: 1300325188000
Classification: Query
Rich,

Do you really mean version 9 or FTM2009?
Version 9 is *very* old.

Re: Exporting a custom report to Excel

Posted: 1300328999000
Classification: Query
This post was deleted by the author on 21 Apr 2011 2:08AM GMT

Re: Exporting a custom report to Excel

Posted: 1300631636000
Classification: Query
Rich,

For Version 9, File, Export. There should be an option. It's been a while since I used Version 9.

If it's not there, please check the Help Menu. If that doesn't work, please let is know.

Russ

Re: Exporting a custom report to Excel

Posted: 1302716805000
Classification: Query
I am using FTM 2008 and am trying to review my file prior to upgrading FTM. I would like to export as a CSV to use in Exel 2007 but cannot figure out how to import the data in columns rather than rows. I would also like to place the next individual in a second row rather than more columns. (I would like to have each individual in a row with all data in columns.) Please help.

Re: Exporting a custom report to Excel

Posted: 1303291433000
Classification: Query
rfaulk,

What are you trying to put in the .CSV file? Are you using a Custom Report?

Upgrading from 2008 to any of the newer versions will not hae any impact on your file.

Russ
per page

Find a board about a specific topic