Importing Birdtrack sightings to My Birding

If you are a Birdtrack user and want to import your data to My Birding, carefully follow these steps.

Please note that for the moment only Birdtrack UK is compatible with our import tool. Soon, import from other Birdtrack distributions will also be able to import their data.

Data setup

From the Birdtrack UK website (http://www.birdtrack.net/):

  • Go to the “All my observations” page (http://app.bto.org/birdtrack/reports/reports.jsp).
  • Adjust the filters on the left to the desired results, and click on the GO button. A list of sightings will be displayed.
  • Click on the Excel icon in the top-right-hand corner of the page. A XLSX file will be downloaded to your computer.
  • Open the file with your spreadsheet edition software, like,  for example, Microsoft Excel.
  • The file contains two sheets: “Summary” and “Records#1”. The first one, “Summary”, must be deleted: right-click the tab and choose Delete from its shortcut menu.
    Once “Records#1” is the only sheet left, you can go to the next step. Leave the header (the first row) as it is.
  • Each import process to My Birding is limited to 10,000 rows. If your file contains more, you will need to split it into separate files, then follow the instructions below for each file.
  • Save it as a UTF-8 and comma-separated (or semi-colon) CSV file. The following are ways you can do this with some common spreadsheet applications (please note that this is not an exhaustive list; please refer to the documentation for the relevant application and version you are using if these do not work for you):
    • MS Excel:
      • Click menu > Save As (Other Formats)
      • Enter a name for the file and choose "Unicode Text (*.csv)" for "Save as type :"
      • Click Save
    • Google Docs/Sheets:
      • Go to File > Download As
      • Select Comma-separated values (.csv, current sheet)
    • LibreOffice:
      • Go to File > Save As...
      • File Type: choose Text CSV
      • Check the “Edit filter settings” option
      • Click the Save button
      • Character Set: Choose "Unicode (UTF-8)"
      • Field delimiter: , (comma) or ; (semi-colon)
      • Text delimiter: “ (double quote)
      • Check “Quote all text cells”
      • Click OK.
    • Numbers (Mac):
      • Click on File
      • Hover over Export
      • In the submenu that appears, choose CSV
      • Click on Advanced Options to show the Text Encoding dropdown
      • Select Unicode (UTF-8) from the dropdown menu
      • Click Next
      • Click Save

In case an assistant pops up while saving the file, the complete file requisites are:

  • One-row header
  • Separator: comma or semi-colon
  • Text delimiter: " (double quote)
  • Character set: Unicode (UTF-8)
  • Language: English (USA)
  • Quoted field as text

We are aware that some contexts described in the steps above are not necessarily the ones with which you will be faced. This depends on external circumstances that we cannot fully control, such as your operating system, the software you use to open the file, and the configuration of this software.

Create the import to My Birding

Follow these steps in order to upload your records to My Birding:

  1. To create a new import, go to the My Birding main page and scroll down to the blue block called "Import your sightings from external sources". Click on the "Start a new import process" link.
  2. Choose “Birdtrack” as the external source.
  3. Add your CSV file and click on the Upload button.
  4. Once uploaded, scroll down to the “Save import configuration” button and click on it.
  5. If your file is valid, a confirmation message will appear and you can go to the next step.
    If not, some instructions will be displayed in order to help you to locate the error in the file’s sheet. You will have to edit your file and save it as you did above. Upload your file and click on the “Save import configuration” to see if the system validates it.
  6. When you’re ready, click on the red button “Enable import process”.

During the import process

The process converts each row from the exported CSV file into sightings along with their respective birdlists.

As the exported file provided by Birdtrack do not offer the latitude/longitude of each record, our system will link them with Great Britain.

During the import process, do NOT edit any birdlist or sighting until it is completed.

The system imports the data from the queued CSV files progressively and in the order of arrival of users’ requests. Please be patient!

The page will refresh automatically every 10 minutes to show the progress of the import process.

After the import process

After the import is done, a confirmation message will be displayed, along with a few links to check and improve the imported data.

If some unrecognized species still remain, you will be able to either edit each sighting to manually choose a new one, or choose the correct species for all the sightings affected by the same unrecognized species. The system will make some suggestions so the species can be conveniently and easily corrected.

← Back to General considerations on importing data to My Birding