Crownnote stands in solidarity with the campaign #TheShowMustBePaused, during which the music industry is taking a pause following the deaths of George Floyd, Breonna Taylor, Ahmaud Arbery, and others in the latest events in a long-ongoing series of systemic racism and police brutality. While Crownnote is not a company and makes no money on its own, we encourage you to make individual donations, if you are financially able, toward causes that support Black voices, in the music industry and beyond. We also ask you to reflect on the fact that many of the artists, songwriters, producers, label executives, and industry employees that bring you the music you chart here each week have Black roots, as do genres like country, house, rock, jazz, R&B, and hip-hop that grace our charts each week. Through our Twitter account, we will cease all promotional activity of our own site this week, choosing instead to amplify Black voices and organizations that share in the pursuit of support, empowerment, and equality; and we ask that you will do the same. Thank you.

You are here

How to import a chart from a spreadsheet

Importing a new chart from a spreadsheet (Google Drive, Microsoft Excel, etc.) takes a few simple steps to format properly, but will result in the ability to quickly import your charts.

First, create a new chart, writing your title and body content as usual. Include a unique Chart ID (a format such as MMDDYY-username is recommended to ensure a unique ID), then publish the chart. The chart will publish with zero songs.

Your spreadsheet will be used to make two imports: first, importing any songs that aren't yet on the site, then importing the chart positions associated with each song on your chart.

Formatting your spreadsheet

The easiest way to efficiently create a import-friendly spreadsheet is to copy your data into this Google spreadsheet. (Note: you do not need to request edit access on this spreadsheet; instead, save a copy of the spreadsheet to your personal Google Drive account, then edit your copy.) Make a copy of the spreadsheet into your own Google Drive and add your own artists into column C, song titles into column F, and Chart ID (see below) into cell A2. Remove any extra rows, and if you need additional rows, make sure the columns' formulas match below row 100.

If you choose to edit your pre-existing spreadsheet, it will need the following columns, labeled with the designated column heading.

  • Song Title: The name of the song, without any mention of featured artists, radio edit designation, etc.
  • Artist: The name(s) of the artist(s) (if multiple, separate with a semicolon, e.g. Zara Larsson; MNEK)
  • Featured: (optional) The name(s) of any featured artist(s) (if multiple, separate with a semicolon, e.g. Matthew Koma; Miriam Bryant)
  • The Position at which the song charted
  • A Chart ID that's unique to your chart – MMDDYYYY-username format recommended
  • A Slug that uses the following formula: =SUBSTITUTE(REGEXREPLACE(REGEXREPLACE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER( artist cell & "-" & featured artist cell & "-" & song title cell), " ","-"), "'",""), "+-",""), "[éè]","e"), "[][.,\/#?!$%\^&\*;:{}=\_`’~()]",""), "--", "-") Replace the artist/featured/title cells with the corresponding cells – if they're in columns C, D, and E, replace with C2, D2, and E2 (where 2 is the row number).
  • Album: (optional) The album title associated with the song (note: you'll need to edit the Album after publishing to connect it to an artist, add artwork, etc.)

Make sure that your columns are formatted with standard capitalization and without any additional characters (so One Direction, not ONE DIRECTION; Story Of My Life, not "Story Of My Life" or STORY OF MY LIFE). Any additional columns will not be imported, but they can be left in your spreadsheet.

Once your spreadsheet is fully formatted, export the spreadsheet as a .csv file. In Google Sheets, click File, then Download as: Comma-separated values (.csv, current sheet). In Microsoft Excel, click Save As and select CSV (Comma delimited) (*.csv).

Importing songs

To import new songs, use the Song importer by clicking this link or selecting the Import link from the menu, then selecting the Song importer. Choose your .csv file, then click Import. Any new Song nodes will be added.

Importing chart positions

(RememberBefore you can import chart positions, you'll need to create a chart with the Chart ID field filled out and matching the column in your spreadsheet.) After adding all of your songs and creating a chart with your Chart ID included, use the Chart position importer by clicking this link or by selecting the Import link from the menu, then selecting the Chart position importer. Choose your .csv file, then click Import. Chart positions and songs will be connected to your pre-existing chart.