As we know the GSTIN is PAN based and first two digit indicate the State code. Using this sheet you can generate the 15th place in GSTIN, hence you can validate a GSTIN offline or generate GSTIN if you only having PAN and State, even GSTIN does not exsist. #xlsx