ArtHandler

Catalogue your artwork.

Download ArtHandler on the Mac App Store.

CSV Export

Some users were asking for the possibility to export their ArtHandler database to a comma-separated values (CSV) file. CSV files are commonly used to move tabular data between different applications.

ArtHandler 1.6.2 includes this functionality. Go to File ‣ Export To ‣ CSV… to export your database.

The resulting CSV file uses semicolons as separator, has quoted (with double quotes) string fields, and is UTF-8 encoded. You can open it in any text editor or in your favourite spreadsheet application on any system. The raw file looks like this:

Artist;Title;Media;Year;Height;Width;Depth;Duration;Location;Price;Currency;Sold
"Nicole Eisenman";"Draw a picture, then make it bleed";"Watercolor and pencil on paper";2005;45;25.5;;;"Private collection";;"EUR";"NO"
"Laura Knight";"Ruby Loftus Screwing a Breech Ring";"Oil on canvas";1943;86.36;101.6;;;"Imperial War Museum, London";;"EUR";"NO"
"Artemisia Gentileschi";"Self-Portrait as the Allegory of Painting";"Oil on canvas";1639;96.52;73.66;;;"Royal Collection";;"EUR";"NO"

Import into Apple Numbers

Just open the CSV file in Numbers and you are done.

Import CSV from ArtHandler into Apple Numbers.

Import into Google Sheets

When importing a CSV file from ArtHandler into Google Sheets, please select Custom as Separator Character and enter a semicolon  ;  as custom separator character.

Import CSV from ArtHandler into Google Sheets.

Import into Microsoft Excel

The exported dataset is encoded in UTF-8. While UTF-8 is the standard for multilingual character encodings, it is not correctly interpreted by Microsoft Excel on a Mac. Users of Excel that have non-latin characters or Emojis in any field of their ArtHandler database must convert the UTF-8 to UTF-16 so the file can be imported correctly.