MYFRESHTOOLS
50% OFF
YouTube › Data export

Export YouTube Data to Excel, Tableau, Monday.com and More

Every one of these tools reads a file. Get the file right and the import takes a minute.

Published 18 November 2026 · 7 min read
Quick answer
None of Excel, Tableau or Monday.com connects to YouTube directly, but all of them import files. Export your playlist with YouTube Playlist Export as Excel or CSV for spreadsheets and boards, JSON for Tableau or scripts, or SQL for a database, then import that file into the tool.

You want YouTube data somewhere it's useful: a pivot table in Excel, a chart in Tableau, a content board in Monday.com, a table in your warehouse. Searching for a connector mostly turns up scrapers that break, or paid integration platforms that are overkill for a playlist.

The simpler route: export once to the right file format, then use each tool's own import. This guide shows which format to choose for each tool and how to bring it in cleanly.

Pick a format

Which format each tool wants

DestinationBest formatWhy
ExcelExcel (.xlsx)Opens directly, keeps characters and column types
Google SheetsCSV or ExcelBoth import with File → Import
TableauExcel or CSV (JSON for nested data)Tableau connects to all three as file sources
Monday.comExcel or CSVThe board import maps each column
Notion, AirtableCSVBoth create a database from a CSV
PostgreSQL, MySQL, a warehouseSQL or CSVSQL inserts directly; CSV loads in bulk
Step one

Get the data out of YouTube

By hand, you'd open the playlist, copy each title and link, then visit every video for its views, date and duration. That's minutes per video, and the numbers drift while you work. Scraping the page is faster until YouTube changes its layout, and then your sheet fills with blanks.

Your own channel's private analytics (watch time, impressions) come from YouTube Studio's export; see how to export YouTube Analytics. For playlist and video details, use an exporter built on the official API.

Spreadsheet

Excel

Export as Excel (.xlsx)

Open the file directly. Columns arrive with headers in the first row.

Turn it into a table

Select the data and press Ctrl+T (Cmd+T on Mac) so filters, sorting and formulas follow new rows.

Using a CSV instead?

Use Data → From Text/CSV and choose UTF-8, rather than double-clicking, so non-English titles and emoji display correctly.

From there a pivot table answers most questions in seconds: views by channel, average duration by publish year, or how many videos in a playlist come from each creator.

Dashboards

Tableau

Connect to a file

In Tableau, under Connect, choose Microsoft Excel or Text file and pick your export.

Check data types

Make sure views and likes are numbers, publish date is a date, and duration is a number of seconds if you want to sum or average it.

Refresh with a new export

Save the next export under the same file name and path, then refresh the data source.

Comparing several playlists?

Export them together with Bulk Playlist Export into one combined file, so one Tableau data source covers all of them.
Boards

Monday.com and Notion

  • Monday.com: create a board from an import, upload the Excel or CSV file, and map columns. The title usually becomes the item name; map the link to a Link column so it's clickable.
  • Notion: import the CSV as a database. Each video becomes a page you can tag, assign and comment on.
  • Airtable: create a base from a CSV and set the link column's type to URL.

Add your own status or owner column after the import. A content board works best with one row per video and your workflow on top.

Warehouses

Databases and warehouses

For PostgreSQL or MySQL, a SQL export runs as-is to create rows. For Redshift, BigQuery or Snowflake, load the CSV through each warehouse's bulk loader (for Redshift, upload to S3 and use COPY). Use the video ID as the primary key so repeated loads don't duplicate rows.


The tool

How MyFreshTools helps

What the tool does

YouTube Playlist Export turns one playlist into CSV, Excel, JSON, Markdown, HTML, Text, XML or SQL (or all of them in a ZIP), with durations, view, like and comment counts, publish and added dates, tags, descriptions and thumbnails. It reads the official YouTube API, so the columns stay the same from one export to the next.

Who it's for

  • Analysts building Tableau or Excel dashboards of YouTube content.
  • Teams planning content on Monday.com, Notion or Airtable.
  • Developers loading playlist data into a database.

How to use it

Paste a playlist link

Or connect YouTube (read-only) to pick one of your own playlists, private ones included.

Pick the format

Excel for spreadsheets and boards, JSON for scripts, SQL for databases.

Import it into your tool

Follow the steps for your destination above.

Requirements and limits

  • A free account is needed, and each export costs 1 credit.
  • The free plan exports part of the playlist; paid plans export every video.
  • It exports files. There's no live connector to Tableau, Monday.com or a warehouse.
  • Private playlists need Connect YouTube (read-only) or a temporary switch to Unlisted.
  • It exports metadata, never video or audio files.
In practice

Examples

A Tableau dashboard of a music channel

An analyst exports four playlists together, connects Tableau to the file and charts views against duration. Songs under three minutes clearly outperform, a finding that took one export and one chart.

A content board in Monday.com

A team imports its 'to update' playlist into a new board. Each video becomes an item with an owner, a status and the link, so nobody has to remember which old videos still need new thumbnails.

Loading a warehouse table

A developer loads a CSV export into a staging table each week and merges on video ID. Historical rows stay, new rows are added, and view counts become a time series the BI team can query.

Avoid these

Common mistakes

MistakeWhat goes wrongDo this instead
Double-clicking a CSV into ExcelAccents and emoji turn into symbolsExport .xlsx, or import CSV as UTF-8
Keeping duration as textTableau can't sum or average itConvert to seconds before analysing
Joining on video titleDuplicate or renamed titles break matchesUse the video ID as the key
Overwriting a board with each importYour status and owner columns are lostImport new rows to a staging board, then merge

Frequently asked questions

Yes. Export it as an .xlsx file and open it directly, or export a CSV and import it through Data → From Text/CSV so titles with accents and emoji keep their characters.

Tableau doesn't ship a native YouTube connector. The usual route is to export YouTube data to Excel, CSV or JSON and connect Tableau to that file, or load it into a database Tableau already reads.

Yes. Monday.com imports Excel and CSV files into a new board; each video becomes an item and each column (title, channel, duration, link) becomes a board column you map during import.

Scraping pages is fragile and against YouTube's terms in many cases. An exporter that reads the official YouTube Data API gives you the same fields in a stable format, with no scraping.

A file import is a snapshot. Re-export on a schedule and refresh the data source; in Tableau, point the data source at the same file path so a refresh picks up the new export.

The takeaway

There's no magic connector, and you don't need one. Export once in the format your tool reads, key everything on the video ID, and re-export when you want fresh numbers.

Related MyFreshTools tools