Best books about life

There are some excellent books that I came across which teaches invaluable life lessons. There are tons more books about live where these came from. Leave a comment if you wish to see more.

Life Lessons – Two experts on Death and Dying Teach us about the mysteries of life and living.

click on image above to see more details

This books has one of the highest positive rating on amazon. Here is a brief from amazon.com about the book. Don’t be fooled by the title. It is about life and living and not about death. Here is a review from amazon page.

After experiencing a paralyzing stroke in 1995 and facing her own mortality, Elisabeth Kübler-Ross realized she had some unfinished business to take care of. “I wanted to write one more book, not on death and dying, but on life and living,” she explains. So she joined forces with coauthor David Kessler, a leader in the field of hospice care, and together they wrote about the lessons we can learn about living from those who are dying. As Kessler explains in his introduction, “The dying have always been teachers of great lessons, for it’s when we are pushed to the edge of life that we see most clearly.”

Nine Essential Things I’ve Learned About Life

click on image above to see more details

This is an excellent book from Harold S. Kushner who is famous for his best seller (When bad things happen to good people).

Here is what Wall-street journal had to say about the book (From amazon page).

Whatever one’s religious beliefs may be, Mr. Kushner has much to say about the enduring value of community, the universal need for a sense of belonging, the moral sense that makes us human and the ways in which we also help ourselves by helping others.

Life Lessons – Everything you ever wished you had learned in kindergarten.

click on image above to see more details

There is a reason why this book is having a 4.9 star (out of 5) in amazon.

Life Lessons is a practical and inspiring guide to help you understand why things happen the way they do in life. You are NEVER being punished. You are NEVER a victim of your life. If it is happening in your life, it is because it is there to teach you something. And the sooner you can get that lesson, the sooner you can move on with your life. In clear and easy language, Donnalynn Civello, CHHC, AADP, Certified Intuitive Life Coach and Holistic Nutritionist helps you to understand the nature of life and the many life lessons that we encounter on a daily basis.

Its not for everyone though. Checkout the book and go through a few pages. You will be hooked.

Life’s Greatest Lessons – 20 Things that matter.

click on image above to see more details

This book has sold quarter of a million copies, and for good reason. The popularity and number of positive comments in amazon is an example of how this book is changing lives. Here is a brief review from the amazon page.

Life’s Greatest Lessons is a wise, wonderful book. In it, Hal Urban, a parent and an award-winning teacher, presents twenty principles that are as deeply rooted in common sense as they are in compassion. The topics, gathered from a lifetime of teaching both children and adults, span a wide range of readily understood concepts, including attitudes about money, understanding the real meaning of “success,” and the importance of having fun. The book will help you find the best—in the world, in others, and in yourself. Classic in its simplicity and enduring in its appeal, Life’s Greatest Lessons helps us all rediscover that the desire to live a good life is timeless.

30 Lessons for Living – Tried and True advice from the wisest Americans

click on image above to see more details

This is the holy grail if you are looking for books about life. You will find stories from thousands of extraordinary Americans in this book. You will have to take your time to read this and it will be well worth your time. Here is an small review from amazon page.

After a chance encounter with an extraordinary ninety-year-old woman, renowned gerontologist Karl Pillemer began to wonder what older people know about life that the rest of us don’t.His quest led him to interview more than one thousand Americans over the age of sixty-five to seek their counsel on all the big issues- children, marriage, money, career, aging. Their moving stories and uncompromisingly honest answers often surprised him. And he found that he consistently heard advice that pointed to these thirty lessons for living. Here he weaves their personal recollections of difficulties overcome and lives well lived into a timeless book filled with the hard-won advice these older Americans wish someone had given them when they were young.

Please leave comments if you think that another book should be included in this list.

All the links above are affiliate links.

Zillow to google sheets. How to get data from Zillow to google sheets

Data from zillow.com can be referenced from Google sheets using some inbuilt functions that Google sheets provide. We will be using two functions for this.

  1. importxml()
  2. index

The importxml will import all elements which are matched in the xpath query. In the example below, we are asking google sheets to get the contents of elements with class value ‘zest-value’. Now this query alone will return two results. We need only the first one. That is why we use the index function and specify the “1” in the end. So the whole formula will look something like this.

=index(importxml(<insert the zillow link here>,“//*[@class=’zest-value’]”),1)

Here is an example.

=index(importxml(“http://www.zillow.com/homedetails/3817-Vista-Verde-Palm-Springs-CA-92262/63316638_zpid/”,“//*[@class=’zest-value’]”),1)

Youtube link showing copy of data from zillow to google sheets

Redfin to google sheets data copy

I tried to copy from Redfin to googlesheets using the same technique after making changes as per the sites source listing. But didn’t have much luck there. If you guys figure out how to do that, please share the same in the comments section.