How to prepare correct csv template for WA Broadcasting

Download CSV Template provided by Qiscus

mceclip1.png

Edit CSV File with Google Sheet

mceclip2.png

  • Select File > Import then navigate to Upload

mceclip3.png

  • Select `replace spreadsheet` for import location, `comma` for separator type then click `Import Data`. Refer to this image below when the import file popup shows up

mceclip5.png

  • Select Phone Number Column (Click Cell Header `A`)

mceclip6.png

  • Go to Format > Number > More Format > Custom Number Format then input `+#` in the text input
  • mceclip7.png
  • You can edit the csv file as you see fit then download the csv file through File > Download > CSV

mceclip8.png

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.