How to Export Data from AccuArk

Exporting data creates a CSV file containing your records. You can use exported files for backup, bulk editing in a spreadsheet, creating import templates, or migrating data to another system.

Step-by-Step: Exporting Data

1. Open the Data Exchange Center from the Business menu
2. Find the card for the data type you want to export
3. Click the Export button on that card
4. The Data Exchange Wizard opens in export mode
5. If the data type requires a location, select the location from the dropdown. Only data associated with that location is exported.
6. The wizard displays how many records are available to export (e.g., "Ready to export 1,247 Inventory Items records")
7. Click Export to CSV
8. A Save dialog appears. Choose where to save the file and optionally rename it. The default filename includes the data type and today's date (e.g., "InventoryItems_20260305.csv")
9. Click Save
10. The wizard confirms the export: "Exported 1,247 rows to InventoryItems_20260305.csv"

Export as Template

One of the most useful features of export is creating templates. If a data type has no existing records in AccuArk, the export still creates a CSV file — but with headers only and no data rows. This is your template.

For example, if you have not yet entered any inventory items:

1. Click Export on the Inventory Items card
2. The wizard shows: "No records to export (CSV will contain headers only — use as import template)"
3. Click Export to CSV and save the file
4. Open the file in Excel — you see column headers like "name", "sku", "barcode", "category", "price", "cost", etc.
5. Fill in your data under the headers
6. Save as CSV and import it back into AccuArk

Bulk Edit Workflow

Export and re-import is a powerful way to make bulk changes:

1. Export your current data (e.g., all inventory items)
2. Open the CSV file in Excel
3. Make your changes (update prices, add new items, correct descriptions)
4. Save the file as CSV
5. Import the file back into AccuArk
6. AccuArk detects which rows are updates (existing items) and which are new inserts

This workflow is much faster than editing records one by one in AccuArk.

What Gets Exported

Each data type exports the same fields that can be imported. The exported column headers match the field names used by the import wizard, so the file can be imported back without any column mapping changes.

For data types that are location-aware (like Inventory Items or Bank Transactions), only data for the selected location is exported.

File Format Details

• Format: CSV (Comma-Separated Values)
• Encoding: UTF-8 with BOM (compatible with Excel)
• Delimiter: Comma
• Text qualifier: Double quotes (for values containing commas)
• Date format: YYYY-MM-DD (e.g., 2026-03-05)

Limitations

• Opening Balances cannot be exported (import only)
• Export creates a snapshot of current data. It does not include historical changes or deleted records.
• Very large exports (tens of thousands of rows) may take a few seconds to complete.