Local CSV

What is a Local CSV data source?

Local CSV refers to a comma-separated values file on your local computer that contains the location of images to be used in a data set. Images are specified in the form of URLs or file URIs where the image resides.

To use a CSV to specify your data set, you will need a file containing a list of URL/file URI paths to your images.

Sample CSV with only URLs, separated by linebreaks:

https://www.arborday.org/images/hero/medium/hero-aerial-forest-evergreen-trees.jpg
https://www.arborday.org/trees/lifestages/images/figure-life-stages.jpg

If there is more than one column in your CSV, you will need to make sure there is a header. You can then specify which column contains the URLs when adding your data source.

Sample CSV with header:

id,name,image_url,created_at        
1,Maple Tree,https://extension.unh.edu/sites/default/files/styles/2x_blog_main/public/field/image/maple-tree-in-park-110661300191011Zru.jpg?itok=Ma4-jMXY&timestamp=1567092160

Adding a Local CSV Data Source

Once you have a CSV specifying your image file locations, you can add a Local CSV data source in HyperLabel. Data Source Name - A friendly name for your data source. This is how it will display in your list of data sources. Delimiter - A delimiter is the character that separates columns in a CSV file. By far the most common delimiter is a comma (,), but sometimes tabs, semicolons (;) or pipes (|) are also used. Here is a typical example of a CSV file with a comma (,) as a delimiter:

id,name,image_url,created_at        
1,Maple Tree,https://extension.unh.edu/sites/default/files/styles/2x_blog_main/public/field/image/maple-tree-in-park-110661300191011Zru.jpg?itok=Ma4-jMXY&timestamp=1567092160,1562878091000

If you have only have a single-column CSV then you can leave this field blank, or leave it as the default comma (,) delimiter. URL Column Name - The column name under which each row's data url resides. For instance, if you have a CSV file with the following columns:

id | name | image_url | created_at

you would enter image_url in this field.