Microsoft Excel is a spreadsheet program that employs a simple non-proprietary binary code (XLS) which allows it to work with several different formats. One of these is Comma Separated Format (CSV), which is commonly used in the transfer and storage of bulk data. This data may require separate lines of related information, such as addresses, to be linked together. The CSV format can be read and edited by Microsoft Excel programs. CSV also shares similarities with the OFX XML based code in so far as the structure of each consists of lines of data separated (delimited) by symbols. Open Financial Exchange (OFX) files use the XML code to store, transfer and manipulate data over the internet. It primarily functions as a conduit to pass along data related to financial activities. Since XLS and OFX are two different formats, they do not work together directly. A conversion program is needed to enable the transition from XLS to OFX. Tips Warnings Writer Bio
