Exporting data from QGIS to excel

How to export data from a dataset in QGIS to Excel

1. Right click on the dataset > Export > Save Features as
2. For excel, choose CSV as the format
3. Click the three dots to the right of the File name field
4. Navigate to where you want to save the CSV, and give the file a name
5. Click OK. The csv can then be opened in Excel and saved as xlsx if needed.

If you only want to save certain features – e.g Acoustic Monitors

1. Right click on the dataset > Open attribute table
2. In the top ribbon, click on the yellow square with an E in the corner (Select features using an expression)
3. Double click Fields and Values > DeviceFunction from the central column, and then type = after DeviceFunction in the left column. Then click All unique in the right column, and double click on Acoustic Monitor
   The query will look like: "DeviceFunction" = 'Acoustic monitor'
4. Click Select Features and then Close
5. Close the table to return back to the main QGIS map.
6. Right click on the dataset > Export > Save Features as
7. For excel, choose CSV as the format
8. Click the three dots to the right of the File name field
9. Navigate to where you want to save the CSV, and give the file a name
10. Make sure that Save only selected features is ticked
11. Click OK. The csv can then be opened in Excel and saved as xlsx if needed.