How to perform a Batch VEVO Search using Excel

The Batch VEVO using Excel search function enables you to perform a VEVO Visa Entitlements search for multiple individuals in the one process. This process allows you to load multiple individuals via an Excel Spreadsheet rather than processing Matters from within Migration Manager.  This is a stand-alone search tool.  No data or documents will be automatically stored as a result of this search, however you will have the option to export the results to Excel and the end of the process. The following article sets out how to perform a Batch VEVO using Excel Search.

Important: Your ImmiAccount must have VEVO search enabled in order for this function to work. If you do not have VEVO search enabled you need to contact the Department of Immigration to have this feature made available on your ImmiAccount.

1. Run Batch VEVO using Excel

Go to Tools => Batch VEVO => Using Excel.

Take note of the message stating this process will not store results against Matters, and if you wish to store the details in MM, to run Batch VEVO via Reports.  Click OK.

The Excel Batch VEVO window will display.

2. Generating a Template

If you do not already have an Excel Template for Batch VEVO using Excel, you can click the Generate Template button to create a blank Template to use.  If you already have a spreadsheet in the correct format, you can skip this step.

Excel template Spreadsheet.

3. Prepare you Data

Complete the spreadsheet including the mandatory fields

  • Family Name
  • Given Names   (If the person has given names)
  • Date of Birth
  • Passport Country
  • Passport Number

4. Save the Spreadsheet.

Save the Spreadsheet to your choice of location.  You may want to save this file in a sub-folder of your main Migration Manager folder for ease of access.

5. Import the Spreadsheet into Batch VEVO

Click the Import button:

Browse and select your file, then click Open.

The data will load into Batch VEVO

Click Perform VEVO Searches to start the search.

7. Choose your login.

Select the user who has VEVO Search enabled on their immi Account, then click Fill & Login.

8. Enter your Authentication Code

Using Email or SMS, enter the Authentication Code sent to you by immi.

VEVO Search will run and the Summary will display.

The VEVO Search Results will then display.

9. Export the Results

You can now Export the results to Excel.  Click the Export button to export to excel, then save the Spreadsheet to your chosen location.