Opening a CSV file in a spreadsheet application may place all fields in the first cell of the application. If you choose to populate the text file in Microsoft Excel or a similar application, you will need to follow that applications' text file import process.
Here are some links that may help, please understand that your particular instructions will vary depending on your operating system, your spreadsheet application and the version thereof.
- MS Excel 2003: http://office.microsoft.com/en-us/excel-help/import-or-export-text-files-HP001130599.aspx
- MS Excel 2007: http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx
- MS Excel 2010: http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-files-HP010342598.aspx
- MS Access 2003: http://office.microsoft.com/en-us/access-help/import-or-link-data-and-objects-HP005187610.aspx
- MS Access 2007: http://office.microsoft.com/en-us/access-help/import-or-link-to-data-in-a-text-file-HA001232227.aspx
- MS Access 2013: http://office.microsoft.com/en-us/access-help/import-data-into-an-access-database-HA102840199.aspx
- Apache OpenOffice: https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Files/How_do_I_open_a_tab-delimited_file_in_OpenOffice.org_Spreadsheet%3F_What_if_I_have_a_different_type_of_delimiter%3F
- Libre Office: https://help.libreoffice.org/Calc/Importing_and_Exporting_Text_Files
For submission, the only acceptable file is a text/csv file, semi-colon delimited, double-quoted on all fields. Please ensure that the spreadsheet software you use can export your data to such a file.
Comments