We extend the ab initio coupled-cluster effective interaction (CCEI) method to open-shell nuclei with protons and neutrons in the valence space, and compute binding energies and excited states of isotopes of neon and magnesium. We employ a nucleon-nucleon and three-nucleon interaction from chiral effective field theory evolved to a lower cutoff via a similarity renormalization group transformation. We find good agreement with experiment for binding energies and spectra, while charge radii of neon isotopes are underestimated. For the deformed nuclei 20 Ne and 24 Mg we reproduce rotational bands and electric quadrupole transitions within uncertainties estimated from an effective field theory for deformed nuclei, thereby demonstrating that collective phenomena in sd-shell nuclei emerge from complex ab initio calculations.Introduction -Nuclei are complex many-body systems that present us with a wealth of interesting quantum mechanical phenomena that emerge along the entire chart of nuclei. These phenomena involve: exotic clustering behavior and extended density distributions of loosely bound nuclei [1, 2], melting and re-organization of shellstructure in neutron nuclei [3][4][5], Borromean nuclei [6,7], and emergence of collective behavior in nuclei, such as rotational and vibrational states [8,9] as well as nuclear super conductivity and pairing [10].Recently there has been an explosion of nuclear manybody methods with a sufficiently soft computational scaling to allow a reliable description of binding energies and spectra in nuclei up through the sd-shell starting from nucleon-nucleon and three-nucleon forces from chiral effective field theory (EFT) [11][12][13][14][15][16]. In spite of this progress, emergence of collective phenomena in nuclei still poses significant challenges to ab initio methods. Rotational states in p-shell nuclei have been successfully computed in the no-core shell-model and in Green'sfunction Monte-Carlo approaches [17][18][19][20][21], while in the sd-shell, deformed nuclei have only been accurately described in shell-model calculations using phenemenological interactions [22]. A symplectic approach has been proposed [23] to enable extension of the no-core shellmodel to larger model spaces and higher-mass nuclei, yet prototypical deformed nuclei like 20 Ne and 48 Cr remain out of reach in the aforementioned approaches. Furthermore, as deformed nuclei are truly open-shell, they