Skip to main content

My soil test results are in Excel. How do I prepare them for upload?

Written by Alex

If your soil test results are saved in Excel and include the coordinates of the sampling locations, you can prepare them for upload in two steps.

  1. Save the table as CSV. In Excel, go to File → Save As and select CSV (.csv). Keep the columns containing coordinates and soil test results.

  2. Convert the CSV to a Shapefile in QGIS. Follow our step-by-step guide to create a file containing the sampling points and their soil test results.

Make sure each row represents a separate sample and includes its coordinates.

Did this answer your question?