microCMS
Documentation
  • Pricing
  • Blog
  • FAQ
  • Contact
  • Sign In
  • Get started for free
Navigation
Tutorial
Next.js
  • Integration with Next.js
  • Getting Started with App Router
  • Tutorial (App Router)
  • Getting Started with Pages Router
  • Tutorial (Pages Router)
Astro
  • Getting Started
  • Integration with Astro
  • Tutorial
Nuxt
  • Integration with Nuxt
  • Getting Started
  • Tutorial
Gatsby
  • Integration with Gatsby
  • Getting Started
  • Tutorial
JavaScript
  • Integration with JavaScript
  • Getting Started (Browser)
  • Getting Started (Server)
PHP
  • Integration with PHP
  • Getting Started
Ruby
  • Integration with Ruby
  • Getting Started
Go
  • Integration with Go
  • Getting Started with microCMS
Manual
  • Introduction
Account & Login
  • Account Registration
  • Login
  • Email Address Authentication
Services
  • Creating a Service
  • Service Configuration
  • Template
  • Service Deletion
Payment
  • Change of Pricing Plan
  • Registering and Changing Payment Methods
API
  • Creating and Managing APIs
  • API Settings
  • Export/Import of API Schema
Fields
  • Text Field
  • Text Area
  • Image
  • Multiple Images
  • Date
  • Boolean
  • Selectable Field
  • Content Reference
  • Multiple Content References
  • Number
  • File
  • Extended Field
  • Repetition
  • Custom
Contents
  • CSV Export of Content
  • Content Creation
  • Content Editing
  • Content Management
  • View
  • Content Status
  • Custom Status
  • Setting the Content ID
  • Automatically Assigned Values for Content
  • CSV Import of Content
  • API Preview
  • Examples of Using Query Parameters with API Preview
  • Integration Methods by Rendering Type
  • Screen Preview
  • Setting Up Webhooks for Content
Rich Editor
  • How to Use the Rich Editor
  • Rich Editor WRITE API
  • How to Use the Old Rich Editor
Reviews
  • Review
  • AI Review
Media
  • Media Management
  • Changing Media Filters and Display Order
  • Media Tag Configuration
  • Setting Up Media Webhooks
  • Custom Domain Settings for Media
Permission Management
  • Member Management
  • Roles (Permission Management in the Admin Panel)
Environments
  • Multiple Environments (Development Environment)
  • Merging API Settings Between Environments
Connection
  • Amazon S3 Integration
Logs
  • Audit Log
  • Data Transfer Volume
Security
  • Content Update History
  • IP Restrictions for Management Dashboard
  • IP Restrictions for APIs
Authentication
  • Setting Up Two-Factor Authentication
  • Mandatory Two-Factor Authentication
  • Single Sign-On
Specifications & Limitations
  • Recommended Environment
  • Limitations / Precautions
Content API
  • What is the Content API?
Basic Operations
  • GET /api/v1/{endpoint}
  • GET /api/v1/{endpoint}/{content_id}
  • POST /api/v1/{endpoint}
  • PUT /api/v1/{endpoint}/{content_id}
  • PATCH /api/v1/{endpoint}/{content_id}
  • DELETE /api/v1/{endpoint}/{content_id}
API Keys
  • API Key (API Authentication and Authorization Management)
  • Migration from the Old API (X-API-KEY, etc.)
Responses & Error Handling
  • Response format for each field in the GET API
  • Specifying Query Parameters in the GET API
  • Error Responses of the Content API
Management API (Beta)
  • POST /api/v1/roles
  • DELETE /api/v1/roles/{role_id}
  • GET /api/v1/roles/{role_id}
  • PATCH /api/v1/roles/{role_id}
  • GET /api/v1/roles
  • What is the Management API?
Content Operations
  • PUT /api/v1/contents/{endpoint}/{content_id}/reservation
  • GET /api/v1/contents/{endpoint}
  • GET /api/v1/contents/{endpoint}/{content_id}
  • PATCH /api/v1/contents/{endpoint}/{content_id}/status
  • PATCH /api/v1/contents/{endpoint}/{content_id}/createdBy
Media Operations
  • GET /api/v2/media
  • GET /api/v1/media
  • POST /api/v1/media
  • DELETE /api/v2/media
Member Operations
  • PATCH /api/v1/members/{member_id}
  • GET /api/v1/members
  • GET /api/v1/members/{member_id}
API Operations
  • POST /api/v1/apis
  • GET /api/v1/apis
  • GET /api/v1/apis/{endpoint}
Service Operations
  • GET /api/v1/service
Responses & Error Handling
  • Management API Error Responses
Image API
  • What is the Image API?
Parameters
  • Image Size
  • Quality
  • Resolution and Screen Size
  • Format
  • Text
  • Border
  • Padding
  • Shape
  • Download
  • Watermark
MCP Server
  • microCMS MCP
  • microCMS Document MCP Server
  • Top
  • Manual

CSV Import of Content

Last updated: 2026/06/23

This is a feature that allows you to bulk register content from a CSV file.
It can be used when migrating content from other CMSs or when registering content in bulk.

Content Registration Procedure

For New Registration

1: Create any API you like.



2: Click the [Import] button.



3: Click the link for the sample CSV file (input-format.csv) to download it.

The sample CSV file (input-format.csv) contains sample values based on the types of fields that are registered. Please use it during the import process.

Information
  • The downloadable sample CSV file (input-format.csv) is encoded in UTF-8 (without BOM). Please save it in the same format after editing.
  • When opening the sample file in your application, the CSV file may become garbled. For solutions to garbled text, please refer to the help article "The sample file for CSV import appears garbled. What should I do?".


4: Enter the content you want to register and update/save the CSV file.



5: Click the [Select File] button to load the CSV file you want to register.



6: Choose the status of the content to be imported (Draft or Published).

Information

If you are using the role feature, the selectable items will vary depending on the granted "content" permissions.

  • Draft: This option can be selected if you have the permission to save new content as a draft.
  • Published: This option can be selected if you have the permission to publish new content.


7: Click the [Start Import of ◯ Items] button.



8: The import process will be executed. It may take a few minutes until the registration is complete.

9: If the process completes successfully, a message saying "Import Completed" will be displayed, and the content registration will be finished. If an error is displayed, please check the content of the error message.

Adding in Between

1: Select any API
2: Click the [Import and Add] button



3: After this, the process will follow the same flow as steps 3 and beyond for new registrations.

Using Exported CSV Files

You can register content using the CSV file exported from the content CSV export.
For the method of exporting CSV files, please refer to "Content CSV Export".

1: Remove and save the common columns except for the id from the exported CSV file.



2: After this, the process will follow the same flow as steps 5 and beyond for new registrations.

Caution

When importing an exported CSV file, there may be cases where the import fails, such as the following:

  • When the CSV contains fields or value formats that are not supported by the CSV import
  • When the export was performed with insufficient permissions, resulting in some field values being inaccessible
  • When the CSV includes two rows for the same content, one published (PUBLISH) and one in draft (DRAFT)
  • When importing directly into an API with existing content, causing duplication of content IDs or fields with unique constraints

Input Format Rules

  • Only list format APIs can be used.
  • Please import CSV files with character encoding UTF-8 (without BOM).

Supported Fields and Their Input Formats

Field Name

Input Format

Input Example (*1)

Text Field

Any text

Text

Text Area

Any text

Enter multiple lines of text

Hello

Rich Editor

HTML string (*2)

<p>Enter multiple lines of text<br />Hello</p>

Old Rich Editor

Any text (*3)

Enter multiple lines of text

Hello

Image

URL of the image distributed by microCMS (*4)

https://images.microcms-assets.io/assets/xxxx/yyyy/sample.png

Multiple Images

