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 a year ago

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

  1. Head to the Automate page and select the Spreadsheet generation method

  2. Select the template in which the new variation will be generated.

  3. Give a name to your Task, select the formats of your template where visuals will be generated in this Task and select the .CSV import option.

  4. A popup window will appear asking you to select (or drag&drop) your .csv file. As an example, you can download this file :


    โ€‹
    As mentioned in the modal, the first row must contain your columns names. If one column is empty, it will be skipped. The content inputted in other rows (row 2, row 3, row4, ...) will be analyzed by Abyssale to guess which type of content it should be associated with:

    • 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).

    • 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)

  5. Once the file has been loaded (or dragged and dropped), a modal is displayed to allow you to match your column data to your template's layers (all toggles are unselected by default).

    Once you've completed your mapping, click on Create feed. 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.

Did this answer your question?