To import your data seamlessly, ”Excel Transactions” needs to understand your data. So we have decided to follow one GOLDEN Rule.


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 “Excel Transactions” 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.

This is a common issue when we receive a file from any 3rd party software's.

 


Wrong Format


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




Workaround


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)


File Formatter

 

It is very common that you may have file which may not agree to our guidelines. Our File Formatter feature will help you to convert files to desired format.