A mental block! I want to copy the Records Window data to a Excel spreadsheet. I've done this once but can't remember exactly how - I think I made use of the Query facility.
I'd appreciate a blow by blow account of how to achieve this.
Sorry to be such an old buffer! Peter
ID:1379
* Copying Records Window to an Excel spreadsheet
-
oldbirkonian
- Silver
- Posts: 7
- Joined: 04 Jan 2006 19:53
- Family Historian: V7
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Copying Records Window to an Excel spreadsheet
For the default records window layout, download and install the records window query from the Downloads section.
Run the Query. Then either click top left to select all and use copy and paste to move to excel, or save the query results as a CSV file and open that in Excel.
Run the Query. Then either click top left to select all and use copy and paste to move to excel, or save the query results as a CSV file and open that in Excel.
Copying Records Window to an Excel spreadsheet
Can you put it clearly how to download records window, I cannot see records window in the query list.[confused]
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Copying Records Window to an Excel spreadsheet
The query is in the Downloads/Query section of this site
http://www.fhug.org.uk/cgi-bin/index.cg ... ries&id=44
you need to download it and save it to your computer and then double click it to get it installed to FH, make sure you have 2.2 or above for the 'automatic' install of queries to work.
http://www.fhug.org.uk/cgi-bin/index.cg ... ries&id=44
you need to download it and save it to your computer and then double click it to get it installed to FH, make sure you have 2.2 or above for the 'automatic' install of queries to work.