Skip to content. | Skip to navigation

Personal tools

You are here: Home / DaRWIN / Help and Manuals / How to export data into Tab-delimited

How to export data into Tab-delimited


Log and connect to the backend interface :



2. Go to “Searches=> specimens”



3. Carry out a search (e.g data  from Cameroon)


4. Run the search…


5. click on “Save this search” (bottom right)


​6. Give a recognizable name to your query and save...


7. Go to “Saved search” in the lower left menu


8. push on Get report next to the search data to export


9. a new tab should open to your browser, looping through the dataset (about 20 seconds for each batch of 10 000 records).
When ready, a green Download button will be displayed. 


10. By clicking on download, you will received your data as a tab-delimited file. Its name is the technical database ID of the query (e.g. report_1382.txt)


11. Data in Notepad++


12. You can use Excel (e.g. Data => From CSV) to convert the data





Notes :

  1. Choose the appropriate Delimiter
  2. Beware, source encoding is Unicode /UTF-8 (not the standard encoding of Excel which is Latin1). Check this option, otherwise you risk to alter data and loose those with diacritic or accented characters (e.g. “België” can become “Belgi” “10 mètres” becomes 10 “mtres”)
  3. Using LibreOffice or OpenOffice works often better than Excel to convert the data into Excel, especially if the source data contains line breaks (several lines)