Spreadsheets in Reprtoir have a set of default columns that are pre-loaded.

In this article we will go over each and every one of these columns explaining how to fill them in and what they are used for.

Reprtoir spreadsheet mandatory rules

There are only a couple of simple rules that must be respected when importing metadata through our spreadsheet system.

Commas and spaces after the commas

Multiple elements inside the same cell must be separated by commas and spaces after the commas. For example let's say you have two main artists for a given track. The correct way to write them down in the Track Main Artists column is by typing "Artist 1, Artist 2", and not "Artist 1,Artist 2, or "Artist 1 / Artist 2". This applies to every single column in which you can input various elements found inside of your Reprtoir spreadsheets.

Incremental numbering for track positions within albums

All track positions must be incremental inside an album or you will get an error upon validating your spreadsheet.

Selecting pre-existing values inside of columns

The following columns contain pre-existing values:

  • Track Catalog
  • Track Title Language
  • Track Recording Type
  • Track Public Domain
  • Album Catalog
  • Album Title Language

You can easily recognise these columns because they have a little upside down triangle on the right of their cells. 

Users cannot input custom data or values inside of these columns. They must select one of the values these cells have available.

For example:

  • The column Track Catalog will only allow you to choose from the different catalogs you created in your account.
  • The column Track Title Language will only allow you to input pre-existing languages

The reason behind this is that we need certain bits of data to be spelled in a very specific way to be able to match your metadata correctly inside of your account.

Mandatory columns

Every column whose header contains a little star (" * ") must contain at least one value. These are mandatory columns. If data in these columns go missing, users will not be able to import their spreadsheets and they will get an error during the automatic validation phase.

Here are the list of mandatory columns:

  • Track Catalog *
  • Track Position *
  • Track Tile *
  • Track Main Artists *
  • Album Catalog *
  • Album Title *
  • Album Main Artist *

Reprtoir’s spreadsheet default columns and how to fill them up

Track Catalog * (pre-selected values)

Any Catalog created within a user's account can be loaded up in the cells of the Track Catalog column. At least on catalog must be assigned on the track level. This column contains pre-selected values. 

Track Position *

As stated above, track positions must be incremental inside an album.

Track Tile *

Contains your track's name

Track Subtitle

Elements that are part of the Track Title but that are in between brackets can be written inside the Track Subtitle column.
Ex: Thriller (Dubstep Remix). "Thriller" goes in Track Title and "Dubstep Remix" goes in Track Subtitle.
Inputing metadata in the Subtitle column helps to not only clean up your metadata but also to comply with rules imposed by certain digital music stores.

Track Title Language (pre-selected value)

The Track Title language is the language in which the track title is written in, not the the language of the track's lyrics.

Track Main Artists *

Is to be filled with your tracks main artists

Track Featured Artists

If a track has a featured artist, this is the column in which you will enter the featured artist's name.
In this field, you should not enter the mentions "Feat." or "Featuring" or anything else for that matter. Only the featured artist's name should be present here.

Track Covered Artists

If your recording is a cover, karaoke version or a soundalike, you need to enter the original artist's name in Track Covered Artists column. For example, if your band is called "Pink Panther" and you're doing a cover of the song "Purple Rain", you will write the artist name "Prince" inside the column Track Covered Artists.

Track Writers

Contains you tracks’ writers, authors and arrangers.

Track Publishers

Contains your tracks’ publishers

Track ISRC

Everything attached. No spaces, no hyphens, no nothing besides the ISRC code itself.
Ex: US0W61864783

Track Recording Type (pre-selected value)

Chose the type of recording between Soundalike, Original, Cover and Rerecord.

Track Public Domain (pre-selected value)

Chose whether your recording is in the public domain. The public domain status of a recording or of a work is country specific. We have yet to improve how this works in Reprtoir. For the time being, the public domain option in your account refers to the recordings (not the works), and you can choose the status according to your country of origin.

Album Catalog * (pre-selected value)

In the same way you can assign tracks to a specific catalogue, you can also do the same with albums. Both Track Catalog and Album Catalog value can be different. For example, let's say you are importing Track 01 who is originally from sub-label X. You will assign the Track Catalog to sub-label X. But let's also say that Track 01 is part of an album licensed by sub-label Y. In this case you would assign the Album Catalog to sub-label Y.

Album Title *

Is to be filled with your album's name. 

Album Subtitle

Album Subtitles work in exactly the same way as your Track Subtitles: if your album contains any descriptive elements that are in between brackets, you can put them in the Album Subtitle column to comply with rules imposed by certain digital music stores.

Album Title Language (pre-selected)

The Album Title language is the language in which the album title is written in.

Album Main Artist *

Is to be filled with your album's main artist names.

Album Featured Artists

If an album has a featured artist, this is the column in which you will enter the featured artist's name.
In this field, you should not enter the mentions "Feat." or "Featuring" or anything else for that matter. Only the featured artist's name should be present here.

Album UPC

Everything attached. No spaces, no hyphens, no nothing.
Ex: 885487503783

Album Label Reference

This is the reference number of your albums. Either you already have an established set of reference numbers and you can import them in your Reprtoir account, or you can start from scratch.

Did this answer your question?