Despite advances of lanthanide-doped upconversion (UC) materials, the applications such as light-emitting diode and biological imaging are limited by low quantum efficiency. For this context, the understanding of unique interactions between the doped-lanthanides and the host crystals has attracted a huge amount of the researcher's interest. In particular, it was revealed that doping lanthanide ions in a non-centrosymmetric site of host lattice is the cause of relaxation of the Laporte selection rule in the 4f-4f transition of lanthanide ions. One of the layered perovskites CsBiNb2O7 is known to have non-centrosymmetric sites, which would lead to highly bright UC emission. Nevertheless, to our knowledge, there has been no research on the UC comparison between host materials of CsBiNb2O7 with other hosts. In this article, we present the UC intensity comparison of Yb3+-Er3+ ion doped CsBiNb2O7, NaYF4, BaTiO3, and SrTiO3 hosts (the UC in CsBiNb2O7:Er3+,Yb3+ was 2.4 times that of NaYF4:Er3+,Yb3+ and ∼70 times that of SrTiO3:Er3+,Yb3+). After that, we dig into UC, downshifting, and double beam system UC properties. The activator concentration was optimized by varying the doping ratio of Yb3+ and Er3+, and we found out the main reason for the concentration quenching behavior in Er3+ ion doped CsBiNb2O7 is dipole-dipole interaction. In addition, the double excitation experiment indicates that the absorption (4I15/2 → 4I13/2) factor is stronger than the stimulated emission (4I13/2 → 4I15/2) factor in CsBiNb2O7 under 1540 nm laser irradiation.