This article details the common issues you can face while working with CSV.
CSV is the standard format for arranging data in tables and interpreting it correctly. But, on the other hand, CSV file editors have some problems that could lead to corrupting your data, especially when working with numbers.
Country Code Formatter is a handy feature that helps you import phone numbers to a BusinessChat platform. Learn more.
3 tips for working with CSV files
Make sure to use the sample file
The sample file includes a header and some sample numbers. We prefer that you use it or look at it before you start preparing your file.
You will find the sample file in the upload CSV wizard, the upload CSV page.
curently we only support importing phone numbers, so you only need to have one column in your CSV, which is the phone number column.
If you want to use the sample file, copy your numbers from your data source and paste them into the sample file just below the header. Don't close the file before you complete the next step.
Change the format of the cells to numbers before you save
Select all your numbers and change the number format to the numbers format in excel.
Then, remove the decimal points by clicking on Decrease Decimal
Now you can save the file and then upload it.
Make sure to repeat the above steps if you decide to edit the file
If, for any reason, you want to edit your file, make sure that you repeat the above steps (change the format to numbers and remove the decimal points).
Why is this required?
By default, CSV always converts the numbers to scientific format, which removes the last few digits of any number and converts them to zeros. To avoid this, always switch the format to a standard number format.