How Do I Create a Template for Importing Data?

The easiest way to create an import template is to use the Export feature. When you export a data type, AccuArk generates a CSV file with all of the correct column headers already in place. You can then fill in your data under those headers and import the file back into AccuArk.

Step-by-Step Instructions

1. Open the Data Exchange Center from the Program menu
2. Locate the data type you want to import (for example, Inventory Items or Customers)
3. Click the Export button on that data type's card
4. Save the exported CSV file to your computer
5. Open the file in Microsoft Excel or Google Sheets
6. Enter your data in the rows beneath the header row
7. Save the file as a CSV when you are finished
8. Return to the Data Exchange Center, click Import on the same data type, and select your prepared file

What If You Already Have Records?

If you already have records in AccuArk for that data type, the export will include those records along with the column headers. This is actually helpful — the existing records serve as example data so you can see the expected format for each column. Simply add your new rows below the existing ones, or delete the existing rows and replace them with your own data.

What If You Have No Records Yet?

If no records exist for that data type, the exported file will contain only the header row with no data rows. This gives you a clean, blank template that is ready to fill in.

Why This Approach Is Recommended

Creating a CSV file from scratch requires you to know the exact column names and formats that AccuArk expects. Getting a column name wrong or using the wrong date format can cause validation errors during import. By starting with an exported file, you eliminate that guesswork entirely. The column names are guaranteed to match, and the mapping step of the import wizard will recognize them automatically.