Skip to main content

Import activities from a CSV

Import planned and completed activities from a CSV or Excel file exported from your previous farm software.

P
Written by Phase Team

If your previous farm software can export your activities as a CSV, upload that to Crop Plan Import instead of the PDF reports. It is quicker and more accurate: Phase reads it on the spot and takes every activity exactly as recorded. Planned activities come in as a crop plan, and completed ones as season history, one season at a time.

When to use a CSV

  • Use a CSV when your previous software can make a custom report. Phase reads it straight away, with no waiting and no page reading, and keeps each activity's paddock, date, products, rates (litres or kilograms per hectare), water rate, area and cost exactly as recorded.

  • Use the PDF reports when custom reports aren't on your subscription of that software. See Upload and review a crop plan report.

  • Completed or planned. An activity with a date completed comes in as season history. One with no date yet comes in as a crop plan.

  • Trial. Reading a CSV doesn't use one of a trial's five report reads.

  • Excel. An .xlsx, .xls or .tsv file uploads as it is, read like the CSV it would save as, from a computer, phone or iPad. It still needs the activities export's columns (Season, Activity Id, Field, Input): a sheet typed up by hand without them stops at "Choose the missing columns", as a CSV does.

Make the export

CSV instructions, under the upload panel in Crop Plan Import, has these steps with pictures. It takes about five minutes the first time, and the saved report runs again for any season. In your previous farm software:

  1. Open Reporting, then Custom Reports, and click New Report.

  2. Give the report a title such as "Phase import".

  3. Under Report Sections, leave Activities selected and click Add. This one section holds both completed and planned work.

  4. Under How do you want to group the data?, add these seven columns in this order: Season, Activity Id, Company Name, Farm, Field, Input, Date Completed.

  5. Under What data do you want to view?, add these five: Cost, Cumulative Area, Total Application Rate, Volume Rate, Weight Rate. Volume Rate and Weight Rate together carry the rate of every input, liquid or granular.

  6. Click Done, then Next.

  7. Click Save & Preview. Under Company Name and Season, choose the seasons you want, or leave it empty for every season.

  8. Click Run Report, then Export. A .csv file downloads.

Upload and choose a season

  1. Open More → Imports & templates → Crop Plan Import.

  2. Select Upload PDF or CSV and choose the .csv file (or the Excel file). Phase shows Activities CSV with the number of rows, seasons and activities it found.

  3. If Phase can't find a column it needs, it says "Choose the missing columns". Under Columns, pick which column in your file holds each one. Season, Activity ID, Paddock and Input are needed; the rest are optional.

  4. If the file holds more than one business, tick the ones that belong on this farm under Business.

  5. Under Season to import, pick one season. Each shows how many activities are completed and planned, how many paddocks, and the dates.

  6. Under What should this become?, choose Season history (actuals) for the completed work, or A crop plan for the planned work.

Review and import

  1. Check the Season Phase will save into. Phase suggests your own season for that year; pick or type another if needed.

  2. Match paddocks under Paddocks: the one thing to check, and check products under Products: nothing you have to do, as for a PDF report. See Upload and review a crop plan report.

  3. Select Plan N activities on the season (or Record N completed activities on the season), read the short check, then select Import plan (or Record work).

  4. On the receipt, select More from this CSV to bring in the other half of that season, or pick another season, without uploading the file again. Your paddock choices carry over.

Undo this import, and the skipping of activities already in Phase, work the same way as for a PDF.

Good to know

  • Draft and final versions of a year come out of the export as separate seasons, so nothing is mixed up. Pick the one you want.

  • Duplicate activities. When the export holds the same completed activity twice under two activity IDs (same paddock, date and inputs), Phase keeps one and says how many it set aside, so costs aren't counted twice.

  • The CSV isn't filed in Documents. A PDF report is.

  • Only here. Crop Plan Studio's Import a PDF sheet reads PDFs only. A CSV or Excel file goes through Crop Plan Import.

  • Before 20 October 2026 a CSV was turned away here with a note to email it to support. It now imports directly.

If something doesn't look right

  • "That CSV is empty." Export the report again and check the file has rows.

  • "Phase found the columns but no activity rows." Run the report again with the seasons you want, then export it.

  • You can't make a custom report. Upload the PDF reports instead, or ask your farm management provider for a CSV of your records and send it to us.

  • It still doesn't work. The Didn't work? We'll import it for you card has Email us the file. Email the PDF or CSV to support@phase.ag and we'll import it for you.

Related

Did this answer your question?