* List of surnames and places

[VieskaGen]

I have not found way to get a list of surnames linked to places as a spreadsheet. Can someone help me?

[tatewise]

A good starting point is to open the Records Window > Places tab that you used before to delete Place names.
Select all the Place records by selecting first record, hold down Shft key, and select last record.

Then run the Where Used Records List Plugin to create a Result Set of all the Place names versus all the Individuals and Families, together with details of exactly which Facts use each Place name.

Use the Save Query to File toolbar icon top right to save as a CSV file.
Beware that the default CSV (not the ANSI one) uses UTF-8 encoding that is not easily opened by MS Excel.
The workarounds are:

• Save using the CSV ANSI encoding but some accented characters may become altered.
• Use another spreadsheet program such as Open Office Calc or Libre Office.
• Use one of the techniques found by Google search to make Excel accept UTF-8.

However, why do you need such a CSV list in a spreadsheet?
What problem are you trying to solve?
FH may have its own solution to your problem using Queries or Plugins.

[VieskaGen]

I need list of my ancestor surname and have not found the way how to get it done.

[PeterR]

There is a Standard Query "Ancestors" which you could customize by adding a column for Surname; you could also remove any columns you don't want. One or more columns in the Result Set can be copied and then pasted into a spreadsheet if required.

[wolfswald]

Maybe like this, a Fact Query.
I find it a bit clumsy to have all the same place/name combinations many times, but one can then export that table and reduce it - I had some way of doing it via OpenOffice.

fh1.png (153.15 KiB) Viewed 4202 times

fh2.png (66.83 KiB) Viewed 4202 times

fh3.png (60.57 KiB) Viewed 4202 times