are excel spreadsheets able to connect to RM 10 and What does the output look like? I have taken an excel spreadsheet and made research notes into a word document for each person. Do you think I should convert them to pdf or just attach the spreadsheet?
They will simply open in the default application, not in RM. RM does not output them.
For long term storage within the app, I’d convert them to .pdf.
The Help page is here. It says “pictures, audio clips, video clips, or files”. The last term means any type of computer file. No type other than pictures and the first page of PDFs can be previewed in RM and only pictures are outputted by RM. RM outputs that can include images are the user interface, those reports that support one photo per person or family, and the Scrapbook report that can include multiple images for one person, one family, one source or one place.
Not all image types are supported:
JPEG2000 and HEIC come to mind.
[EDIT#1]: misspoke about PDFs: if added as type File, RM can create a thumbnail of the 1st page in place of the PDF icon which is what you get if added as type Image.
RM does not store the file in its database, just the link to the file and whatever metadata is added by the user to RM’s database fields: type, caption, description, date, ref#. This RM metadata for a file is not connected with metadata embedded in the file.
A user might wish to access an Excel file about a person, family, … from within RM. Tagging the person to the Excel file as a media item would be one way to do it. Another would be a WebTag. The Media>Fix broken media links tool could be an advantage over WebTags which has no such tool.
Almost an aside this. If you save a multi page ‘source’ image in your Ancestry tree (WW1 soldier’s record, divorce petition, address page of UK 1921 census etc) and then sync to your RM tree then only the one page of the record will download to RM. In such cases, if other pages are of interest, you need to manually save each page to your PC from Ancestry and then attach them manually to RM.
