If the extension of the file you downloaded is .zip, you should open it and extract from it the library file with a .sh3f extension. Then, select that file in the file dialog box shown by the Furniture > Import furniture library menu item in Sweet Home 3D.