Sign in

How to convert CSV to Excel XLSX Spreadsheet in PHP

Let’s get right to the point: You are here to learn how to convert CSV files into XLSX using PHP. I am going to show you just how to do that in the absolute fastest way possible. Hold onto your hat, this is going to be quick!

Begin with this command to install our API client — run it from the command line.

composer require cloudmersive/cloudmersive_document_convert_api_client

Now call this function here and input your CSV.

<?phprequire_once(__DIR__ . '/vendor/autoload.php');// Configure API key authorization: Apikey$config = Swagger\Client\Configuration::getDefaultConfiguration()->setApiKey('Apikey', 'YOUR_API_KEY');// Uncomment below to setup prefix (e.g. Bearer) for API key, if needed// $config = Swagger\Client\Configuration::getDefaultConfiguration()->setApiKeyPrefix('Apikey', 'Bearer');$apiInstance = new Swagger\Client\Api\ConvertDocumentApi(// If you want use custom http client, pass your client which implements `GuzzleHttp\ClientInterface`.// This is optional, `GuzzleHttp\Client` will be used as default.new GuzzleHttp\Client(),$config);$input_file = "/path/to/file"; // \SplFileObject | Input file to perform the operation on.try {$result = $apiInstance->convertDocumentCsvToXlsx($input_file);print_r($result);} catch (Exception $e) {echo 'Exception when calling ConvertDocumentApi->convertDocumentCsvToXlsx: ', $e->getMessage(), PHP_EOL;}?>

Done! See, I told you it would be quick. Now before you go off to wonder what to do with all your newfound free time, do yourself a favor and take a look at what else our APIs can do. They cover everything from other types of file conversion, to optical character recognition, to facial comparison using Deep Learning.

Image for post
Image for post

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store