Use string searching to quickly find specific data within a CSV. Perform various functions to help narrow down your search, export and share data. Quicklook works with a flat CSV database containing headers and rows. The headers must be in the first row followed by additional rows.
- Search & Customize CSVs
- Scan barcode to search
- Sync with iCloud
- watchOS Extension - sync lists to Apple Watch.
By clicking on the folder icon document browser will open and you can begin importing CSVs. You can also share files by using Apple's built in 3D touch feature “peek and pop”.
Create a new CSV by specifying headers. After headers are created add content by pressing the + sign on the footer bar of the list view.
Files marked with a filled circle are available locally on your device.
Files marked with an empty circle are still in the cloud and will be synced when opening or pulling the file list down.
After opening a file you can begin searching its contents using the search bar. You can specify which columns to view by pressing the headers button.
While in the Column / Header selection view you can also modify header names by pressing the pencil with the circle with pencil. For example, you could change Barcode to Asset Tag and Asset Serial No to Serial. This is handy when CSVs are used for importing data to servers through scripts or applications that require specific header names on the CSV.
When a header is modified the circle will be filled in. You can change the header back to its default state by pressing the modify header button again. The default header value will be displayed in the text field. Press the check box next to the text field and the header will be restored.
Toggle the A to turn case sensitivity on/off. 'A' performs a case sensitive search, 'a' will perform a case in-sensitive search.
If you have search results you would like to export you can touch the pin and save the search results to a new file.
You can truncate search results and search new strings limited to the previous search. This is a non-destructive function that won’t affect the original CSV but is useful for narrowing down a search.
Add new items to your list. You must save the list using the Pin to keep any additions.
Quickly share specific row items. If you press an item in your CSV list you will be taken to the item view and the share button will be displayed.
Within item view each header will be displayed with its associated value. If you press any key / value pair in this view the value will be copied to the pasteboard. Paste the value into the search bar by pressing the paste button located next to the search bar. The value is copied to the iOS pasteboard so you can paste the value into any field.
Scan barcodes into the Search Bar or into new textfields when creating lists by pressing and holding on the textfield to bring up a context menu presenting the Barcode Scanner.
Image to text is available by pressing and holding on the Search Bar textfield or an Add Item text field.