Skip to main content

Import CSV file on the spreadsheet method as datasource

Learn how to use CSV imports to power your Abyssale spreadsheets and automate your design production at scale.

Updated over a week ago

Import CSV files as a datasource

CSV files are the most efficient way to import existing data into Abyssale and generate hundreds of design variations in seconds.

Before you start

To ensure a smooth import, please verify that your file respects these technical requirements:

  • Format: The file must be a .csv.

  • Size: Maximum file size is 10 MB.

  • Delimiter: You must use a comma (,) as a separator.

  • Capacity: Only the first 1000 rows will be imported per batch.


Step 1: Downloading your custom Sample CSV

Every Abyssale design is unique, and so is your data structure. To save time and avoid mapping errors, we recommend using our auto-generated CSV template.

  1. Click on Create new spreadsheet from the Spreadsheet Generation tab.

  2. Select Import CSV.

  3. In the import modal, click the Download a sample CSV button.

IMPORTANT: Each sample CSV is unique to its design. Because the columns are generated based on your specific layers, a sample CSV downloaded for "Design A" will not work correctly for "Design B".


Step 2: Structuring your data

Once you open your CSV, here is how the data is organized:

  • Rows: Each row represents one unique variation of your design.

  • Columns: Each column corresponds to a specific layer or property (Text, Image URL, Color, etc.).

  • The Header (First Row): This row contains the column names.

Pro Tip: If you keep the column names exactly as they appear in the sample (matching your design's layer names), Abyssale will automatically match them during import, skipping the manual mapping step!


Step 3: Importing and Mapping

  1. Drag and drop your completed CSV file into the modal or import via URL.

  2. A mapping screen will appear. Here, you can match your CSV columns with the corresponding layer properties in your design.

  3. Enable only the layers you wish to vary.

  4. Click Import CSV. You will be redirected to your new Abyssale Spreadsheet.


Accepted Content Types

To ensure your data is recognized correctly, please format your cells as follows:

Data Type

Accepted Format

Example

Color

Hexadecimal code (6 or 8 digits)

#68FFAD

Image

Direct URL to image (jpeg, png, svg)

https://site.com/image.png

Video

Direct URL to video (mp4, webm)

https://site.com/video.mp4

Text

Plain text. Use \n for line breaks.

Hello World\nNew Line

Rating

Number between 0 and 100.

90 (converts to stars)


Column Naming Convention

If you prefer to create your own CSV from scratch rather than downloading our custom sample CSV, you can still benefit from automatic mapping. When our system detects that a column header in your CSV matches a layer name and property in your design, it will pair them automatically, skipping the manual configuration step.

Based on the structure of a standard Abyssale design, here are the exact column names you should use to trigger automatic matching:

Layer Type

Required Column Header Format

Column name Example

Format Background Color

root-background_color

root-background_color

Text Content

layername-payload

text_0-payload

Text Color

layername-color

text_0-color

Images

layername-image_url

image_0-image_url

Videos

layername-video_url

video_0-video_url

Buttons

layername-payload layername-background_color

button_0-payload

Ratings

layername-rating_score

rating_0-rating_score

Shapes

layername-background_color

shape_0-background_color

QR Codes

layername-payload

qrcode_0-payload

Key Rules for Manual CSV Creation

  • Layer Names: The first part of the header (before the hyphen) must match the Layer Name defined in your Abyssale editor (e.g., if you renamed a text layer to "Headline", your column should be Headline-payload).

  • Properties: The second part (after the hyphen) must be the specific property you wish to change, such as color, background_color, or image_url.

  • Case Sensitivity: Ensure your layer names match the casing used in the Abyssale editor.

Technical Metadata Columns

You can also include specific columns for platform-specific settings:

Type

Required Column Header Format

Content Example

Formats

formatname

instant-experience-ads,email-large

Localization

country

language

US

en

Tagging for naming convention

custom_text

Campaign A

HTML5 Click Tag

html5_click_tag

html5_title

Page title


Advanced: Multi-decorated text

Just like in the design editor, you can include formatting tags in your CSV to vary the style of specific words within a single text layer (e.g., bolding one word while keeping the rest regular).

For a deep dive into text formatting, check out our Text Decoration

Did this answer your question?