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.