$xlsx = 'c:/path/to/file/whatever.xlsx' #Desired location of output $csv = 'c:/path/to/file/whatever.csv' #Location of the source file The following script will open the specified CSV, save it as an XLSX file to a specified location and perform a text-to-columns based on the delimiter being a semicolon ( ). The original code was unable to determine the delimiting character within the CSV and so whilst I was successful in obtaining a XLSX file, it was still semi-colon separated. The following code is substantially based on the work of Nixta but I have made several changes including the manual specification of the delimiting character. Online tools exist too ( Example 1, Example 2).

There are several pieces of code online that purport to do this but don’t work well ( Example 1, Example 2, Example 3). Microsoft Office, LibreOffice, Kingsoft Office, Google Docs.Screenshot of a XLSX file in Microsoft Excel with data arranged in cells. Depending on the type of the document, the packages have different internal directory structures and names. Office Open XML documents are stored in Open Packaging Convention (OPC) packages, which are ZIP files containing XML and other data files, along with a specification of the relationships between them. CSV implementations may not handle such field data, or they may use quotation marks to surround the field. The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data may also contain commas or even embedded line-breaks. There are formats for word processing documents, spreadsheets and presentations as well as specific formats for material such as mathematical formulae, graphics, bibliographies etc. The Office Open XML file formats are a set of file formats that can be used to represent electronic office documents. The use of the comma as a field separator is the source of the name for this file format. Each record consists of one or more fields, separated by commas. In computing, a comma-separated values (CSV) file stores tabular data (numbers and text) in plain text. Application/vnd.-openxmlformats-officedocument.-spreadsheetml.-sheet

Convert csv to xlsx