You can receive files in CSV (comma separated values), flat file, or XML formats. Only one file format type can be used for each subscription, but you can change the format any time. These file types can be imported into software such as Microsoft® Excel, Word, Access, Lotus 1-2-3, SQL and Oracle® databases, and other database applications. Details about accepted file formats are as follows:
- CSV (comma separated value) files contain table data assembled in lines of plain text with the values from each cell separated by a comma and each row represented with a new line. A CSV file can be imported easily into Microsoft Access and Excel.
- Flat files are text files from which all word processing, structure, or mark-up characters have been removed. They generally take up less space than formatted files and can be used for Oracle, SQL, Lotus 1-2-3, or other database software.
- XML (Extensible Mark-up Language) is a flexible way to format information so it can be shared on the Web or intranets. With XML, you can create standard ways to describe content, so information is shared consistently. XML uses the tags only to delimit pieces of data, and leaves the interpretation of the data completely to the application that reads it. XML appeals to users who have the need to download files to their individual desktop computers or to their local area network for use in Microsoft Excel, Access, Oracle, SQL, Lotus 1-2-3, or other database software, as well as into enterprise systems.