Exporting Content From GraphCMS to CSV in 3 Simple Steps

In this post, we'll take a look at how to export content from GraphCMS using the Content API and a JSON to CSV converter.

Jamie Barton
Jamie Barton

Exporting content from GraphCMS to CSV needn’t be a complex task.

It is often helpful to fetch content from your CMS to analyze marketing plans, perform an SEO audit, or evaluate current content. GraphCMS makes it easy to fetch your content with the API Playground in a format that you can easily convert to CSV, and more.

GraphCMS uses the JSON format as it’s response type for any API requests. The free online JSON to CSV Converter is an excellent way to convert the API standard “JSON” to CSV.

  1. Query (optionally filter results) using the API Playground
  2. Copy JSON result to your clipboard
  3. Paste JSON into JSON to CSV and “Download Result” as CSV

Teams do not need to write custom integration logic to fetch and sync content with other systems. With the JSON to CSV Converter, teams have full control over what data is returning, whether or not to use filters, and what the final converted format should be

Let’s explore fetching data as JSON, and filtering it, as well as exploring the UI for converting JSON to CSV.

Fetching Content as JSONAnchor

Below we will query for “episodes”, and fetch only the fields I want inside my CSV.

fetching content from graphcms (1).png

The default result size of results returned by queries fetching multiple entries is 100. You can provide a maximum of 1000 to the first, or last arguments. If you need to fetch more results, you can page through data using the pagination filters.

Filtering ContentAnchor

If you only require a certain subset of content entries, add filters or pagination to the GraphQL query, and use the result to convert to CSV.

In the example below, we’ll fetch “episodes” where the position is within the range 1–10. We can use the gte and lte filters for this.

filtering content in graphcms (1).png

Convert to CSVAnchor

Follow the steps to use the JSON to CSV Converter and you will be able to view the CSV results in the browser, or download as a file with a custom filename.

JSOn to CSV converter (1).png

That’s it! You can now fetch as much content from the Content API, in whatever format you require, and convert to CSV.

If you are looking to do the opposite, and import CSV data into GraphCMS, Jesse Martin posted on how you can use a free to use low-code approach to do just tha

It's Easy To Get Started

GraphCMS plans are flexibly suited to accommodate your growth. Get started for free, or request a demo to discuss larger projects with more complex needs