Principal to AccountID - Excel/Google sheets

skilesare · April 1, 2022, 5:14pm

Going out on a limb here, has anyone created an excel and/or google sheet function to convert a principal to the default account id?

Example code is here if there are any spreadsheet wizards out there.

github.com

aviate-labs/principal.mo/blob/main/src/AccountIdentifier.mo

import Array "mo:base/Array";
import Array_ "mo:array/Array";
import Binary "mo:encoding/Binary";
import Blob "mo:base/Blob";
import CRC32 "mo:hash/CRC32";
import Hash "mo:base/Hash";
import Hex "mo:encoding/Hex";
import Principal "mo:base/Principal";
import Result "mo:base/Result";
import SHA224 "mo:crypto/SHA/SHA224";

module {
    // Represents an account identifier that was dirived from a principal.
    // NOTE: does NOT include the hash, unlike in the textual representation.
    public type AccountIdentifier = [Nat8]; // Size 28
    public type SubAccount        = [Nat8]; // Size 4

    // Checks whether two account identifiers are equal.
    public func equal(a : AccountIdentifier, b : AccountIdentifier) : Bool {
        a == b;

This file has been truncated. show original

Ori · April 1, 2022, 6:59pm

In the meantime there’s a tool to bulk convert principals to account ids here: https://k7gat-daaaa-aaaae-qaahq-cai.ic0.app/docs/

rckprtr · April 1, 2022, 8:02pm

I use this all the time

I also need to add ‘Get Airdrop Account IDs’ to the Members tool on DSCVR

skilesare · April 1, 2022, 10:34pm

Thank you! This works for now.

Topic		Replies	Views
AccountID to Principal Developers Functional-Programming	5	1919	May 20, 2022
Relationship between PrincipalId and AccountIdentifier Developers	2	470	July 18, 2022
How to translate principal to account-id in ledger canister Developers in-progress	1	772	November 15, 2021
How to: generate account identifier from a principal and a subaccount_identifier Developers	4	686	June 30, 2023
Principal to accountid in go 请问哪里写错了 Developers	0	261	September 13, 2022

Principal to AccountID - Excel/Google sheets

Related topics