Generate language files json from/to CSV in PHP (create more *.json if needed)

en.json

{
  "general": {
    "generalConditions": "General conditions",
    "basicSettings": "Basic settings",
    "contactUs": "Contact us",
    "systemInfo": "System info",
    "debugMode": "Debug mode",
    "help": "Help",
    "downloadSystemInfoFile": "Download system info file",
    "curlIsNotInstalled": "cURL is not installed or enabled in your PHP installation. This is required for background task to work. Please install it and then refresh this page.",
    "loading": "Loading...",
    "save": "Save",
    "saveChanges": "Save changes",
    "accept": "Accept",
    "cancel": "Cancel",
    "continue": "Continue",
    "complete": "Complete",
    "add": "Add",
    "edit": "Edit",
    "delete": "Delete",
    "discard": "Discard"
  },
  "validation": {
    "requiredField": "This field is required.",
    "invalidField": "This field is invalid.",
    "invalidEmail": "This field must be valid email.",
    "shortPassword": "The password must be at least %s characters long.",
    "invalidPhone": "This field must be valid phone number.",
    "maxLength": "The field cannot have more than %s characters.",
    "numeric": "Value must be valid number.",
    "greaterThanZero": "Value must be greater than 0.",
    "nonNegative": "Field cannot have a negative value.",
    "numberOfDecimalPlaces": "Field must have 2 decimal places.",
    "integer": "Field must be an integer.",
    "invalidCountryList": "You must select destination countries.",
    "invalidLanguage": "Field is not a valid language.",
    "invalidPlatformCountry": "Field is not a valid platform country.",
    "invalidUrl": "Field must be a valid URL.",
    "invalidFieldValue": "Field must be set to \"%s\".",
    "invalidMaxValue": "Maximal allowed value is %s."
  },
  "login": {
    "apiKey": "Api key",
    "apiKeyIncorrect": "API key was incorrect.",
    "dontHaveAccount": "Don't have an account?",
    "validateApiKey": "Validate API key",
    "chooseYourCountry": "Choose your country to start the registration process",
    "registerMe": "Register me"
  },
  "countries": {
    "ES": "Spain",
    "DE": "Germany",
    "FR": "France",
    "IT": "Italy",
    "AT": "Austria",
    "NL": "Netherlands",
    "BE": "Belgium",
    "PT": "Portugal",
    "TR": "Turkey",
    "IE": "Ireland",
    "GB": "Great Britain",
    "HU": "Hungary",
    "PL": "Poland",
    "CH": "Switzerland",
    "LU": "Luxembourg",
    "AR": "Argentina",
    "US": "United States",
    "BO": "Bolivia",
    "MX": "Mexico",
    "CL": "Chile",
    "CZ": "Czech Republic",
    "SE": "Sweden"
  },
  "register": {
    "logIn": "Log in",
    "email": "Email",
    "password": "Password",
    "haveAccount": "Already have an account?",
    "registerAccount": "Register your account",
    "getToKnowYou": "We would like to get to know you better in order to adapt to you and to send you an individual offer",
    "monthlyShipmentVolume": "What is your monthly shipment volume?",
    "phone": "Phone number",
    "submit": "Register",
    "chooseYourCountry": "Choose your country",
    "searchCountry": "Search country",
    "invalidDeliveryVolume": "Field is not a valid delivery volume."
  },
  "onboardingWelcome": {
    "header": "Let's set up basic information so that you can make shipments",
    "steps": "It's just two steps that we need to go through to offer you the carrier that best suits your needs",
    "stepOne": "Set parcel details",
    "stepTwo": "Set sender's address",
    "startSetUp": "Start set up"
  },
  "onboardingOverview": {
    "header": "Almost there! Please check that the entered information is correct or complete it in order to continue.",
    "parcelDetails": "Parcel details",
    "senderAddress": "Sender's Address",
    "missingInfo": "Missing information",
    "parcelData": "Weight %s kg | Height %s cm | Width %s cm | Length %s cm",
    "warehouseData": "%s | %s | %s"
  },
  "defaultParcel": {
    "title-onboarding": "1. Set parcel details",
    "description-onboarding": "We will use this default data for <strong>items that do not have defined dimensions and weight.</strong> You can edit them whenever you like via the settings tab.",
    "title-config": "Default parcel",
    "description-config": "We will use this data for <strong>items that do not have defined dimensions and weight.</strong>",
    "weight": "Weight",
    "height": "Height",
    "width": "Width",
    "length": "Length"
  },
  "defaultWarehouse": {
    "title-onboarding": "2. Set sender’s address",
    "description-onboarding": "We will use this address to create <strong>a default sender for all shipments.</strong> You will be able to edit it whenever you wish via the settings tab.",
    "title-config": "Default sender address",
    "description-config": "We will use this address to create <strong>a default sender for all shipments.</strong> You can edit it at any time.",
    "alias": "Warehouse name",
    "alias-placeholder": "Main warehouse",
    "name": "Name of contact person",
    "name-placeholder": "Name",
    "surname": "Surname of contact person",
    "surname-placeholder": "Surname",
    "company": "Company name",
    "company-placeholder": "Company",
    "country": "Country",
    "postal_code": "City or postcode",
    "postal_code-placeholder": "-",
    "address": "Address",
    "address-placeholder": "Address",
    "phone": "Phone number",
    "phone-placeholder": "123 456 7777",
    "email": "Email",
    "email-placeholder": "youremail@example.com"
  },
  "configuration": {
    "menu": "Settings",
    "title": "Settings",
    "orderStatus": "Order status",
    "warehouse": "Default sender address",
    "parcel": "Default parcel",
    "help": "Help",
    "contactUs": "Contact us at:",
    "systemInfo": "System information"
  },
  "systemInfo": {
    "title": "System information file <br>and debug mode",
    "debugMode": "Debug mode",
    "download": "Download system information"
  },
  "orderStatusMapping": {
    "title": "Order status",
    "systemOrderStatus": "%s <strong>ORDER STATUS</strong>",
    "none": "None",
    "pending": "Pending",
    "processing": "Processing",
    "readyForShipping": "Ready for shipping",
    "inTransit": "In transit",
    "delivered": "Delivered",
    "cancelled": "Canceled",
    "incident": "Incident",
    "outForDelivery": "Out for delivery"
  },
  "shippingServices": {
    "myServices": "My shipping services",
    "noServicesTitle": "You just need to add your shipment services",
    "noServicesDescription": "They will be shown to your customer at the time of checkout, so that they can choose which carrier will deliver their parcel. Set it up now so that you don't need to worry about anything else. You can change it whenever you wish, to renew or upgrade shipping services.",
    "addService": "Add service",
    "addNewService": "Add new service",
    "addedSuccessTitle": "Shipping service added successfully",
    "addedSuccessDescription": "You can edit the service from the <strong>\"My services\"</strong> section.",
    "deletedSuccessTitle": "Shipping service deleted successfully",
    "deletedSuccessDescription": "You can add new services from the <strong>\"Add new service\"</strong> button.",
    "disableCarriersTitle": "You have created your first shipment service. Do you want to disable previous carriers?",
    "disableCarriersDescription": "To provide you with a better service, it is important to <strong>disable the carriers</strong> you previously used.",
    "successfullyDisabledShippingMethods": "Successfully disabled shipping methods.",
    "failedToDisableShippingMethods": "Failed to disable shipping methods.",
    "pickShippingService": "Add delivery services",
    "failedGettingServicesTitle": "We are having troubles getting shipping services",
    "failedGettingServicesSubtitle": "Do you want to retry?",
    "retry": "Retry",
    "filterModalTitle": "Filters",
    "applyFilters": "Apply",
    "type": "Type",
    "national": "Domestic",
    "international": "International",
    "deliveryType": "Type of shipment",
    "economic": "Budget",
    "express": "Express",
    "parcelOrigin": "Parcel origin",
    "collection": "Collection",
    "dropoff": "Drop off",
    "parcelDestination": "Parcel destination",
    "pickup": "Pick up",
    "delivery": "Delivery",
    "carrierLogo": "Carrier logo",
    "carrier": "Carrier",
    "serviceTitle": "Service title",
    "serviceTitleDescription": "Customise your shipment by editing it. Your customers will be able to see it.",
    "transitTime": "Transit Time",
    "origin": "Origin",
    "destination": "Destination",
    "myPrices": "My prices",
    "configureService": "Set up service",
    "showCarrierLogo": "Show carrier logo to my customers",
    "pricePolicy": "Price policy",
    "configurePricePolicy": "Set up my shipment prices",
    "taxClassTitle": "Choose your saved tax class",
    "tax": "Tax",
    "serviceCountriesTitle": "Availability by destination country",
    "serviceCountriesDescription": "Select the availability for the countries that are supported for your shipping service.",
    "openCountries": "See countries",
    "allCountriesSelected": "All countries selected",
    "oneCountrySelected": "One country selected",
    "selectedCountries": "%s countries selected.",
    "firstPricePolicyDescription": "Perfect, just a couple of steps:<br><br>1. Choose whether you want to set them by weight and/or purchase price.<br><br>2. Choose a price policy and set it up.",
    "addFirstPolicy": "Add price rule",
    "addAnotherPolicy": "Add another rule",
    "from": "From",
    "to": "To",
    "price": "Price",
    "rangeTypeExplanation": "1. Choose whether you want to set them by weight and/or purchase price.",
    "rangeType": "Range type",
    "priceRange": "Price range",
    "priceRangeWithData": "Price range: from %s€ to %s€",
    "weightRange": "Weight range",
    "weightRangeWithData": "Weight range: from %s kg to %s kg",
    "weightAndPriceRange": "Weight and price range",
    "weightAndPriceRangeWithData": "Weight and price range: from %s kg to %s kg and from %s€ to %s€",
    "singlePricePolicy": "Price policy %s",
    "pricePolicyExplanation": "2. Choose a price policy and set it up.",
    "fixedPrices": "Fixed price",
    "fixedPricesWithData": "Fixed price: %s€",
    "increaseExplanation": "Increase: add a % to the price, this will be paid by the customer.",
    "reduceExplanation": "Reduce: deduct a % from the price, you will pay for it yourself.",
    "select": "Select",
    "invalidRange": "Invalid range",
    "increase": "increase",
    "reduce": "reduce",
    "selectAllCountries": "All selected countries",
    "selectCountriesHeader": "Countries supported for your <br> shipping service",
    "selectCountriesSubheader": "Select availability of at least one country and add <br> as many required",
    "discardChangesQuestion": "There are unsaved changes.<br>Are you sure you want to go back and discard them?",
    "atLeastOneCountry": "At least one country must be selected.",
    "misconfiguration": "Due to store currency change, you must set a Fixed Price value by clicking \"edit\" on the shipping service."
  },
  "orderListAndDetails": {
    "printed": "Printed",
    "ready": "Ready",
    "printLabel": "Print label",
    "shipmentLabels": "Shipment Labels",
    "shipmentDetails": "Shipment details",
    "disablePopUpBlocker": "Please disable pop-up blocker on this page in order to bulk open shipment labels",
    "date": "Date",
    "number": "Number",
    "status": "Status",
    "print": "Print",
    "carrierTrackingNumbers": "Carrier tracking numbers",
    "trackIt": "Track it!",
    "createDraft": "Create Draft",
    "draftCreateFailed": "Previous attempt to create a draft failed. Error: %s",
    "shipmentOrderNotExist": "Order with shipment reference %s doesn't exist in the shop",
    "orderDetailsNotFound": "Order details not found",
    "orderNotExist": "Order with ID %s doesn't exist in the shop",
    "bulkFailCreateFail": "Unable to create bulk labels file",
    "draftOrderDelayed": "Creation of the draft is delayed",
    "completeServicesSetup": "You need to complete the services setup to create order draft."
  },
  "checkoutProcess": {
    "choseDropOffLocation": "This shipping service supports delivery to pre-defined drop-off locations. Please choose location that suits you the most by clicking on the \"Select drop-off location\" button.",
    "selectDropOffLocation": "Select drop-off location",
    "changeDropOffLocation": "Change drop-off location",
    "packageDeliveredTo": "Package will be delivered to:",
    "dropOffDeliveryAddress": "Drop-Off delivery address",
    "changeAddress": "There are no delivery locations available for your delivery address. Please change your address.",
    "shippingServiceNotFound": "Shipping service not found"
  },
  "locationPicker": {
    "monday": "Monday",
    "tuesday": "Tuesday",
    "wednesday": "Wednesday",
    "thursday": "Thursday",
    "friday": "Friday",
    "saturday": "Saturday",
    "sunday": "Sunday",
    "zipCode": "Zip code",
    "idCode": "ID code",
    "selectThisLocation": "Select this location",
    "showWorkingHours": "Show working hours",
    "hideWorkingHours": "Hide working hours",
    "showOnMap": "Show on map",
    "searchBy": "Search by location name, id or address"
  },
  "migrationLogMessages": {
    "removeControllersHooksFailed": "Failed to remove old controllers and hooks because: %s",
    "deleteObsoleteFilesFailed": "Could not delete obsolete files because: %s",
    "oldAPIKeyDetected.": "Old API key detected.",
    "successfullyLoggedIn": "Successfully logged in with existing api key.",
    "removingObsoleteFiles.": "Removing obsolete files.",
    "cannotEnqueueUpgradeShopDetailsTask": "Cannot enqueue UpgradeShopDetailsTask because: %s",
    "deletingOldPluginDta.": "Deleting old plugin data.",
    "cannotRetrieveOrderReferences": "Cannot retrieve order references because: %s",
    "createOrderReferenceFailed": "Failed to create reference for order %s",
    "setLabelsFailed": "Failed to set labels for order with reference %s",
    "setTrackingInfoFailed": "Failed to set tracking info for order with reference %s",
    "orderNotFound": "Order with reference %s not found."
  },
  "systemLogMessages": {
    "errorCreatingDefaultTask": "Error creating default task runner status configuration.",
    "couldNotDelete": "Could not delete entity %s with ID %s",
    "entityCannotBeSaved": "Entity %s with ID %s cannot be saved.",
    "entityCannotBeUpdated": "Entity %s with ID %s cannot be updated.",
    "fieldIsNotIndexed": "Field %s is not indexed!",
    "unknownOrNotIndexed": "Unknown or not indexed OrderBy column %s",
    "dirNotCreated": "Directory \"%s\" was not created",
    "failedCreatingBackup": "Failed creating backup service.",
    "backupServiceNotFound": "Backup service not found."
  },
  "autoTest": {
    "dbNotAccessible.": "Database not accessible.",
    "taskCouldNotBeStarted.": "Task could not be started.",
    "start": "Start",
    "downloadTestLog": "Download test log",
    "autotestPassedSuccessfully": "Auto-test passed successfully!",
    "testNotSuccessful": "The test did not complete successfully."
  }
}

