---
title: "How to Format Your CSV File for Transaction Uploads"
description: "Summary"
canonical_url: "https://support.taxcloud.com/articles/how-to-format-your-csv-file-for-transaction-uploads-i8HCcZlhUW"
md_url: "https://support.taxcloud.com/articles/how-to-format-your-csv-file-for-transaction-uploads-i8HCcZlhUW.md"
---
# How to Format Your CSV File for Transaction Uploads

### Summary

This article explains how to download the official CSV template and format your data correctly. Following these steps is crucial for a successful bulk transaction upload and helps prevent common processing errors.

### When to Use This

Always refer to this guide before creating or editing a CSV file for transaction uploads. Proper formatting is the most important step to ensure your data is processed quickly and accurately.

[How to Format Your CSV File for Transaction Uploads 1512x946](https://support.taxcloud.com/api/attachments.redirect?id=50544243-b515-429f-807d-d4aeb332f732&start=32&end=61)

### Step-by-Step Instructions


1. **Access the Documentation**: From the main menu, navigate to the transaction upload section and click the **Upload a CSV file** button.
2. **Open the Documentation Dropdown**: On the upload page, locate and click the **Documentation** dropdown menu.
3. **Download the Template**: Click the **Download Example** button within the documentation section. This will download a sample CSV file with all the necessary headers.
4. **Review Column Requirements**: The Documentation section provides a detailed table of all possible columns. It explains what each column is for, provides an example, and specifies the data type (e.g., string, date, number), whether the field is required (`is nullable` = false), and the maximum length.
5. **Populate Your Data**: Open the downloaded template and fill in your transaction data under the appropriate columns. Ensure that all required fields are filled and that the data matches the specified format (e.g., dates are `YYYY/MM/DD`).

### Common Questions (FAQs)

**1. Where can I find the CSV template?** You can download the template by clicking "Upload a CSV file," opening the "Documentation" dropdown, and then clicking "Download Example."

**2. What is the difference between required and optional columns?** Required columns must contain data for every transaction row to be processed successfully. Optional columns can be left blank if the information is not applicable or available.

**3. Do I need to include all the columns from the template in my file?** No, you only need to include the columns you are using. However, you must include all required columns for the upload to be successful. The column names must exactly match those in the documentation.

### Troubleshooting Tips

* **Can't Find Download Button**: The "Download Example" button is located within the "Documentation" dropdown on the CSV File upload page. If you don't see it, ensure you have clicked on the documentation section to expand it.
* **Data Formatting Issues**: Carefully check the "Type" and "Max Value" fields in the documentation table to ensure your data conforms to the required structure. For example, ensure dates are in the correct format and zip codes do not exceed the maximum length.
* **Remove extra columns**: Only include columns from the template. Adding columns the template doesn't define (for example, a Subtotal column) prevents the system from pinpointing errors and causes rows to be flagged as unknown errors.