Closed Thread
Results 1 to 27 of 27

.CSV to .XLSX Automatic Batch Conversion

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    .CSV to .XLSX Automatic Batch Conversion

    Hi,

    I run Excel 2010 and need to convert my data, which comes in .csv format to .xlsx on an continual basis from the same folder. How could I accomplish this? I am not advanced so if someone could dumb down the instructions that would be very much appreciated. Thank you guys!
    Last edited by prosemur; 03-31-2014 at 12:43 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: .CSV to .XLSX Automatic Batch Conversion


    Hi,

    what happens when in the Windows Explorer you do a double clic on the csv file ?

  3. #3
    Registered User
    Join Date
    03-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: .CSV to .XLSX Automatic Batch Conversion

    It opens. The problem, however, is that the .csv files are uploaded every night to a folder that automatically uploads those .csv files to google drive, where all the partners view it. However, .csv files can't be viewed easily on google drive, so we need to have them automatically converted to .xlsx files upon their upload to their folder. Opening each folder and saving it as .xlsx is out of the question. There are too many existing files and no one is going to alter the files each night manually.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: .CSV to .XLSX Automatic Batch Conversion


    So using the Macro Recorder and thus opening manually from Excel a csv file
    and save it as a workbook will give you a base code …

  5. #5
    Registered User
    Join Date
    03-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: .CSV to .XLSX Automatic Batch Conversion

    Quote Originally Posted by Marc L View Post

    So using the Macro Recorder and thus opening manually from Excel a csv file
    and save it as a workbook will give you a base code …
    Whoa, that sounds good. Now what does that mean in layman's terms? I'm not nearly that advanced with this stuff. How can I make it work given what you said above?

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: .CSV to .XLSX Automatic Batch Conversion


    Macro Recorder is within Excel …

    So when activated, it records operations in a module code, a good code basis for beginners …

    You can also read integrated VBA help for methods Workbooks.Open and Workbooks.SaveAs
    and start yourself to write your procedure …

    Also I don't understand the need to convert csv files
    'cause Excel can directly load them even from the net …
    Last edited by Marc L; 03-30-2014 at 11:41 AM.

  7. #7
    Registered User
    Join Date
    03-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: .CSV to .XLSX Automatic Batch Conversion

    Thank you. I'll give that a try in a minute and see if I can make it work.

    The need to convert to .xlsx is driven by the inability of our file sharing service to display .csv files on all devices. We use Google Drive to host our sales reports which are automatically uploaded from a folder that receives the data directly from the stores. The data is given to the folder in .csv format and is not able to be exported in .xlsx. When we drag and drop the .csv files into GD, it automatically converts the file into Google Sheets, which can be accessed and read on any device. However, we have this system automated and for whatever reason, it doesn't convert to a Google Sheet. We have too many reports to open and close manually and to ask someone to do it every night would be incredibly inefficient.

    Ultimately, it comes down to Google Drive not being able to display .csv files on any device. .xlsx seems to work just fine.

    I hope that helps give some context to our issue.

  8. #8
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: .CSV to .XLSX Automatic Batch Conversion

    Hi prosemur,

    Try the attached file. It may do what you want.

    Lewis

    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    03-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: .CSV to .XLSX Automatic Batch Conversion

    I opened it and got it working. This is an amazing file. Thank you so much for sharing!

  10. #10
    Registered User
    Join Date
    10-21-2016
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    1

    Re: .CSV to .XLSX Automatic Batch Conversion

    My CSV file is comma delimited with semicolon.
    How shall I separate that when convert to Excel . XLSX ?

    Thank you so much.

  11. #11
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: .CSV to .XLSX Automatic Batch Conversion

    Hi jakkuson19 and welcome to ExcelForum,

    We are not allowed to answer your question, because you violated one of the Forum rules. Please repost your question in a new thread and reference this thread if needed.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

    Lewis

  12. #12
    Registered User
    Join Date
    03-30-2016
    Location
    Budapest
    MS-Off Ver
    2013
    Posts
    1

    Re: .CSV to .XLSX Automatic Batch Conversion

    Quote Originally Posted by LJMetzger View Post
    Hi prosemur,

    Try the attached file. It may do what you want.

    Lewis

    Please Login or Register  to view this content.
    I know it's been three years, but I love you!

  13. #13
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: .CSV to .XLSX Automatic Batch Conversion

    Several users have requested to have .csv files with other delimiters (even though cs stands for 'comma separated') saved as Excel .xlsx files. The attached Excel file has the capability of using .csv files with the following delimiters:
    a. Comma (,)
    b. Semicolon (; )
    c. Space
    d. Tab
    e. Vertical Bar (aka Pipe) (|)

    Several test .csv files are included in the attached .zip file.

    Limitations:
    a. File 'Scratch.csv' is used and can not be a 'data file' (always deleted to the bit bucket i.e. not to the 'Recycle Bin').
    b. Embedded 'delimiter' characters are not allowed, except in 'Comma Delimited .csv files' (double quotes).

    File tested in US using 32 bit Office 365.

    NOTE: I wanted to open the .csv files with the Workbooks.OpenText method (requires extension to be .txt), but I could not get file with Tab delimiters to work properly.

    Non-working Code excerpt follows (see the attached file for working code):
    Please Login or Register  to view this content.
    Lewis

  14. #14
    Registered User
    Join Date
    11-09-2013
    Location
    asd
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: .CSV to .XLSX Automatic Batch Conversion

    Awesome file! Some cells of my CSVs have a 0 (zero) at the beginning and they disappear when converting them to XLSX, is there a fix for this?

    Thanks!

  15. #15
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: .CSV to .XLSX Automatic Batch Conversion

    Quote Originally Posted by suraba View Post
    Awesome file! Some cells of my CSVs have a 0 (zero) at the beginning and they disappear when converting them to XLSX, is there a fix for this?

    Thanks!
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  16. #16
    Registered User
    Join Date
    08-07-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    1

    Re: .CSV to .XLSX Automatic Batch Conversion

    This is a great tool!

    I do have a question. I am exporting data to a SharePoint site from SQL Azure as csv files. Can I use this tool to automatically convert these to Excel on a schedule?

    Thanks

  17. #17
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: .CSV to .XLSX Automatic Batch Conversion

    I am exporting data to a SharePoint site from SQL Azure as csv files. Can I use this tool to automatically convert these to Excel on a schedule?
    I know nothing about SQL Azure or SharePoint as I am a dinosaur whose prime was in the 1970s.

    Once set up, the file should successfully be able to run from a schedule, if the source files are in the correct folder, that the file can access. You should be able to test that without a schedule.

    To run on a schedule requires additional work (either manual or via software) to get source files in the correct folder. If there are duplicate file names from day to day you may have to make allowance for that.

    Lewis

  18. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: .CSV to .XLSX Automatic Batch Conversion

    Quote Originally Posted by glsankar View Post
    This is a great tool!

    I do have a question. I am exporting data to a SharePoint site from SQL Azure as csv files. Can I use this tool to automatically convert these to Excel on a schedule?

    Thanks
    perhaps you missed my post immediately above yours?

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  19. #19
    Registered User
    Join Date
    08-08-2021
    Location
    Perth WA
    MS-Off Ver
    8.1
    Posts
    1

    Re: .CSV to .XLSX Automatic Batch Conversion

    I spent all day looking for this. I've just joined up today. Thank you so much. Lovely.

  20. #20
    Registered User
    Join Date
    08-14-2021
    Location
    Netherlands
    MS-Off Ver
    2006
    Posts
    3

    Re: .CSV to .XLSX Automatic Batch Conversion

    i know it has been 7 years, but i also love you!

  21. #21
    Registered User
    Join Date
    08-25-2021
    Location
    Anytown, USA
    MS-Off Ver
    365
    Posts
    13

    Re: .CSV to .XLSX Automatic Batch Conversion

    Ok, the lower big yellow text box is -surprise, surprise!- actually a button. It would be nice if there was something to indicate that.
    Thanks.
    Last edited by QMT; 08-26-2021 at 02:19 PM.

  22. #22
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: .CSV to .XLSX Automatic Batch Conversion

    wow, 1st you respond to a 7 year old thread (not that uncommon, but that usually happens with a "thanks")

    Then you slam help that was offered...only to discover you didnt look properly

    All of this for your very 1st post on our forum...way to make a good 1st impression.

  23. #23
    Registered User
    Join Date
    08-14-2021
    Location
    Netherlands
    MS-Off Ver
    2006
    Posts
    3

    Cool Re: .CSV to .XLSX Automatic Batch Conversion

    Dude, calm down. If you see so many thank you notes you can be 100% sure that you are doing something wrong or that you don't understand how it works and in stead of asking politely how to help your sorry little butt you act like you paid the world to bow to your needs. Get a mirror and do some double self reflection.

    In regards to the (more than excellent) excel sheet that saves me hours of work each day... Just read the instructions in the sheet and now that you have learned that the yellow boxes are buttons you are good to go. Make sure you download the file from the "11-15-2019, 12:15 PM" post. That is the latest version.

    Now, drink some thee, relax, look at the sun and the birds, and when your heart beat has dropped write a lovely thank you note to your fellow country man Lewis for coding the sheet and giving it away for free.

    All the best,

    DaFresco

    Karma Tip: Since you will become an expert in this sheet, why don't you make a short tutorial screenshare video and post that on youtube? That would be nice.

  24. #24
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: .CSV to .XLSX Automatic Batch Conversion

    QMT, please do not delete/modify posts after you have made them - especially in attempt to hide your initial poor reply.

    FWIW, here is your full initial post...
    -
    What am I missing??? I downloaded every link available on this thread. All I see is an xlsm file with big yellow text boxes and green blocks of cells with someone's path name... and a bunch of text saying that csv files will become xlsx files. There is nothing to run, nothing to click on, no macro in the Developer/Macros section. There is nothing. How does this DO anything?? I was really hoping for some code to convert my files. I'm completely baffled. (And also, this text box is infuriatingly NOT WRAPPING.)
    Ok, the lower big yellow text box is -surprise, surprise!- actually a button. It would be nice if there was something to indicate that.
    Thanks.
    oh, and BTW, DaFresco, I am perfectly calm (and always am).

    Courtesy and respect are the order of the day here, and if that is too much to ask of you, then perhaps a different forum would more than value your talented rhetoric, I sure am totally unimpressed with you. and another BTW, dont make assumptions without knowing at least some of the facts. The coder in question is is no countryman of mine, despite that fact that we both live in the same country.

    I hope this ends this pleasant discourse, so I can move on to matters that actually have some significance.

    Thanks
    Admin
    Last edited by AliGW; 08-27-2021 at 04:11 AM. Reason: Member names corrected

  25. #25
    Registered User
    Join Date
    08-14-2021
    Location
    Netherlands
    MS-Off Ver
    2006
    Posts
    3

    Re: .CSV to .XLSX Automatic Batch Conversion

    Hold up, you are mixing names up. I (dafresco) replied to QMT that he sould calm down and to support your (FDibbins) reaction. So that qoute isn't my post it's QMT. (my other post is that i love the TS) Can you edit your reply to have the correct names?

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: .CSV to .XLSX Automatic Batch Conversion

    @DaFresco

    I have amended my colleague's post to make it clear whom he was addressing.

    As for your post #23: who DO you think you are? If you continue in this vein, you will not remain a member here for very long. If you have something useful to add to the thread, by all means do so, but as a brand new member with no clout or kudos, you have no right to tell any other members, moderators or administrators how to behave. Do NOT post in this manner again.

    Thread closed.
    Last edited by AliGW; 08-27-2021 at 04:18 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  27. #27
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: .CSV to .XLSX Automatic Batch Conversion

    DaFrescomy apologies for pulling you into this by mistake, and thanks for the support

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with formula conversion of XLSX to 2003 format Excel
    By asanthadenz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2013, 12:10 AM
  2. Batch .iqy to xlsx conversion
    By nickfan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 09:32 AM
  3. Replies: 6
    Last Post: 04-19-2012, 03:27 PM
  4. xlsx top html conversion
    By rob171171 in forum Excel General
    Replies: 0
    Last Post: 03-14-2012, 03:29 AM
  5. Batch conversion to excel format
    By m3site in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2008, 11:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1