# Export formats for playlists, charts, etc

**URL:** <https://forum.spinitron.com/t/export-formats-for-playlists-charts-etc/174>\
**Category:** 🗂 Management\
**Tags:** export, faq\
**Created:** [June 8, 2020, 12:10am UTC](https://forum.spinitron.com/t/export-formats-for-playlists-charts-etc/174 "2020-06-08T00:10:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![eva](https://forum.spinitron.com/user_avatar/forum.spinitron.com/eva/32/909_2.png) [@eva](https://forum.spinitron.com/u/eva)\
**Post date:** [June 8, 2020, 12:10am UTC](https://forum.spinitron.com/t/export-formats-for-playlists-charts-etc/174/1 "2020-06-08T00:10:37Z")

</div>

# Export formats

When exporting playlists, Spinitron adds heading rows describing the playlist (title, DJ, date, time, etc.) followed by the playlist’s spins in chronological order. There are no such heading rows when you export search or chart results or other reports.

We distinguish between _table formats_ and _text formats_

- In _table formats_ each enabled field of the data is separately and clearly delineated, even when a field has no value. Table formats work for any kind of data: playlists or search, chart or other reports.
- _Text formats_ are mainly intended for exporting playlists. Spins are formatted like natural-language sentences using punctuation and keywords to separate fields. Text formats work best with only the core playlist fields enabled. The checkbox fields (request, new, local, and various artists) are represented by abbreviations **R** , **N** , **L** , and **V/A**. Text format can also work for spin search results, depending on the fields you enable, but won’t work well for other reports.

The HTML formats produce an HTML fragment and not a whole HTML document. You can use the fragment in, for example, a blog or forum, or in an HTML email, etc. You can use either the formatted HTML or the markup.

Rich text fields (e.g. song note, playlist description) require special handling for export. Spinitron exports them with their original formatting only in the HTML formats and converts to plain text for export in the other formats. Export to TSV converts newlines in a rich text field to `\n` .

You can experiment with the formats to see what the formatted data looks like using the “copy-paste” export delivery method and the back button.

## CSV and TSV

- CSV - comma separated values
- TSV - Tab separated values

These _table formats_ export data for import into other computer programs. Both are widely supported. Use whichever works best for you. We tend to prefer TSV because, as Spinitron users, we don’t need CSV (since there are no tab and newline characters our data) and we avoid the tricky gotchas with CSV. If you want to copy a table from Spinitron and paste it into another program, try TSV first.

## Text table (slash separator)

This is a plain-text _table format_ intended for reading by a human. It can be used in plain-text email and similar media. Fields are separated by the three-character sequence `/` , i.e. space slash space. There is room for ambiguity in this format since neither the `/` character nor the `/` sequence is uncommon in playlists ([examples](https://spinitron.com/WZBC/pl/3749251/The-Industrial-Factory#sp-76000230)).

## Plain text

This _text format_ produces a playlist for reading by a human using only plain-text, i.e. without typographic formatting.

## HTML text

This _text format_ is like the plain text format but with the addition of typographic formatting using HTML. Each spin is enclosed in a `<p>` element while the playlist heading fields are `<li>` elements in a `<ul>` list.

## HTML table

This _table format_ outputs your playlist or report a an HTML table.

## Microsoft Excel

This _table format_ is suitable for any data. Many computer programs accept date in Excel file format.

---

<div class="post-metadata">

**Author:** ![jackgray](https://forum.spinitron.com/letter_avatar_proxy/v4/letter/j/a4c791/32.png) [@jackgray](https://forum.spinitron.com/u/jackgray)\
**Post date:** [December 29, 2021, 4:19pm UTC](https://forum.spinitron.com/t/export-formats-for-playlists-charts-etc/174/2 "2021-12-29T16:19:01Z")

</div>

I did it easily with musconvtool, so I recommend it.
