🚀Excel Bulk conversion

Excel bulk conversion operates similarly to the datagrid method. To access the Excel converter page, click on the 'Excel' submenu under 'Bulk Conversion'.

Img 1 - Excel Bulk Converter

Utilizing the Excel format provides additional field options for customization, with the number of URLs limited according to your plan. Follow these steps

1. Download the Excel Template: This template outlines the available fields for customization. The URL field is mandatory. Download the template below 👇🏻

5KB

blinksto_excel_template.xlsx

File 1 - Excel file template

Img 2 - Fields provided in Excel template. Url is mandatory

1. Fill in and Upload: Complete the required fields and upload the filled file using the drag-and-drop widget in the center. Click 'Upload,' and the progress bar will display the file upload progress and the conversion status of each URL. If the number of URLs is small, the process may be quick, and the progress bar might not be visible.

2. Check Conversion Report: After the conversion is complete, download an Excel file displaying the status of each URL (Success or Error). If errors occur, the nature of the error is indicated next to the status column."

3. Fix Errors & Repeat: If errors occur, exclude the URLs without errors, rectify the rows with issues, re-upload, and repeat the process.

Let's explore a simple example:

I've downloaded the Excel file and completed the fields as illustrated below.

Img 3 - Filled in excel template

There are a total of 5 links to be converted:

• The first link has all fields filled in (alias, domain, title, and UTM parameters).

• The second link lacks UTM parameters.

• The third link is missing the domain (the preferred domain set will be used).

• The fourth link doesn't have the title filled in.

• The final link only has the URL.

If you're utilizing UTM parameters, ensure the first three are filled in, as they are required fields for UTM (source, medium, and campaign). You can leave them empty if UTM is not needed, but when using UTM, all three are required to be filled in.

Next, I uploaded the file and clicked on 'upload.' Since there were no errors, the shortening was successful, and the conversion status Excel is available for download."

Img 4 - Bulk conversion completed

Here is a snapshot of the conversion report:

Img 5 - Snapshot of Conversion report

The conversion report presents the initially filled columns used for conversion. It also includes additional fields:

• Short URL: The alias used for the URL.

• Long URL: The shortened link with the alias.

• Error: In the case of any error, it displays the type of error.

• Status: Conversion status - 1. Success or 2. Failed.

The shortened urls are shown below for reference:

Img 6 - Shortened urls using Excel bulk converter

View a quick video run through of the example using excel bulk converter: