A plain-text file format that stores tabular data with values separated by commas (or other delimiters). The most universal format for exporting and importing financial data across systems.
Understanding CSV (Comma-Separated Values)
CSV (Comma-Separated Values) is a plain-text file format that stores tabular data in rows and columns, with values separated by commas (though semicolons, tabs, and pipes are also used as delimiters). It is the most universal and widely supported format for exporting and importing financial data across different systems.
CSV files have no standardized structure — column names, date formats, number formats, and data organization vary between every bank, marketplace, and software application. This lack of standardization is both CSV's strength (any system can produce one) and weakness (importing requires column mapping and format translation).
Because CSV files are plain text, they can be opened and edited in any spreadsheet program (Excel, Google Sheets), text editor, or programming environment. This accessibility makes CSV the go-to format for data transformation workflows, even when the source or target system uses a more specialized format.
Why It Matters for Ecommerce
CSV is the "universal adapter" of financial data. When you need to move data from one system to another, exporting to CSV and converting to the target format is almost always possible. PrimeConnect's CSV-to-IIF and CSV-to-QBO converters handle the complex translation from generic CSV to QuickBooks-specific formats, including column mapping, date formatting, and transaction structuring.
Practical Example
Your bank provides a CSV download with columns: Date, Description, Debit, Credit, Balance. QuickBooks needs a QBO file with OFX-formatted transactions. PrimeConnect reads the CSV, maps Date to DTPOSTED, Description to NAME, and Debit/Credit to TRNAMT, generates unique FITIDs, and outputs a valid QBO file ready for import.
Related Terms
XLSX (Excel Spreadsheet)
Microsoft Excel's default XML-based spreadsheet format. Commonly used by banks and accountants to export or share financial data with formatting, formulas, and multiple worksheets.
File FormatTab-Delimited File
A text file where data fields are separated by tab characters instead of commas. The IIF format and some bank exports use tab-delimited structure for data interchange.
File FormatQBO (QuickBooks Online / Web Connect)
A variant of the OFX format used by QuickBooks to import bank transactions via Web Connect. Despite the name, QBO files work with both QuickBooks Online and QuickBooks Desktop.
Related Tools
Free PrimeConnect tools related to csv (comma-separated values)
Put This Knowledge Into Practice
Now that you understand csv (comma-separated values), use PrimeConnect's free accounting tools to convert your ecommerce data into QuickBooks-ready formats — 100% browser-based.
Browse Free Tools