Knowledge base | Datafiniti

Using CSV Data

From Wikipedia:

A comma-separated values (CSV)  file stores tabular data (numbers and text) in plain-text form.  CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by a comma. Usually, all records have an identical sequence of fields.

Using "flat" Views

We have various options when viewing or downloading data to "flatten" certain fields.  E.g., if you use the "products_flat_csv" view, this will create multiple rows in the CSV file for each product - one for each price associated with the product.

When downloading flattend CSV data, be prepared to see the "numDownloaded" field become larger than the "numRequested" field.  This happens because the download process counts each row as a separate record.  Additional rows created by this process don't count against your record limit.