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.
Pro-Tip
Country Code Formatter is a handy feature that helps you import phone numbers to a BusinessChat platform. Learn more.
Three 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 you use it or look at it before preparing your file.
You will find the sample file in the upload CSV wizard, the upload CSV page.
🔴Alert
Currently, we only support importing phone numbers, so you only need one column in your CSV, 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 would like to edit your file, please make sure that you repeat the above steps (change the format to numbers and remove the decimal points).
🔴Alert
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.