I have used the SmartFinder export as you suggested, and I have had problems with it. If a field is blank, the columns to the right shift over one column and the result is ugly.

Try this in AR using Cust #, Name and Address, and leave the customer name blank for a customer, and you will see what I mean.