Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Login  Sign up

File Format Guidelines for SaasAnt Transactions (Desktop)

To import your data seamlessly, ”SaasAnt Transactions (Desktop)” needs to understand your data. Following recommendations helps you to import flawlessly.


The first line or first row of your file will be treated as your File Header.

Some of you might have experienced that “SaasAnt Transactions (Desktop)” did not show your file headers in field mapping screen properly. This will happen only if your file does not have HEADERS in the first row.

If the file does not have any valid headers,You can turn on "Auto Generated Headers" in mapping screen which enables “SaasAnt Transactions (Desktop)” to create HEADERS ( like Excel Headers).

Wrong Format

Below is the example of wrong file format. The file header is not aligned properly.


Just delete the unwanted rows or lines from your file and make the proper file headers as your first line.

Proper Format

Supported File Types

1.  Excel Work Books (.xls, .xlsx)

2.  CSV Files (Comma Separated, “|” pipe separated)

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.