Cleverscript/Saving your spreadsheet

This page has instructions for how to convert your spreadsheet into tab-delimited format. The conversion should only need to be done once. After that, the file ending will be tsv, csv or txt. Where possible, the instructions also tell you how to save as UTF-8 or UTF-16 (for Excel which doesn’t support UTF-8). This is necessary if your spreadsheet contains any non-English characters.

If the instructions below aren’t correct, please let us know which software and version you are using and we will try to fix it.

Open Office 3 Calc Microsoft Excel Google Docs Spreadsheet
 * 1) From the File menu, choose Save As
 * 2) Change the  File Type  to  Text CSV
 * 3) Check the  Edit Filter Settings  box below that
 * 4) Click Save
 * 5) Choose Replace if it asks you
 * 6) Choose Keep Current Format if it asks you
 * 7) Under Character set choose UTF-8 if needed
 * 8) Change the  Field delimiter  to  {Tab}
 * 9) Click OK
 * 1) From the File menu, choose Save As
 * 2) Change the  Save As Type  to  Text (tab delimited)  or  Unicode  if it contains non-English characters
 * 3) Click Save
 * 4) If it asks about only saving the current worksheet click OK
 * 5) If you saved it as Unicode, choose the  UTF-16  encoding when uploading
 * 1) From the Google Docs File menu, select  Download as  then  Text (current sheet).
 * 2) Your tab-delimited text file will be displayed in a new window, go to this window
 * 3) From your browser’s File menu, select Save As or Save File As
 * 4) Name your file, specifying the file type as a Text File (*.txt) if possible
 * 5) Click Save