File Format Guidelines for SaasAnt Transactions

To import your data seamlessly,” SaasAnt Transactions” needs to understand your data with a specific file format. So we have decided to follow one GOLDEN Rule.

SaasAnt Transactions - Golden Rule:

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” did not show your file headers in the field mapping screen properly. This will happen only if your file does not have HEADERS in the first row. This is a common issue when we receive a file from any 3rd party software.

Wrong File Format :

This is an example of the wrong file.

Workaround :

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

Proper File Format:

Supported File Types

1. Excel Work Books (.XLS, .XLSX)

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

File Formatter

It is very common that you may have a file that may not agree to our guidelines. SaasAnt File Formatter feature will help you to convert files to the desired format. Check this link for more information.