How to Import Works into ARTERNAL

Learn how to import works into ARTERNAL using a template, including how to upload and process your spreadsheet.

Written by Yujia Zheng
October 14, 2024

Batch-importing works from an Excel or Google Sheet can save you time 🎉. Whether you're uploading new work or batch-updating existing ones, importing via a CSV file is the most efficient method. Follow this guide to ensure a smooth import process. For a detailed breakdown of the import template, check out our article here.

Step 1: Access Import/Export

• In the bottom-left corner of your screen, select your account > Import/Export.

Step 2: Navigate to Import Works

• In the left-hand banner, click on Import Works.

Step 3: Get the Template

• To view the template for importing works, click Get Template.

Things to Keep in Mind:

• Optional Fields: You don’t need to fill in every column. Leave columns blank if certain information is unavailable.
• Header Formatting: Ensure all spreadsheet headers are in lowercase and use underscores (e.g., first_name, last_name) as shown in the template.
• Multi-Entry Fields: Only the tags and roles fields allow multiple entries. Separate values with commas. Other fields like email and assigned lists only accept single entries.
• File Format: The spreadsheet must be in CSV format.
• Work Limit: Each CSV file can hold up to 2,000 works. For larger lists, split them into separate files.
• Updating Existing Works: ARTERNAL uses the inventory number to identify works. If a work already exists, it will be updated instead of created as a duplicate.

Step 4: Upload Your File

• Fill out the template, then return to ARTERNAL and select Upload Spreadsheet.

Step 5: Start the Import Process

• In the Upload File window, add your completed spreadsheet. Your import will begin processing automatically.

Frequently Asked Questions (FAQ):

Q: Where can I find the template for importing works?
A: You can find the template by going to Import Works and selecting Get Template.

Q: How do I upload my works to ARTERNAL?
A: Once you’ve filled out the template, go to Import Works and select Upload Spreadsheet to upload your file.

Q: What happens after I upload the spreadsheet?
A: Your import will start processing automatically, and your works will be added to the inventory once completed.