Below is a step-by-step process for converting an Excel workbook to CSV format using OpenOffice or Microsoft Excel.<\/p>\n\n
How to convert an Excel file to CSV<\/h2>\n\nWith LibreOffice<\/h3>\n\n
For ease of use, we recommend LibreOffice, which you can download free of charge from the publisher’s website<\/a>.<\/p>\n\n Start by opening the file with LibreOffice.<\/p>\n\n The format of numbers imported into Kavkom must include the country code without the +. If the numbers in your file start with a +, delete them by opening the “Edit” menu (1) then “Find and replace” (2).<\/p>\n\n In the “Search” field, type a “+” (1) and in the “Replace” field, leave the field blank, click on the “Replace all” button (3) then close the window.<\/p>\n\n Open the “File” menu (1) and click on “Save as”.<\/p>\n\n In type, select “Text CSV” then click on “Save” at bottom right.<\/p>\n\n In the “Export text files” window, for Character set select “Unicode (UTF-8)” (1) and for Field separator select the comma (2) then click “OK” (3).<\/p>\n\n Your file is now ready to be imported into your Kavkom solution.<\/p>\n\n If you need help, please contact our support team.<\/p>\n\n First open the Excel workbook you wish to export.<\/p>\n\n Go to the “File” menu, then click on the “Save as” command in the left-hand sidebar. Alternatively, press the “F12” key on your keyboard to open the same “Save As” dialog box. <\/p>\n\n In the “File type” drop-down list, choose to save your Excel file in “CSV (semicolon separator) (*.csv)” format, as shown in the screenshot below. This file format saves the Excel spreadsheet as semicolon-separated text that can be used in another Windows program or another version of the Windows operating system. <\/p>\n\n Then find and select the folder in which you wish to place your Excel file in CSV format, and click on the “Save” button to finish.<\/p>\n\n When you click on “Save”, Excel will display the dialog box shown in the screenshot below. Don’t worry, this is not an error message. In fact, when you save an Excel workbook in CSV format, it will only save the currently active worksheet. Here we distinguish between two cases. <\/p>\n\n When you click on “OK” in the first dialog box, a second dialog box (shown in the screenshot below) opens, informing you that your spreadsheet may contain features not supported by CSV encoding. Simply click on “Yes”. <\/p>\n\n Now, to open the CSV file and view its contents, right-click on it, select “Open with” from the context menu and then choose “Notepad” or any other preferred text editor.<\/p>\n\n Once you’ve opened the file, you’ll see that the data in each cell is separated by a semicolon between them, and you’ll get a result as shown in the screenshot below.<\/p>\n\n However, our aim was to convert the Excel spreadsheet into a comma-separated CSV file. So we need to replace all semicolons with commas. To do this, proceed as follows with Notepad: <\/p>\n\n Select “Modify” (1) then “Replace” (2) to open the dialog box.<\/p>\n\n In the “search” field, type a semicolon (1), in the “replace with” field type a comma (2) and click on “Replace all” (3).<\/p>\n\n Since the format of numbers imported into Kavkom must include the country code without the +, you can delete them using the same technique, replacing all +’s with nothing.<\/p>\n\nDelete +.<\/h4>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-OpenOffice-Rechercher-et-remplacer.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-OpenOffice-Supprimer-les-.png\")
<\/a><\/figure>\n\nSave as CSV<\/h4>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-OpenOffice-Enregistrer-sous.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-OpenOffice-Selectionner-CSV.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-OpenOffice-Separateur-virgule.png\")
<\/a><\/figure>\n\nWith Excel<\/h3>\n\n
Save Excel file as CSV<\/h4>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Enregistrer-sous.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Enregistrer-en-CSV-separateur-point-virgule.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Plusieurs-feuilles.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Confirmer.png\")
<\/a><\/figure>\n\nOpen the CSV file in a text editor<\/h4>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Ouvrir-avec-le-bloc-notes.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Ouvrir-avec-bloc-notes.png\")
<\/a><\/figure>\n\nClean file<\/h4>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-replacer-point-virgule-1.png\")
<\/a><\/figure>\n\n![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-replacer-point-virgule-2.png\")
<\/a><\/figure>\n\n
![\"\"](\"https:\/\/help.kavkom.com\/wp-content\/uploads\/2023\/02\/Convertir-Excel-en-CSV-Excel-Apercu-fichier-conforme.png\")
<\/a><\/figure>\n\n