# Importing multiple citations **URL:** \ **Category:** Help\ **Created:** [July 17, 2022, 12:23pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610 "2022-07-17T12:23:23Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![vinnydabody](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/vinnydabody/32/1965_2.png) [@vinnydabody](https://gramps.discourse.group/u/vinnydabody)\ **Post date:** [July 17, 2022, 12:23pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/1 "2022-07-17T12:23:23Z")
Hi all. I’ve been working the past few years to index the available civil records (B/M/D) for one of my ancestral Italian towns. I’m at the point now (having done about 30 years of records from 1809-1840) where I also want to use that information to start a one place study, adding families and connections in Gramps (5.1.5, Win 10) and then exporting a GEDCOM to share and/or publish online in WikiTree. I have all the indexed data in a Google sheet (about 16,000 records so far), enough with each record to create basic profiles for every person. I’ve figured out how to manipulate the data in my Google sheets to import the people and create the relationships and events into Gramps through CSV. The rough part is the sources/citations. I’m only using one source (Comune of Modugno Civil Acts). Gramps creates citations from the import for each event, but they are just dummy placeholders. There’s no way that I can see to import the full citation info (year, record type, act number, url to page). Instead I need to go into one of the dummy citations and add all that info, then merge the citations with other citations that were created for the various events related to the family record. It gets quite tedious since just the first year of births (less than 300 records) resulted in about 550 citations (about 300 births and about 250 estimated birth years for parents) that now have to be edited and merged to whittle down to the 291 actual citations for the year. Is there an easier way I wonder? Or maybe Gramps isn’t the tool for this job? ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [July 17, 2022, 12:41pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/2 "2022-07-17T12:41:53Z")
You’ll want to importing the citations concurrently to the import of Birth/Marriage/Death Events under each Person. I am assuming that you are connecting the Birth/Death Events to People and Marriage Events to Families during the import. Not stitching them together manually. Likewise, that you are adding People to Families during import. The process of having a Citation reference created during import is very similar. Looking at the wiki, the [CSV Import and Export](https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export) webpage does not give an example of a Citation header. For items that are not explicitly listed in those webpages, you can always create an example. In a dummy Tree of Gramps, create a linked record manually (or filter to a representative record in the [Example.gramps](https://www.gramps-project.org/wiki/index.php/Example.gramps) tree) and export the view(s) to CSV. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [July 17, 2022, 1:07pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/3 "2022-07-17T13:07:42Z")
A good alternative is to manually create a Sample family in a fresh blank Tree. Then export that to CSV as your reference. Add a family with parents & a child, with sourced Events for all. Add samples all Event types that you intend to import… making certain to add a Marriage event that is under the Family, not redundantly attached under each spouse. Include a hierarchical Place with GPS coordinates and citations to at least 2 different sources. (I recommend using the [Place Cleanup add-on Gramplet](https://www.gramps-project.org/wiki/index.php/Addon:PlaceCleanupGramplet) to create the best quality Place hierarchy example. It takes some configuring to access the GeoNames webservice. But it is worth the effort.) Then export the entire 3-person Tree to CSV. ---
**Author:** ![vinnydabody](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/vinnydabody/32/1965_2.png) [@vinnydabody](https://gramps.discourse.group/u/vinnydabody)\ **Post date:** [July 17, 2022, 1:20pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/4 "2022-07-17T13:20:35Z")
> [@emyoulation](#): > > A good alternative is to create a Sample family in a fresh blank Tree manually and then export that to CSV. > > Add a family with parents & a child, with sourced Events for all. Include a hierarchical Place. Then export the entire 3-person Tree to CSV as you reference. Unfortunately, the CSV export does not include citations. It only includes the source name and no other information. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [July 17, 2022, 2:35pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/5 "2022-07-17T14:35:00Z")
Confirmed that that the CSV only supports Source (as strings, not hierarchical records) and not citations. Amended bug report [10346](https://gramps-project.org/bugs/view.php?id=10346) with inquiry about adding faster ID-based citation CSV support to supplement slow string-based Source support. ---
**Author:** ![PLegoux](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/plegoux/32/413_2.png) [@PLegoux](https://gramps.discourse.group/u/PLegoux)\ **Post date:** [July 17, 2022, 3:36pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/6 "2022-07-17T15:36:46Z")
You could try Transged which is a 🇨🇵 software to transform a formatted CSV file into a Gedcom file [https://www.visuged.org/transged.htm](https://www.visuged.org/transged.htm) ---
**Author:** ![vinnydabody](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/vinnydabody/32/1965_2.png) [@vinnydabody](https://gramps.discourse.group/u/vinnydabody)\ **Post date:** [July 17, 2022, 5:20pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/7 "2022-07-17T17:20:44Z")
> [@PLegoux](#): > > You could try Transged which is a 🇨🇵 software to transform a formatted CSV file into a Gedcom file So, similar to Excel2Ged? > **[Excel2GED](https://sourceforge.net/projects/excel2ged/)** > > Download Excel2GED for free. Excel genealogy sprdsht w/ macro for converting data to GEDCOM format. Excel2GED is an Excel spreadsheet with a macro for converting genealogy data into a GEDCOM-formatted text file with a '.ged' file extension. A GEDCOM... ---
**Author:** ![PLegoux](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/plegoux/32/413_2.png) [@PLegoux](https://gramps.discourse.group/u/PLegoux)\ **Post date:** [July 17, 2022, 6:39pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/8 "2022-07-17T18:39:11Z")
Sorry, I don’t know, I never use Excel to enter genealogical data to avoid these kind of issues, I just know these translation programs exists ---
**Author:** ![StoltHD](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@StoltHD](https://gramps.discourse.group/u/StoltHD)\ **Post date:** [July 17, 2022, 8:46pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/9 "2022-07-17T20:46:41Z")
If you use Excel the easiest way is to create a vba to write to json or more advanced xml. Create the different objects you need in Gramps, export to json, examene the json file, create a vba that write a json with the cell data… here is one exemple that might help (not creating a “gramps” json, but a json file): > **[Output Excel data as JSON - Office Scripts](https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/get-table-data)** > > Learn how to output Excel table data as JSON to use in Power Automate. ---
**Author:** ![vinnydabody](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/vinnydabody/32/1965_2.png) [@vinnydabody](https://gramps.discourse.group/u/vinnydabody)\ **Post date:** [July 20, 2022, 10:09pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/10 "2022-07-20T22:09:27Z")
How does one export from Gramps to JSON? Please explain to the non-programmer, as I don’t see JSON as an option in the export wizard. ---
**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\ **Post date:** [July 20, 2022, 10:39pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/11 "2022-07-20T22:39:33Z")
The JSON importer/exporter is an Add-on. Another format is displayed in those options when it [has been installed](https://gramps-project.org/wiki/index.php/5.1_Addons#Installing_Addons_in_Gramps) via the Gramps Plugin Manager and then Gramps is restarted. Because there are no interface options, there is no wiki page for it. And it isn’t in the wiki’s [Add-on List](https://gramps-project.org/wiki/index.php/5.1_Addons#Addon_List) either. If you cannot find it, Matt’s webpage lets you [search the Gramps addons](https://mattkmmr.github.io/gramps-addons-listings/?catg=All) for importers/exporters. The JSON add-on IS listed there. (But you’d have to install an external download manually.) ![Screenshot_20220720-175019](https://global.discourse-cdn.com/free1/uploads/gramps/original/2X/a/ade9946444e73406839a4f39a8fab278b5a14c6a.png) ---
**Author:** ![system](https://global.discourse-cdn.com/free1/uploads/gramps/original/1X/2ac1e712b7adf612e31ca08a55419f4cf37c0158.png) [@system](https://gramps.discourse.group/u/system)\ **Post date:** [August 19, 2022, 10:40pm UTC](https://gramps.discourse.group/t/importing-multiple-citations/2610/12 "2022-08-19T22:40:04Z")
Closed on August 19, 2022, 10:40pm UTC This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.