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 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 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.