ArtBinder Home

How do I add works in bulk using the Excel Importer?

  • First, you must export an Excel document of your current inventory management system (or create one from scratch). This should include one column for each of the relevant types of information for your objects - for example: Artist First Name, Artist Last Name, Title, Inventory ID, Medium, Dimensions, Price, Availability, Location, Edition Info or any other relevant details. You can create as many columns as you need.
  • Note that if your image files are saved with an Inventory ID, you can just have the Inventory ID column in the excel document and ArtBinder will pair the image with the object accordingly.
  • When the Excel document is complete and all of the details are formatted to your liking, save the file on your computer.
  • Next, you should check that the columns in your Excel correspond to your account’s object info fields. By default, ArtBinder is preset with a few key object detail fields – title, price, dimensions, medium, year, location, etc. From your “Organization Account” page, you can build upon these details and add additional Custom Fields.
  • For example, if your Excel inventory list includes a column for Category, you will need to add a custom field for “Category.”
  • Once you have adjusted your object info fields to match your column categories, you can go ahead and upload the Excel.
  • Go into your account and click Excel Importer under the More tab in the top navigation bar.
  • This page will prompt you to choose an Excel file to upload. Upload the file you saved on your computer.
  • Next, you are prompted to Assign Fields and match a sample of your data with the corresponding ArtBinder categories. This important step is how our system will make a match between the Excel file you uploaded and all the info in our system.
  • Once you have finished matching, go ahead and click Update Fields.
  • Then, Run the Import at the bottom of the page. This will take a few seconds. When all the objects have uploaded you will be taken to the Bulk Actions sections. 
The next step is to pair images with the objects you just uploaded.
  • If the file names of your images are not the corresponding Inventory IDs, then you can 
manually associate images with the corresponding object in Bulk Actions. From here, all the images appear on the left side with the objects on the right. You can search, sort and filter in each column. 

Note: The Excel Importer only permits one set of Dimensions per object. To add multiple Dimensions, please do so from the Object page.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk