How to create a CSV file for bulk booking from Excel

Update date: 2020/06/11
This article has not yet been translated in the language shown. It is displayed in machine translation, but it may be incorrect.

About line breaks in cells

When editing directly in a text editor, line breaks must be enclosed in "". If you edit in Excel, you don't need to enclose a line break in a cell with "" because it will be converted automatically when CSV is output.

How to save your tweets in UTF-8 or Shift_JIS

  1. Select File and Save As.
  2. Change the file type: Select CSV UTF-8 for saving in UTF-8 or CSV for saving in Shift_jis.
  3. Click Save.

How to set the date

  1. Select the cell you want to change the date setting in and click Format Cell.
  2. Enter yyyy/mm/dd hh:mm as the format and press OK.

Functions such as the LEN function

LEN function etc. will be converted to text when exporting to CSV.

Please be sure to check your tweets before you register them, as they will be displayed on the confirmation screen after upload.

Over 700,000 accounts!

An indispensable tool
for Twitter marketing

Just login with your Twitter account to start viewing analytics,
scheduling posts, and managing your followers right away.