Question Excel, CSV switch to webtrees?

May I ask, I have an excel , CSV genealogy file. Now I want to import to webtrees, what to do?

Export to GEDCOM with the provided Excel macro.
Never used that, but it should be possible.

Not sure if this is of any help but I’ve used the free software GRAMPS to import a csv genealogy file into the software and then export it to a GEDCOM 5.5.1 file to be imported into webtrees. The csv file has to have a specific format to be imported to GRAMPS, see: gramps-project.org/wiki/index.php/Gramps..._with_multiple_areas .

Download the software GRAMPS but install error

Maybe it is easier to use GedTool: gedtool.de/index.php/en/
GedTool converts csv to GEDCOM and vice versa.

nguoiveday wrote:

Download the software GRAMPS but install error

Try the portable version: portableapps.com/apps/education/gramps_portable

TheDutchJewel wrote:

nguoiveday wrote:

Download the software GRAMPS but install error

Try the portable version: portableapps.com/apps/education/gramps_portable

Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.

TheDutchJewel wrote:

Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.

I can install the software, but I can't convert the CSV file into it

>????

I was under the impression you had an Excel file edited with gedtool, but apparently that is not the case. webtrees only imports proper GEDCOM files. So lets start from the beginning.

Where did you get the file from? Can you share the first few lines?
csv is plain text, use notepad.exe to open it.

nguoiveday wrote:

TheDutchJewel wrote:

Extract 'GrampsPortable_5.1.5.paf.exe' with 7-zip (or another archive manager) to a new folder (you can remove the $PLUGINSDIR folder) and run GrampsPortable.exe from there.

I can install the software, but I can't convert the CSV file into it

If you want to use Gramps for csv import you need to make sure that your csv file is set up like Gramps expects the file to be configured, using the field names that Gramps recognises, see example below (file viewed in a text editor, like Notepad):
More detailed information can be found at this path, including proper field names, CSV import

If your csv file isn’t configured as Gramps expects it to be for proper import then it will fail. Field names need to be in accordance with Gramps csv field names so you may need to make changes to you csv file for this to work. Always make a copy of your original csv file and only make changes to the copy file to test this. This may require several trials on your part before it works so you fully understand how this Gramps import process functions. It took me awhile to get it to work as I wanted. A simple csv test file is included in the above guidance from Gramps to better test this import function.

Maybe the GEDtool is better to handle csv import, as suggested by Hermann, I haven’t tried it though.

hermann wrote:

Maybe it is easier to use GedTool: gedtool.de/index.php/en/
GedTool converts csv to GEDCOM and vice versa.

GedTool: Thanks for the instructions on how to use it

Order the Shareware version of GedTool (for free), read the manual (in particular chapter 5) and have a look to the example files. Questions about GedTool can be placed in the GedTool-Forum or direct to the author. See gedtool.de