Saving multiple CSV (online source) files a single CSV file (on computer)

Topic

New Reply

I want to be able to download my credit card statements to my computer.  This is not necessarily an “easy” process.  The CSV files are arranged, by the bank, to reflect each statement period.  e.g., Oct 23, 2021; Sept 22, 2021; Aug 23, 2021; etc.

They can only be downloaded as CSV files, so to download the statements for the past year, I have to download 12 CSV files and then convert each one to an XLSM file.  To get my yearly summary, I then have to load each of the XLSM files into a single file.  When you are dealing with 3 credit cards, this is a lot of work.  I am hoping that there might be some way to decrease this work.  The bank has told me that there is no way to get one “large” CSV file with the statements that would contain all the results for the year 2021

Is there some way I can download each of the statements CSV files and save them all into a single CSV files as they are downloaded, e.g., start with the first CSV file download and then when I down load the second one, have its contents added/concatenated to the first one I downloaded.  If something like this is possible, then when I am finished, I would have one large CSV file that I could convert to a single XLSM file.

The only way I can see to do that now is to download the CSV file for each statement and then copy them all into one larger file that I save as a CSV file and then convert that single CSV file to an XLSM file.

Any thoughts or ideas that anyone might have to help me simplify this process will be greatly appreciated.

Ron M

Reply | Quote

Replies

https://www.live2tech.com/merge-multiple-csv-files-combine-one-large-csv-file/

Reply | Quote

Oops, looks like I forgot to sign in…again —> anonymous!

Ron M

1 user thanked author for this post.

zeddy

Reply | Quote

Ron, the “I’m Not A Robot” thing only appears for people who don’t sign in.  This should always be a clue that you’re not signed in.

Being 20 something in the 70's was far more fun than being 70 something in the insane 20's

1 user thanked author for this post.

zeddy

Reply | Quote

Alex5723’s suggestion is essentially the technique I would use. If you follow the Live2Tech instructions, though, note it’s quicker to combine Steps 2-4 into one by simply selecting “Open command window here” in Step 2 instead of “Copy as path”.

 

Reply | Quote

Alex 5723, that looks like a potential solution for part of my problem, but it doesn’t cover all of what I was hoping for. (Maybe I can’t get it all?)

Here’s my situation.  (in a perfect world?)  Assume I have 4 statement files A (20 rows), B (10 rows), C (15 rows) and D (5 rows) that are on the web as successive monthly statements (I used letters to make it easier for me to try and describe what I was hoping to find. (Emphasis on hoping)

I download A to a file that I will call ALL.csv (on my computer) and I now have the first 20 rows of ALL.csv filled.  Then I download B and what I am hoping is that I can simply add it to ALL.csv so that I now have 30 rows in ALL.csv.  I then download C and add it to ALL.csv during the download so that ALL.csv now has 45 rows in it.  Lastly, I download D to ALL.csv so that ALL.csv now has 50 rows in it.  When I am finished with A, B, C, and D (statements), I have a file, ALL.csv with all of the data from A, B, C, and D (statements) and I can then convert the file ALL.csv to a .xlsm file and end up with one file that I can process further.

I am not sure if this is possible unless there is some way to <Save> each of the statement files on the web to the last line of a previous file.  Right now, I can select one of the statement files, e.g., A and download it.  During the download process, I have to specify a file name for the download of A as A does not really exist on the web as a .CSV file.  It is simply a collection of entries for the statement I am trying to download.  The download doesn’t really become a .CSV file until I specify that is the type of download that I want.  The process then produces a generic download file that isn’t really named until I <Save> it to my computer.

I do hope I am making my self clear as the download itself is not really a complex process – explaining it is.  So I need to know if what I am hoping to do is possible.  Thanks folks.

Ron M

Reply | Quote

Why do you think Alex’s solution wouldn’t work?

Download the parts and join them all together.

(Name them in required numerical order first.)

Reply | Quote

dg1261 and b, Alex5723’s solution will work, no doubt about it, but it requires the creation of a .csv file for each statement’s download.  This is something I was hoping to avoid by being able to add the download for each statement to the ALL file as the download for the csv of each Statement is processed.

Statement A > csv > download process > ALL.csv (rows 1 to 20)

Statement B > csv > download process > ALL.csv (rows 21 to 30)

Statement C > csv > download process > ALL.csv (rows 31 to 45)

Statement D > csv > download process > All.csv (rows 46 to 50)

It is quite possible that such a download process is not possible.  Maybe some VBA code would be able to make it happen, but I am not that good with VBA – just a raw beginner.

If this approach is not possible, then Alex5723’s process would be an answer to help improve my present process.

Ron M

Reply | Quote

Charlie, I knew there was a catch to it.  Thanks for the info.

Ron M

Reply | Quote

Alex5723, I tried your approach.  I must be doing something wrong.  I gave it 10 CSV files to copy in a single folder and only the last one was in the “copied” csv.  The ones to be copied were in increasing date order starting last December and going until this October, named as follows:

2020-12-24 to 2021-01-26 NNNN accountactivity.csv

2021-01-27 to 2021-02-23 NNNN accountactivity.csv

2021-02-24 to 2021-03-23 NNNN accountactivity.csv

↓

↓

2021-09-24 to 2021-10-25 NNNN accountactivity.csv

==========================================

NNNN is a private card number for banking purposes only.  These CSV files were the only ones in the initial CSV folder.

Any thoughts on what I am not doing that I should be doing?

Ron M

Reply | Quote

Ron,

This can probably be done with a little Powershell.
Unfortunately, I’m currently at sea with no access to a computer. I get home Sat. evening and I’ll look into it then.

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

RG, thank you.  I have no familiarity with Powershell, but I am sure you can give me enough pointers to get me going.

Great to be at sea!

Ron M

Reply | Quote

I was just looking at YouTube and found this video. It would seem to show you how to do this within Excel and looks relatively easy. It might depend on the version of Excel you have. One thing is that as you add a new file and click refresh it will just add the new file.

 

Eliminate spare time: start programming PowerShell

Reply | Quote

access-mdb, thanks for the reference.  I will definitely have a look at that Video.

 

Ron M

Reply | Quote

access-mdb, it would appear that this approach has worked.  Thanks for the reference.

I just have to make sure that all of the entries (lines) in each folder made it over to the final larger file.  If this has worked and it seems like it has, then this is going to save me quite a bit of time.   Thanks Again!

Ron M

1 user thanked author for this post.

access-mdb

Reply | Quote