Converting a spreadsheet to a CSV file for importing data to trap.NZ

This is a good option when you have a large number of records kept in spreadsheets that you would like to import to your trap.NZ project

The same process is used for traps, bait stations, and monitoring stations. But for this exercise, I have used traps

It is important to note that the required fields must be tagged correctly. 


1. On your project page select the import trap records option, this will display all the fields available in the import trap records  settings and ensure all of the required fields are completed on your spreadsheet

1 web.png

2.png

2. Choose the spreadsheet file you want to import your current trap records from.

3 web.png

3. Download the file as a csv (comma separated values) file

4 web.png


4. The computer will ask you what to open the file with, and make your selection. ( I chose notepad)
5 web.png

5. The original spreadsheet will convert to csv6 web.png

 

6. Save this file

7 web.png

7. Using the import trap records tab,  Select choose file tab at the bottom and browse for the csv file you have saved, select the file and click  import

8 web.png

9 web.png9c web.png

8. Your trap records will now display on your project map

10 web.png

11 web.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Revision #3
Created 26 July 2022 02:03:45 by Lenore Winterburn
Updated 20 June 2023 19:37:41 by Lenore Winterburn