Specify URLs of images distributed by microCMS, separated by commas (*5)

https://images.microcms-assets.io/assets/xxxx/yyyy/sample1.png,
https://images.microcms-assets.io/assets/xxxx/yyyy/sample2.png

Date and Time

ISO format (ISO 8601)

2024-01-01T00:00:00Z

Boolean

TRUE or FALSE

TRUE

Select Field

Elements set as options

Option 1

Select Field (Multiple Selection)

Specify elements set as options, separated by commas

Option 1,Option 2

Content Reference

Content ID of the referenced content

category01

Multiple Content References

Specify Content IDs of the referenced content, separated by commas

category01,category02

Number

Number

100

Custom

JSON (only registerable keys) (*7)

{"fieldId":"xxxxxxxx","some_value": "xxxxxxxx"}

Repeating

JSON array (only registerable keys) (*7)

[{"fieldId":"xxxxxxxx","some_value": "xxxxxxxx"},{"fieldId":"xxxxxxxx","some_value": "xxxxxxxx"}]

File (*6)

URL of the file distributed by microCMS

https://files.microcms-assets.io/assets/xxxx/yyyy/manual.pdf

Extended Field

JSON (only registerable keys) (*7)

{"id":"xxxxxxxx", "title":"xxxxxxxx", "description":"xxxxxxxx", "imageUrl":"https://images.microcms-assets.io/assets/xxxxxxxx/yyyyyyyy/sample1.png", "updatedAt":"2025-01-01T00:00:00.000Z","data":{"id": "123"}}

  • (*1) When editing a CSV file from a text editor, you need to enclose input values that contain line breaks or commas (,) in double quotes (").
  • (*2) Only HTML within the range supported by the rich editor can be submitted. Please note that not all HTML syntax is supported. The available formats are the same as those in the WRITE API for the rich editor.
  • (*3) Only plain text registration is possible. Registration with text formatting is not allowed.
  • (*4) If you are using custom domain settings for media, you can specify the URL of the custom domain as well. This also applies to multiple images and files.
  • (*5) You can import up to 100 images per field.
  • (*6) The Hobby plan is excluded.
  • (*7) The JSON format is specified in the same way as the WRITE API. Note that due to the specifications of the CSV format, when editing from a text editor, you need to register " as "".

Constraints

  • The maximum number of contents that can be imported at once varies by plan. For more details, please check the pricing page.

Import Errors

During content import, the content is validated based on the rules set for each input field, just like when registering data from the management screen.
If there is even one error in the content to be imported, the process will be halted at that point, and the content will not be added.

Common Error Examples

  • Required fields are set to ON but not filled in
  • The format of the content ID is incorrect

Errors Specific to CSV Import

In addition to the validation of each field, errors will also occur if there are issues with the data in the CSV file, such as the following:

  • The number of columns in the CSV does not match the number of fields in the API schema
  • The number of content items to be imported exceeds the plan's limit

Other Specifications

  • Content ID can be registered as blank (duplicates are not allowed).
  • The order of contents will be registered as per the appearance of the CSV file (the content on the second line will be displayed at the top of the Administration console).
  • Webhook will not be notified for content addition via CSV Import.

Reference Information

In addition to CSV import, there is also the option to register content in bulk using the WRITE API.
We have detailed the features and distinctions of each method in the blog post below, so please take a look.

microCMSに大量コンテンツを登録する方法まとめ | microCMSブログ
https://blog.microcms.io/how-to-register-a-large-amount-of-content

Contents

  • Content Registration Procedure
  • For New Registration
  • Adding in Between
  • Using Exported CSV Files
  • Input Format Rules
  • Supported Fields and Their Input Formats
  • Constraints
  • Import Errors
  • Common Error Examples
  • Errors Specific to CSV Import
  • Other Specifications
  • Reference Information
  • Company
  • Legal Notice
  • Terms of Service
  • Privacy Policy

Copyright © microcms.io All rights reserved.