When Your Collection Outgrows a Spreadsheet: Excel or Art Collection Management Software?

An up-to-date inventory for your insurance company. The provenance of a painting for a loan request. A new location after a work has been moved. And where was that certificate again?
A collection does not grow only in the number of artworks it contains. With every artwork, the amount of information surrounding it grows as well: images, invoices, condition reports, valuations, locations, loans, and correspondence.
For many collections, Excel is a sensible place to start. A well-maintained spreadsheet can work for a long time.
Excel documents your collection. ARTBUTLER helps you work with it.
With Excel, you have to develop the right spreadsheet and filing structure yourself. ARTBUTLER already provides a structure designed specifically for art collection management.
That is why the size of a collection alone does not determine when Excel reaches its limits. What matters is what you want to do with the data.

A Collection Is More Than Its Artworks

A new acquisition can be quickly added to a spreadsheet: artist, title, year, medium, dimensions, purchase price. Perhaps the location and inventory number are added as well.
But an artwork has a life beyond its spreadsheet row.
It comes with images, invoices, and certificates. Its provenance is expanded, its condition documented, and its value reassessed. Today it hangs in the living room, tomorrow in the office, and later perhaps in an exhibition.
The longer a collection exists, the more closely this information becomes interconnected. What started as an inventory becomes a network of information.

“Could You Please Send Us an Up-to-Date List?”

A seemingly simple request can create a surprising amount of work.
The insurance company needs current valuations. A museum requests several works for an exhibition. A selection needs to be put together for a presentation.
If artwork data, images, and documents are spread across spreadsheets, folders, and different files, the search begins: Which list is the current one? Where is the high-resolution image? Has the new insurance value already been entered? Which version was sent last?
In ARTBUTLER, artwork data, images, and documents are linked. Lists and overviews are generated from the current data.
The real advantage isn’t simply being able to organize things more neatly. It’s that information doesn’t have to be gathered from scratch every time a new request comes in.

Where Is the Artwork, Anyway?

For a private collection, this question might involve several homes, an office, and a storage facility. Corporate collections may also include different branches, floors, and rooms. Institutional collections have to manage exhibitions and loans as well.
A spreadsheet can record a location. Things become more difficult when artworks regularly move or several people need to work with the same information.
At that point, it’s no longer just about storing data. You want to use it effectively: find all works by a particular artist, select works from a specific period, or put together a group for a particular purpose.
Art collection management software is designed to represent these connections from the outset. ARTBUTLER brings all the information together in one place and makes it accessible through search and filters.
At first glance, this may sound like data management. In everyday use, it’s really about something else: less time searching, more time working with your collection.

Enter Once, Use Again and Again

Artwork data rarely stays in the archive. It needs to be used.
For insurance, loans, and exhibitions. For presentations, communication with experts, or your own website.
With Excel, this often means creating new files, copying data, and reformatting information. Before long, multiple versions of the same collection can exist.
ARTBUTLER, by contrast, uses your maintained artwork data as a shared foundation. From this data, you can create lists and PDFs, share or present artworks digitally. If you use an ARTBUTLER website, selected artworks can also be published directly from the database.
Information stays up to date in one place and can be used in many different ways.

Typical Tasks Compared: Excel vs. Artbutler
 

When Does an Artwork List Become Collection Management?

If you have built your own system over time, you probably know every column and every detail by heart. So the more important question is not: How many artworks does the collection contain?
It is: 
- How often do you have to search for and compile information?
- Do you repeatedly create new files for insurance, loans, or presentations?
- Is the same data being maintained in multiple places?
- Do several people work with the collection?
- Do you want to do more than document your collection—you also want to present and share it?
As these requirements grow, the task changes. An artwork list becomes collection management.
With Excel, users have to decide for themselves how to build their system: Which information belongs together? Where should documents be stored? And how will they be found again later?
ARTBUTLER already provides this art-specific structure.

What About Your Existing Excel Spreadsheet?

If you have built up a collection over many years, you probably do not want to start from scratch.
In most cases, you don’t have to. Existing data can often be transferred to ARTBUTLER. The best migration approach depends on the individual collection, and the ARTBUTLER team can support you throughout the transition.
Your previous work does not get lost. Instead, it gains a structure that can grow with your collection and its future requirements.
Perhaps, then, the decisive moment is not when an Excel file finally becomes too complicated to manage.
It’s the moment when your collection wants to do more with its data than simply store it.

Good Collection Management Grows With Your Collection

Collecting art also means taking responsibility for information: for provenance and history, for documents and valuations, for locations and changes.
Sometimes this knowledge becomes important across generations, for example when a private collection is passed on. In other cases, several people work with the same data at the same time, as in a corporate collection. Institutional collections, meanwhile, need to organize documentation, research, and loan management over the long term.
The right software shouldn’t make this work more complicated. It should make sure that information is available wherever and whenever it is needed.

You Currently Manage Your Collection with Excel and Wondering Whether ARTBUTLER Could Be Right for You?

We would be happy to show you how you can continue managing your existing collection with ARTBUTLER—and what possibilities this opens up for your day-to-day work.
And whether you are an artist, managing an estate, or working as a gallery, many of these questions arise in similar ways. ARTBUTLER is designed to support these areas of work as well.

→ Learn more about ARTBUTLER
→ Try ARTBUTLER NEXT with no obligation