Base64 Encoder and Decoder

Base64Encoder.SK is a Sheetkraft fuction and use to encode the provided text using Base64.

Type Base64Encode.SK() formula in the cell, then click on the function symbol fx near the formula bar, Base64Encode.sk function Arguments UI will appear as shown in the figure below:

It has only one argument i.e. Value.

Enter any text or give the cell reference of the cell which is to be encoded, consider an example “test”

Encoded result of “text” will be “dGVzdA==”

Base64Decoder.SK is a Sheetkraft fuction and use to decode the encoded data using Base64.

Type Base64Decode.SK() formula in the cell, then click on the function symbol fx near the formula bar, Base64Decode.sk function Arguments UI will appear as shown in the figure below:

Enter the encoded text or give the cell reference which is to be decoded.

You will get the decoded data i.e. “test”.

Example: Consider a sample data

Now apply base64Encoder.sk on cell H3 in above shown table:

Now use FillDown.sk function on cell P3 in above shown table:

Do the same step for all column i.e. J,K,L,M of sample data, you will get the encoded data, as shown below

Now to get original data (readable data), use Base64Decoder.sk on cell P3 in above shown table:

Now use FillDown.sk function on cell X3 in above shown table:

Do the same step for all column i.e. Y,Z,AA,AB of Encoded data, you will get the Decoded data, as shown below: