CSV Lookup

$200.00 $ / year
Buy now
Try it for free

CSV Lookup allows a CSV (comma separated values) file to be used as a simple database to help simplify Switch flows. Instead of having to install and configure a database server, design tables, populate with data and write SQL queries, you can simply use a spreadsheet exported to CSV format. 

CSV Lookup supports up to 3 "compare" values and up to 4 "lookup" values. Compare values specify which columns in the CSV should be used to locate a matching row. Once a match has been found, CSV Lookup retrieves the values in the "lookup" columns and stores them in the job's private data. These values can be easily retrieved by other elements in your flow using Switch variables.

Compatibility
Switch Version Required: 13 update 1 or higher
Platform: Windows, Mac
3rd Party Compatibility: n/a
Reviews
David B. (United States)
5
Reviewed on 24 May 2017.

Fantastic APP!!!
Solved a HUGE problem for us!
Example: We had a print quantity run list for PDF documents supplied by client that was variable (dates). Page 1 of the PDF required 10 copies at press, page 2 50 copies, page 3 113 copies, etc...
We were able to link our customer supplied run list (Excel) to our switch flow using "CSV Lookup" and generate one PDF will all quantities included, resulting in a PDF of 17,000 pages.
The "CSV Lookup" app saved us 4 hours on the first job, and has completely automated the process.
Thank You Dwight for an incredible app.
---
Bennett Graphics (Atlanta, GA)

App creator

Apago, Inc.
Support
+1 770-619-1884
Online support

App creator

Apago, Inc.
Support
+1 770-619-1884
Online support