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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
103
kj9
K
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
207
MichaelMorris
M
K
  • Solved
VBA to copy column/data from two .csv files to one combined file.
Replies
6
Views
515
kbilly70
K
D
  • Question
CSV From Quickbooks Issue
Replies
1
Views
63
Alex Blakenburg
A
C
  • Question
Setting the default save path with prompt
Replies
2
Views
335
CaptainGravyBum
C

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

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