Skip to main content
All CollectionsAutomation & GenerationGeneration MethodsSpreadsheet
Import CSV file on the spreadsheet method as datasource
Import CSV file on the spreadsheet method as datasource

Import CSV files to generate visuals in bulk

Guillaume Stigliani avatar
Written by Guillaume Stigliani
Updated over 2 weeks ago

Create a New Spreadsheet from Existing Data via CSV

CSV files can be easily imported on Abyssale to generate your visuals in bulk. Let's dive into it:

When you import CSV file, some rules need to be followed :

  • File must be a .csv

  • Maximum file size is 10 MB

  • Delimiter must be a comma ,

  • The first row will be used as column's names

  • Column without name will be skipped

  • Only the 1000 first row will be imported

  1. Click on "Create new spreadsheet" from the Spreadsheet Generation tabs

  2. Then click on Import CSV on the new screen

  3. A new modal appear to let you drag and drop your CSV file or import your CSV via URL

  4. A new modal appear to let you match the columns of your CSV with the layer property of your design, enable only layers and propertys you need to variate.
    ​

  5. Once you've completed your mapping, click on Import CSV. Your Abyssale Spreadsheet will be created and you will be redirected to it.

πŸ’‘Tips : A column of your datasource can be matched several times with several layer parameters.


What content are accepted into my CSV to be recognize by Abyssale ?

Each layers type in Abyssale have their own property, and some of them can be modified into through the spreadsheet in bulk.

Here is the list of the type of data that can be put into your csv :

  • Color type: Hexadecimal color (6 or 8 digits starting with a # character). i.e #EAEAEA or #FF000033

  • Image type: Image URL (supported types: jpeg/png and svg). i.e https://cdn.pixabay.com/photo/2020/12/13/16/21/stork-5828727_960_720.jpg
    ​Beware: URLs such as https://unsplash.com/photos/BkkVcWUgwEk are HTML links and not images, hence this parameter will be considered as a text type (not an image).

  • Video type: video URL (supported types: mp4/webm). i.e
    ​https://cdn.pixabay.com/photo/2020/12/13/16/21/stork-5828727_960_720.mp4​

  • Audio type: video URL (supported types: mp3/wav). i.e
    ​https://cdn.pixabay.com/photo/2020/12/13/16/21/stork-5828727_960_720.mp3​

  • Text type: Any type of text content. If you'd like, you can announce in advance line breaks by using \n in your text payload (or by using a real line break).

  • Rating type: Score: Round number between 0-100. (It will be automatically converted to 5-stars ratings)


Multi decorate text in my CSV

Like in the design editor, you are able to make multi decoration on text into your csv. That way you can variate not only image, color and text content, but also decoration on part of a text.

Here is the full article about that from the Abyssale developper Api helpcenter:


​

Did this answer your question?