Why did the columns shift in my exported dedupe action?

There are two identified reasons for shifting columns in dedupe exports. 

1. A comma in a field name breaks the column order, because csv spreadsheets interpret commas as a separator and thus split up the single field name into two columns. To solve this you can:

   1. Go into the source csv file via a text editor (before opening it in excel) and surround the field name in double straight quotes so that the csv sees it as one value (there are various articles on the internet to explain straight quotes).
   2. Remove the field from the table before export
   3. Remove the comma from the field name in Salesforce.

2. When exporting the table from the Dedupe tool, Apsona always inserts the object ID field into the csv so that your export has IDs to reference. If you manually include the object ID field in the " Additional Fields " section, Apsona will see two columns for the same field and remove the column that you added. This has the unintended consequence of shifting the values within the subsequent columns to the right by one, thus misaligning the column header (field name) to the values. To solve for this, do not include the object ID field in the "Additional fields" section when building your dedupe action.