Return to Guides

CSV Import Guidelines

PLEASE NOTE: We do not recommend viewing, updating, or exporting your CSV in Microsoft Excel, as it may not preserve special characters.* We recommend using Google Sheets, Apple Pages, Airtable, or a plain text editor. CSV upload is limited to 500 objects at a time. If you are uploading more than 500 objects, you will need to upload multiple CSVs.

Import a Group of New Objects

  • To batch upload a group of new objects for a selected Blueprint, download the CSV template for that Blueprint. Go to the Blueprint Page and click “Download CSV Template.”
  • The first line in the CSV template (column headings) will correspond to the field ids in your selected Blueprint. DO NOT alter these.
  • Add your object information values to the CSV. PLEASE NOTE: Every object must have a title.
  • PLEASE NOTE: You must enter a dash in any empty field without a value to preserve order.

    For example:
    title,artist,medium
    Moonrise,-,Oil on canvas

csv example 1

  • Once you’ve input and saved the information in the CSV, go to the Objects Page from the MOON menu. Filter your objects by Blueprint and choose your selected Blueprint.
  • Click on the upload icon to import the CSV. You can upload information for 500 objects at a time. You’ll receive a message letting you know if the objects were added successfully.
  • PLEASE NOTE: When you upload a CSV with new objects, make sure to upload it only once – otherwise you’ll create duplicate objects.

Edit Existing Objects & Add New Objects

  • To batch edit existing information for a group of objects, with the option of adding new objects, download the object data CSV for that Blueprint. From your Objects Page, select your Blueprint in the “Filter by Blueprint” dropdown. Then click the download icon, which will let you “Download [Blueprint Name] Object Data” as a CSV. The CSV will include existing object data, to which you can add data for additional objects. Existing objects have an object id (oid), new objects you add will not.
  • The first line in the CSV (column headings) will correspond to the field ids in your selected Blueprint. DO NOT alter these.
  • Edit existing object information in the CSV. Once uploaded, the updated information will overwrite the old information.
  • PLEASE NOTE: You must enter a dash in any empty field without a value to preserve order. For existing object data, dashes will appear in fields without values.

    For example:
    oid,title,artist,medium
    123456,Moonrise,-,Oil on canvas
    -,Full Moon,Bob Smith,Gelatin silver photograph

csv example 2

  • To duplicate an existing object, replace the object id (oid) with a dash. This will create a new, duplicated object once uploaded.
  • New objects added to a CSV along with existing objects will not have an object id (oid). Enter a dash in this empty field for any new objects you add.
  • PLEASE NOTE: Every object must have a title.
  • Once you’ve input and saved the information in the CSV, go to the Objects Page from the MOON menu. Filter your objects by Blueprint and choose your selected Blueprint.
  • Click on the upload icon to import the CSV. You can upload information for 500 objects at a time. You’ll receive a message letting you know if the objects were uploaded successfully.
  • When you import a CSV with new objects, make sure to upload it only once – otherwise you’ll create duplicate objects.

Adding New Column Headings to a CSV

  • Any column headings you add to a CSV that are not represented in the selected Blueprint CSV must be lowercase and must not include punctuation, numbers, or special characters. Replace any spaces with dashes or underscores. For example, a column heading with the name Self-Portrait Exhibition Display Plans would look like: self-portrait-exhibition-display-plans (all lowercase, dashes instead of spaces between words).
  • PLEASE NOTE: You must enter a dash in any empty field without a value to preserve order.

    For example:
    title,artist,medium,self-portrait-exhibition-display-plans
    Moonrise,-,Oil on canvas,-
    Full Moon,Bob Smith,Gelatin silver photograph,Black frame

csv example 3

  • Any additional column headings and informational values you add to the CSV will appear in the "All Data" section for each object. If there’s information in “All Data” that you would like to show in a specific Blueprint (for example, if you added an “artist-nationality” column with data, just add a field labeled “Artist Nationality” to the preferred Blueprint and it will display the information.

Deleting Objects

  • To delete an object or a group of objects, download the CSV for the selected Blueprint.
  • The CSV will include a column heading called ostatus (lowercase, all one word).
  • You can delete an object by entering delete in the field value for the ostatus column.
  • PLEASE NOTE: For objects that you do not want to delete, make sure there is a dash in the empty ostatus field value to preserve order.

    For example:
    oid,ostatus,title,artist,medium
    123456,-,Moonrise,-,Oil on canvas
    123321,delete,Full Moon,Bob Smith,Gelatin silver photograph

csv example 4

  • Once you’ve input and saved the information in the CSV, go to the Objects Page from the MOON menu. Filter your objects by Blueprint and choose your selected Blueprint.
  • Click on the upload icon to import the CSV. You’ll receive a message letting you know that the object(s) have been deleted.

Questions about CSVs? Reach out

*If a special character does not display correctly after uploading a CSV exported from Microsoft Excel, you can paste the appropriate character into the respective field on the Object Page. Remember to save the update.