Spreadsheet Pickup

Spreadsheet pickup (previously CSV pickup) allows you to transform various spreadsheet file types into JSON or XML and then capture them as a dataset.
The spreadsheet can also be filtered to pick up specific rows you choose.

Valid file types are: 

• xls, xlsx, ods, csv, tsv, psv, log, txt, dat

Example use cases

This application can be used to use a CSV as a simple database : 

• Retrieve the list of possible impositions for a given product format and press;

• Get a list of email addresses belonging to a group/company with a particular position;

• Get Paper information (thickness, weight…)  in a spreadhseet database based on an ID/ref;

• Filter a log file based on log type (error, warning…);

• …