HOW EXCEL HANDLES CSV

A CSV file only contains basic information separated by commas. It is common to use a spreadsheet application such as Excel to create/open a CSV file.  This can make the initial process easier, but applications such as Excel can add extra information or change the formatting of certain fields when converting the file to and from the CSV format, which can have unexpected results .Also, Microsoft excel doesn't fully support Unicode characters in CSV format.

HOW GOOGLE SPREADSHEET HELPS YOU RESOLVE IT


If you have an excel file, and you want to generate the CSV file with unicode, open Google Docs.

To generate a CSV use Google Spreadsheet instead:

  1. Open a new spreadsheet in Google Docs
  2. Copy the columns from Excel to the spreadsheet. Make sure no "ERROR" cells are present when making the copy, because of column widths
  3.  In Google Spreadsheet, Generate a CSV using File -> Download -> Comma Separated Values (CSV)
  4. Upload the CSV to Bablic using Import feature.

If you have any questions please don't hesitate to contact us at [email protected]

Did this answer your question?