fromCSV.php

<?php
/** @noinspection PhpElementIsNotAvailableInCurrentPhpVersionInspection */

function fromCsv()
{
    $sourcePath = __DIR__ . '/translations.csv';
    if (!file_exists($sourcePath)) {
        echo "no source file\n";
        exit();
    }

    $f = fopen($sourcePath, 'rb+');
    // skip header
    fgetcsv($f);

    $en = $es = $de = $fr = $it = array();

    while ($line = fgetcsv($f)) {
        $en[$line[0]][$line[1]] = $line[2];
        $es[$line[0]][$line[1]] = $line[3];
        $de[$line[0]][$line[1]] = $line[4];
        $fr[$line[0]][$line[1]] = $line[5];
        $it[$line[0]][$line[1]] = $line[6];
    }

    fclose($f);

    exportJson('en', $en);
    exportJson('es', $es);
    exportJson('de', $de);
    exportJson('fr', $fr);
    exportJson('it', $it);
}

function exportJson($lang, $data)
{
    file_put_contents(
        __DIR__ . "/fromCSV.php",
        str_replace(
            '    ',
            '  ',
            json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES)
        )
    );
}

fromCsv();

toCSV.php

<?php
/** @noinspection PhpElementIsNotAvailableInCurrentPhpVersionInspection */

