Export GaNCH search results as a CSV file
Data for the GaNCH project is stored in Wikidata. Use the following steps to perform a GaNCH search directly in Wikidata and export the results as a CSV (Comma Seperated Value) table file.
From the GaNCH homepage, choose the dataset search that you want to download. For our example, we'll use GEMA Region 1.
![](/assets/export_instructions/GaNCH_export_instructions_01-fbc14a2e03d5fcc54fef7cb9c90d408627ecd852d710a6578ee328d952d7ec48.jpg)
Next, click on the link See this search in Wikidata. This will open up the search in a new browser tab at the Wikidata Query Service website.
![](/assets/export_instructions/GaNCH_export_instructions_02-ce265e708ada3fcd78a64a91e7be53f5f28baf6780510936f5661ac9652a8b77.jpg)
Then, click on the blue play button in the lower-left to run the SPARQL query search in Wikidata. Wait a few moments and the table of data will appear below.
![](/assets/export_instructions/GaNCH_export_instructions_03-a2861f6e95da907b6378aead93d9be53851f8b3f1c120d533e200a963092c27d.jpg)
Last, click the Download drop-down menu and select CSV File. This will save your file as query.csv.
![](/assets/export_instructions/GaNCH_export_instructions_04-f452fb51e0fea2f9a587aca8f36137d86b530eefa8f9213dd531a0e75de1cdaf.jpg)
You can now import the CSV file into the spreadsheet software of your choice (i.e. LibreOffice Calc, Microsoft Excel, or Google Sheet).