How to create a CSV file for bulk booking from Excel
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
- Select File and Save As.
- Change the file type: Select CSV UTF-8 for saving in UTF-8 or CSV for saving in Shift_jis.
- Click Save.
How to set the date
- Select the cell you want to change the date setting in and click Format Cell.
- 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.