What format should the imported file be?

All import files, other than the Calendar file, should be a tab delimited text file.

If you are starting with an Excel file, it is easy to create a tab delimited text file.

  • Be sure to be viewing the tab containing the data you want to import (if the excel file has more than one tab),
  • Go to File/Save As…,
  • Choose Tab Delimited Text (.txt) file from the list of file formats.
  • Depending on the version of Excel you are using, it may you that the workbook cannot be saved because it contains multiple sheets. If you get the message, click the Save Active Sheet button
  • Excel will assume you want to name the file the same as your Excel workbook, but with the .TXT extension.

Once you have created the .txt file, upload it.

Categories: imports, file formats, text files