Google Docs and Spreadsheets

Google drive

Copy & Paste

• Microsoft Excel --> Google Spreadsheet:
  • columns & rows: Copy & Paste is ok
• Plain text --> Google Spreadsheet: ok
  • columns: Tab separated columns --> Google Spreadsheet: ok
  • rows: Enter separated rows --> Google Spreadsheet: ok
• Plain text --> Microsoft Excel: ok
  • columns: Tab separated columns --> Microsoft Excel: ok
  • rows: Enter separated rows --> Microsoft Excel: ok
• Microsoft Excel --> Table of Google Document:
  • columns & rows: Copy & Paste is ok
• Plain text --> Table of Google Document: fail Suggest you copy to Microsoft Excel first and then copy paste to Google Document from Microsoft Excel.
  • columns: Tab separated columns --> Table of Google Document: fail
  • rows: Enter separated rows --> Table of Google Document: fail
• Plain text --> Microsoft Excel: ok
  • columns: Tab separated columns --> Microsoft Excel: ok
  • rows: Enter separated rows --> Microsoft Excel: ok
• How-to Create and Copy a Table in Google Mail (Gmail) from Excel - YouTube

Google spreadsheet

利用Google spreadsheet的函式，分析及統計可複選的問卷題目結果。

MovableType

MT 3.x

check Post via Google Docs

MT 2.x

• API: MovableType API
• URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi
  • If you met the HTTP 503 code(Service Unavailable), you can switch the URL from domain name to IP address.
• Blog ID/Title
  • Blog ID is not work!
  • Blog title: It's Case-sensitive and was not support Chinese.