Tips for a Successful File Import

Using the import feature is for strong excel users as the file contents is placed directly in the back end table. The following are tips to allow for a successful import.

Avoid special characters - once your file is ready to send - do a "Control F" - find, to search for special characters that should be removed.

Special Characters to avoid

  • : colon

  • ; semicolon

  • " quotation marks

  • ' apostrophe

  • , comma

  • . period

  • ? question mark

  • / forward slash

  • ` grave accent

  • ! exclamation mark

  • # number sign

  • $ dollar sign

  • % percent sign

  • & ampersand

  • * asterisk (this cannot be searched for)

  • () round brackets

  • _ underscore

  • - hyphen-minus

  • + plus sign

  • = equals sign

  • {} curly brackets

  • [] square brackets

  • | vertical bar

Remove Duplicates using the excel Remove Duplicates function

Remove any stray characters

Go to the last line of entries and scroll down and across (highlighting all and remove extra rows – in case there are random characters there that should not be), perform this on both the bottom row and last column

View in Notepad for extra spaces which may have been inserted

Verify that the headers have not been altered in any way (as final step you may want to replace the existing headers with a fresh set from the sample csv on CAS)

Last updated

Was this helpful?