The CSV Writer writes all attributes of a feature to an CSV file. Features of different types are written to different CSV files.
To turn records into spatial features, see the tips in the CSV format overview.
To view non-spatial data in the Data Inspector application, select Tools > Select All Features with No Geometry.
A common user requirement is to convert data held as plain X/Y coordinates into true spatial features. However, sometimes the opposite is required: spatial features must be converted into a plain text, comma-delimited (CSV) file. This FMEpedia article gives details.