What File Format Does AccuArk Require for Imports?

AccuArk requires CSV (Comma-Separated Values) files for all data imports. CSV is a universal format that can be created from virtually any spreadsheet or database application.

How to Create a CSV from Microsoft Excel

1. Open your spreadsheet in Excel
2. Click File > Save As
3. In the Save as type dropdown, select CSV (Comma delimited) (*.csv)
4. Choose a location and click Save
5. If prompted about features not compatible with CSV, click Yes to continue

How to Create a CSV from Google Sheets

1. Open your spreadsheet in Google Sheets
2. Click File > Download > Comma-separated values (.csv)
3. The file is downloaded to your computer automatically

File Requirements

• First row must contain column headers — AccuArk uses the first row to identify each column during the mapping step. Do not include data in the first row.
• UTF-8 encoding is recommended — If your data contains special characters, accented letters, or non-English text, make sure the file is saved with UTF-8 encoding. Most modern spreadsheet applications use UTF-8 by default.
• One record per row — Each row after the header row represents one record (with the exception of multi-row data types like Outstanding Invoices).
• Commas as delimiters — Values in each row should be separated by commas. If a value itself contains a comma, the value should be enclosed in double quotes.

Getting the Right Column Headers

If you are unsure what column names AccuArk expects, use the export-as-template trick:

1. Open the Data Exchange Center
2. Click Export on the data type you want to import
3. Save the exported file — even if it contains no data, it will have the correct column headers
4. Open the exported file in Excel or Google Sheets
5. Fill in your data under the existing headers
6. Save as CSV and use this file for your import

This ensures your columns match exactly what AccuArk expects, which makes the column mapping step automatic.