Importing GBIF data into LibreOffice Calc

LibreOffice Calc is a free and open source desktop application available on Windows, Mac and Linux.

Importing a GBIF download

  1. Download the desired occurrences in either Simple or Darwin Core Archive format.

  2. Unzip the downloaded file.

  3. Choose Data → Get Data → From File → From Text/CSV

    • For Simple format, choose the unzipped file ending ".csv"

    • For Darwin Core Archive format, choose the unzipped file called "occurrence.txt"

    • Set the Character set to Unicode (UTF-8)

    • Check the separator is set to Tab and nothing else

  4. Click OK

importing libreoffice download