HelpDocs

Maurice Nataf
Written by Maurice Nataf

Upload an Excel file

This article explains the process in order to successfully upload an Excel file.


Accepted File Types 

You can upload files in the following formats: .xlsx, .csv, .txt


Video on how to create a contact list and importing your file



Make sure that the column with the phone numbers has no plus symbol (+) and is in format "Plain text"

Format



To export, go to File > Download > .CSV or .XLSX

Export




Possible errors


Make sure that your columns DON'T have any blank spaces between the numbers, like this:



If this is the case, you can remove all the spaces with a simple formula:

=substitute(a1," ","")

  1. Go to the case next to the number you wish to modify (See picture above)
  2. Insert the code. Keep in mind that the a1 in the code corresponds to the case I'm modifying.
  3. It will then look something like this:
  4. Apply the same formula to all the numbers by dragging the case.
  5. After, please copy all the number and paste as values only (ctrl+shift+V).
  6. Delete the formula column, in this case the B.
Categories: