Multiple CSV to Chart

A

adsl2

Expert Member
Joined
Oct 22, 2010
Messages
1,213
Reaction score
2
Hi guys,

I have a couple of CSV files (5-10).

Each file contains 3 columns the same amount of rows:

0: x-axis value
1: y-axis value 1
2: y-axis value 2

At the moment I open all of them and copy paste them into an excel file to create a line chart.

How can I automate this process?

Are there any other software that can simplify this?

Ideally I want to open the software and drag and drop the files.

Any help would be appreciated.

Thanks
 
Can't think of a way to automate it, but you can open the CSVs in Excel directly for a start
 
HavocXphere said:
Can't think of a way to automate it, but you can open the CSVs in Excel directly for a start
Click to expand...

Yeah I have been doing it but it takes a lot of time doing this tens/hundreds of times (experimentation for a project).
 
adsl2 said:
Hi guys,

I have a couple of CSV files (5-10).

Each file contains 3 columns the same amount of rows:

0: x-axis value
1: y-axis value 1
2: y-axis value 2

At the moment I open all of them and copy paste them into an excel file to create a line chart.

How can I automate this process?

Are there any other software that can simplify this?

Ideally I want to open the software and drag and drop the files.

Any help would be appreciated.

Thanks
Click to expand...

Excel VB macros.
 
Get someone to write a Python script for you.

Try Odesk (upwork.com), You should be able to get it done for $10 or $15

I've had a few Python and Java script's written to automate tasks.
 
If you are using Excel 2013 (maybe earlier as well) go to data tab and import text file - suggest you place each of the text's into separate sheets. Then under the data tab click connections and you will get options as to when data is refreshed.

If you have placed each import into a separate sheet, you can copy and paste to a consolidated sheet.
 
Thanks for all the suggestions guys. I will have a look at all of them. Thanks again
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X