Skip to main content

Importing Art

Art information is often collected via Google Sheets, Air Table or another spreadsheet tool. If you can export to a CSV file then dust can import the art information.

Importing CSV

You can import a CSV file of art by:

  1. Click Art
  2. Click (in the top right corner)
  3. Choose Import CSV and select your CSV file

Preview Before Import

After selecting your file, you'll see a categorized preview:

  • New Art: Items that will be created
  • Updated Art: Existing items with changed fields (shows exactly which fields changed)
  • Existing Art: Items with no changes

Review the preview, then click Import to apply the changes.

Supported Fields

The CSV should contain the following fields in any order:

CSV ColumnDescription
name / title / art projectArt name (required)
descriptionArt description
typeOptional Art type classification (eg "Mutant Vehicle")
artist / artist nameArtist name
emailContact email address
web / urlOptional Website URL for the artist/art
image / logoOptional URL to art image
# / idOptional External ID for matching

Smart Matching

The import system uses intelligent matching to identify existing records:

  1. External ID Match: If your CSV includes an ID column, items are matched by external ID first
  2. Name Match: Items are matched by name (case-insensitive)

This allows you to update existing records even if names have minor variations, as long as the external ID matches.

Change Detection

For updated items, the system compares these fields and shows which have changed:

  • name
  • description
  • art_type
  • contact_email
  • artist
  • url
  • category
  • externalId

Image Import

When your CSV includes image URLs, the system will download, convert to WebP format, resize, and upload to your burn's image storage.

Tips

  • Export your existing data first to see the expected column format
  • Use external IDs for reliable matching across imports
  • Review the preview carefully before importing
  • Large imports may take a few minutes to process