csv into excel education

S

saltaway

Please, any advice in order to accomplish this.

Need to import csv files into excel.
Three categories of data from 40 locations (120 csv files) come in once a week. These files need to jump into a single spreadsheet in order for the data to be dispersed into many other spreadsheets.

Where/how can i educate myself in order to accomplish this?

Thanks for any help!!
jb
 
A

Alex

Open a file in Excel
Go to DATA - TEXT TO COLUMNS - edit as needed

The only thing you need to keep in mind is that Excel is
limited on number of lines (65,536) of data you can hold
on a single spreadsheet.

-----Original Message-----
Please, any advice in order to accomplish this.

Need to import csv files into excel.
Three categories of data from 40 locations (120 csv
Click to expand...
files) come in once a week. These files need to jump into
a single spreadsheet in order for the data to be dispersed
into many other spreadsheets.
 
G

Guest

Can you just open the CSV files up one by one and then
copy and paste as needed into your excel spreadsheet?

-----Original Message-----
Please, any advice in order to accomplish this.

Need to import csv files into excel.
Three categories of data from 40 locations (120 csv
Click to expand...
files) come in once a week. These files need to jump into
a single spreadsheet in order for the data to be dispersed
into many other spreadsheets.
 
G

Guest

You could. Excel reads CSV files. The trick is that one
line of data from a csv file could have multiple columns.

Ex. CSV FILE

A B C D E
----------------------------------------------------
Tom Jones Las Vegas Nevada USA

When you open this in Excel it will take all the columns
into one.

Ex. Excel

A B C etc.
 
Top