{"id":27445,"date":"2025-10-10T14:45:02","date_gmt":"2025-10-10T18:45:02","guid":{"rendered":"https:\/\/phpreaction.com\/uncategorized\/using-csv-with-openoffice-for-data-import\/"},"modified":"2025-10-10T14:45:04","modified_gmt":"2025-10-10T18:45:04","slug":"using-csv-with-openoffice-for-data-import","status":"publish","type":"post","link":"https:\/\/phpreaction.com\/en\/continuous-improvement\/using-csv-with-openoffice-for-data-import\/","title":{"rendered":"Using CSV with OpenOffice for data import"},"content":{"rendered":"

[vc_row mo_row_type=”in_container”][vc_column width=”2\/3″][vc_custom_heading text=”Using CSV with OpenOffice for data import” font_container=”tag:h1|text_align:left”][vc_column_text]Understanding and being able to use CSV opens up a whole new world of possibilities. Most systems have a method for exporting to CSV or Excel, and this is also the case for PHPReaction’s standard export.<\/span><\/p>\n

Read examples of column structure templates for PHPReaction imports.<\/span><\/a><\/p>\n

URL: https:\/\/phpreaction.com\/quoi-de-neuf\/import-massif-de-donnees-dans-votre-erp\/#exemples<\/span><\/a><\/p>\n

\u00a0<\/span><\/span><\/p>\n

Furthermore, you will be able to work and import your CSV data files directly into your PHPReaction<\/span><\/p>\n

Import documentation: https:\/\/phpreaction.com\/en\/features\/support-for-importing-data-with-phpreaction\/<\/span><\/a>[\/vc_column_text][\/vc_column][vc_column width=”1\/3″][vc_single_image image=”11086″ img_size=”medium”][\/vc_column][\/vc_row][vc_row mo_row_type=”in_container”][vc_column width=”1\/3″][vc_single_image image=”23757″ img_size=”medium” alignment=”center”][\/vc_column][vc_column width=”2\/3″][vc_custom_heading text=”Apache OpenOffice”][vc_column_text]OpenOffice is produced by Apache<\/a> (a company established and recognized for several years)<\/span><\/p>\n

It offers a basic office suite (Writer, Spreadsheet\/Calc, Impress, Draw, Base and Math)<\/span><\/p>\n

Of course, what interests us for CSV is Spreadsheet\/Calc!<\/span><\/p>\n

It is free and open source and compatible with Windows, Mac, and Linux.<\/span><\/p>\n

To download it for free: https:\/\/www.openoffice.org\/download\/index.html<\/span><\/a>[\/vc_column_text][vc_column_text]<\/p>\n

LibreOffice<\/span><\/h3>\n

LibreOffice<\/a> is another alternative for using CSV.<\/span><\/p>\n

 <\/p>\n

It is free and open source and compatible with Windows, Mac, and Linux.<\/span><\/p>\n

To download it for free: https:\/\/www.libreoffice.org\/download\/download\/<\/span><\/a>[\/vc_column_text][vc_column_text]<\/p>\n

Google Sheets<\/b>\u00a0<\/span><\/h3>\n

Indeed, Google Sheets<\/a> is another alternative for using CSV files directly in the cloud. It also enables collaborative work and facilitates document sharing via its Google Drive platform.<\/span><\/p>\n

 <\/p>\n

Since it’s a cloud-based web application, it runs on the browser, making it compatible with Windows, Mac, and Linux.
\nVisit the GSheets \/ Google Sheets \/ Google SpreadSheet tool page<\/a><\/span><\/p>\n

For more information, visit Wikipedia<\/span><\/a>[\/vc_column_text][vc_column_text]<\/p>\n

Microsoft Excel<\/span><\/span><\/h3>\n

Of course, you can also use Microsoft Excel \/ MSExcel \/ Excel<\/a>. <\/span><\/p>\n

However, this tutorial will not be similar to your usage.<\/span><\/p>\n

Furthermore, it seems that the application does not follow the same standards for CSV files. For example, the default delimiter is a semicolon “;” rather than a comma “,” as indicated in the name “CSV” where the “V” stands for comma.<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=”in_container”][vc_column][vc_custom_heading text=”Open a CSV with OpenOffice”][vc_column_text]A sample CSV file should have the extension “.csv” (e.g., “xyz.csv”)<\/span><\/p>\n

You can open the application and then open the file.<\/span><\/p>\n

The easiest way is to open the file from “open with” and then select “OpenOffice Calc”<\/span><\/p>\n