?
Solved

how to convert .csv file to xlsx file with tabs

Posted on 2011-09-20
8
Medium Priority
?
519 Views
Last Modified: 2012-08-13
I want to convert csv to .xslx and put the data in tabs based on certain criteria, is there a way to do it thru excel macros or vb program.
0
Comment
Question by:panthi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36567164
You simply open the CSV file and then save it as .xsls.
0
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36567170
So open the CSV file using excel, and then save the file as xsls extension which will allow you to use all the excel functions, macros etc.
0
 

Author Comment

by:panthi
ID: 36567768
May be i am not clear. i understand that i  can do saveas, i basically want to automate this, that is the real question.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36570335
What is the criteria for dividing to tabs? You would have to use Office Automation.

http://support.microsoft.com/kb/302094
0
 

Author Comment

by:panthi
ID: 36573537
the criteria is value in one of the column
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36575932
Did you try the automation example?
0
 

Author Comment

by:panthi
ID: 36582628
To make it more clear this is what my task is
there is a csv file that is created by a program every day
I need to read that csv file based on the date and create a xlsx file as an output with seperate
tabs for each state. What is the most efficient way to do this i dont think automation example is right for the scenario mentioned.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 36593828
Given that you need to create additional sheets in xlasx file based on your criteria, I think automation is your only choice.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to increase the row limit in Jasper Server.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question