Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 165992 times)

Offline Mikeoracle

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2008
  • Posts: 2002
  • Total likes: 55
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: NJ
Re: Excel Problem
« Reply #720 on: December 28, 2016, 02:49:09 PM »
Have it in downloaded (not scanned) PDF files? And PDF-to-Excel software should do it just ok. If you don't have Adobe Acrobat Pro you can try a free online service like this https://smallpdf.com/pdf-to-excel or this https://www.pdftoexcelonline.com/en/
If you are not in a rush it may pay to wait until they publish their "Year End reports" which is either in avail excel or if not you can use the above method to convert just the one PDF

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #721 on: December 28, 2016, 03:02:23 PM »
Random question, maybe this is the wrong thread. Does anyone know of a quick convenient way to get my last years worth of chase cc statements into excel?
You can download all your transactions as CSV from Chase.com

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #722 on: December 28, 2016, 03:04:12 PM »
You can download all your transactions as CSV from Chase.com
Where? I couldnt find that option. For credit cards too, or just bank statements?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #723 on: December 28, 2016, 03:05:06 PM »
Have it in downloaded (not scanned) PDF files? And PDF-to-Excel software should do it just ok. If you don't have Adobe Acrobat Pro you can try a free online service like this https://smallpdf.com/pdf-to-excel or this https://www.pdftoexcelonline.com/en/
Will most probably not give you clean data...
Best simple way to get PDF data into Excel is to highlight a section and right click and export as Excel... It's only one section at a time...

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #724 on: December 28, 2016, 03:07:20 PM »
Have it in downloaded (not scanned) PDF files? And PDF-to-Excel software should do it just ok. If you don't have Adobe Acrobat Pro you can try a free online service like this https://smallpdf.com/pdf-to-excel or this https://www.pdftoexcelonline.com/en/
Small PDF messes it up. Its a chase credit card statement, so its not exactly in a table format. Tried downloading adobe, not working for some odd reason. Downloaded nitro, and it freezes when I try even 1 statement

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #725 on: December 28, 2016, 03:08:08 PM »
If you are not in a rush it may pay to wait until they publish their "Year End reports" which is either in avail excel or if not you can use the above method to convert just the one PDF
I dont see the option to download as excel, only PDF.

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #726 on: December 28, 2016, 03:08:54 PM »
Will most probably not give you clean data...
Best simple way to get PDF data into Excel is to highlight a section and right click and export as Excel... It's only one section at a time...
So i have to go into every one...that was my fear. Aahhh, I have a lot of credit cards... :(

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #727 on: December 28, 2016, 03:09:10 PM »
Small PDF messes it up. Its a chase credit card statement, so its not exactly in a table format. Tried downloading adobe, not working for some odd reason. Downloaded nitro, and it freezes when I try even 1 statement
waste of time. its not in table format and wont work...
Try export section as..

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #728 on: December 28, 2016, 03:10:00 PM »
waste of time. its not in table format and wont work...
Try export section as..
Export section in what program?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #729 on: December 28, 2016, 03:10:42 PM »
I dont see the option to download as excel, only PDF.
Do you see this option?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #730 on: December 28, 2016, 03:11:17 PM »
Export section in what program?
adobe

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #731 on: December 28, 2016, 03:14:42 PM »
Do you see this option?
That only helps for the last 3 months

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #732 on: December 28, 2016, 03:15:15 PM »
That only helps for the last 3 months
Nope. You can select any date range ime

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #733 on: December 28, 2016, 03:19:15 PM »
Nope. You can select any date range ime
Only let's me do the last 3 months
Even when I selected earlier dates

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26062
  • Total likes: 3226
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: Excel Problem
« Reply #734 on: December 28, 2016, 03:36:42 PM »
The video is 45 min. I need to start from :00-45:00
IDK what :00-45:00 means.

If you mean negative time, i.e. negative 45 minutes:
  • Negative 45 seconds is -0.03
  • Excel doesn't default to allowing negative date-time, you have to follow the instructions here.
  • Format to whatever time format you like.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #735 on: December 28, 2016, 04:24:46 PM »
Only let's me do the last 3 months
Even when I selected earlier dates
Check if its only 3 months at a time...

 I can definitely download from 1/1/2016-1/31/2016 for example.

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #736 on: December 28, 2016, 04:30:29 PM »
Check if its only 3 months at a time...

 I can definitely download from 1/1/2016-1/31/2016 for example.
Tried that :(

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #737 on: December 28, 2016, 04:44:43 PM »

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2981
  • Total likes: 109
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #738 on: December 28, 2016, 04:49:01 PM »
Call them and ask...
I sm'ed and they said that I can only get the last 3 months

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 289
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #739 on: December 28, 2016, 04:50:43 PM »
I sm'ed and they said that I can only get the last 3 months
Mine is a business account... Maybe it's a premium feature.