Can you import CSV files as multiple worksheets?

G

Guest

Guest
Is there a way to code worksheet breaks into a single CSV file so that it is imported into Excel as multiple worksheets in a single workbook?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
I looked at this a while back, and I do not believe that there is a direct way. What you could do, though, is write a macro to separate the stuff all out after it has already been imported.

-Josh
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Macro to convert multiple CSV's into a single xlsx file with multiple workbooks (each workbook is the name of the csv file)
Replies
0
Views
117
kj9
K
P
  • Question
VBA to import multilpe xml files
Replies
1
Views
76
PippaThePointer
P
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
244
MichaelMorris
M
K
  • Solved
VBA to copy column/data from two .csv files to one combined file.
Replies
6
Views
560
kbilly70
K
D
  • Question
CSV From Quickbooks Issue
Replies
1
Views
72
Alex Blakenburg
A

Forum statistics

Threads
1,215,377
Messages
6,124,598
Members
449,174
Latest member
chandan4057

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top