---
title: Batch Template Guide
description: Fast answers to commonly asked questions.
---

[Skip to content](https://help.datazoo.com/en/dz-knowledge-base/batch-template-guide#main-content)

English

Show submenu for translations

[Create a support ticket](https://help.datazoo.com/en/dz-knowledge-base/kb-tickets/new?hsLang=en) [Customer portal](https://help.datazoo.com/dz-support?hsLang=en)

[![data zoo logo](https://help.datazoo.com/hs-fs/hubfs/Asset%201@2x-8.png?width=400&height=70&name=Asset%201@2x-8.png)](https://www.datazoo.com)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Create a support ticket](https://help.datazoo.com/en/dz-knowledge-base/kb-tickets/new)
- [Customer portal](https://help.datazoo.com/dz-support)
- [Data Zoo API Documentation](https://docs.datazoo.com/api)

[Data Zoo API Documentation](https://docs.datazoo.com/api)

 Welcome to our Support Portal

- There are no suggestions because the search field is empty.

1. [Data Zoo Support Knowledge Base](https://help.datazoo.com/en/dz-knowledge-base?hsLang=en)
2. [Integrations](https://help.datazoo.com/en/dz-knowledge-base/integrations?hsLang=en)

August 11, 2025

# Batch Template Guide

The Batch Template file has 2 sheets:

1. **'Input'** sheet: For inputting the data 
2. **'Input Validation'** sheet: For verifying whether or not the information entered is in the right format

Before you begin, please have a look at the following guide to understand what various colors in both sheets mean.

- Column headings with **green background**: Mandatory fields
- Cells with **red background**: 
  
    - The information entered in a mandatory field does not follow the required format  
      OR
    - A mandatory field of a record has been left blank

**Important note: **Correcting the text in the red cells is essential in order for the batch file to be processed. Correcting the info in the grey cells is optional but very much recommended if you want to verify those optional fields as well.

- [FAQs](https://help.datazoo.com/en/dz-knowledge-base/faqs?hsLang=en)
- [Integrations](https://help.datazoo.com/en/dz-knowledge-base/integrations?hsLang=en)
- [General](https://help.datazoo.com/en/dz-knowledge-base/general?hsLang=en)
- [Support](https://help.datazoo.com/en/dz-knowledge-base/support?hsLang=en)
- [Account & Settings](https://help.datazoo.com/en/dz-knowledge-base/account-settings?hsLang=en)

[![data zoo logo](https://help.datazoo.com/hs-fs/hubfs/Asset%201@2x-8.png?width=400&height=70&name=Asset%201@2x-8.png "data zoo logo")](https://help.datazoo.com/?hsLang=en)

Copyright © 2025, Data Zoo