function toCsv()
{
    $en = json_decode(file_get_contents(__DIR__ . '/en.json'), true);
    $es = json_decode(file_get_contents(__DIR__ . '/es.json'), true);
    $de = json_decode(file_get_contents(__DIR__ . '/de.json'), true);
    $fr = json_decode(file_get_contents(__DIR__ . '/fr.json'), true);
    $it = json_decode(file_get_contents(__DIR__ . '/it.json'), true);

    $resultPath = __DIR__ . '/translations.csv';
    if (file_exists($resultPath)) {
        unlink($resultPath);
    }

    $f = fopen($resultPath, 'cb+');
    fputcsv($f, array('Group', 'key', 'English', 'Spanish', 'German', 'French', 'Italian'));

    foreach ($en as $group => $translations) {
        foreach ($translations as $key => $value) {
            $line = array();
            $line[] = $group;
            $line[] = $key;
            $line[] = $value;
            $line[] = isset($es[$group][$key]) ? $es[$group][$key] : '';
            $line[] = isset($de[$group][$key]) ? $de[$group][$key] : '';
            $line[] = isset($fr[$group][$key]) ? $fr[$group][$key] : '';
            $line[] = isset($it[$group][$key]) ? $it[$group][$key] : '';

            fputcsv($f, $line);
        }
    }

    fclose($f);
}

toCsv();

translations.csv