+ Reply to Thread
Results 1 to 18 of 18

how to convert xlsx file to csv file

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Question how to convert xlsx file to csv file

    hello everyone,
    i have data in xlsx format and i want it in csv format.
    how to do that.
    i have tried...
    1) save file as and save file as .csv
    2)tried Google convertor to change the file
    and
    3) after rename the file and convert the file into .csv i got error while opening file that i given in attachment please go through it.
    and csv file is opened with error.
    i am using phpmyadmin to access database. i want to restore .csv file into table it gives me error.
    can anyone help me here??
    thanks in advance
    regards
    learner_01
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: how to convert xlsx file to csv file

    I can open the file when i change your files extension to .xlsx
    How convert from .xlsx to .csv >>> click "save as", choose "save as type" as ".csv"

    Hope this help!

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    I just downloaded your file and me too got an error saying that the file is in different format and I clicked Yes and Opened it and again saved the file as .csv extension and not getting any error (File is attached).

    I believe you might have just changed the file extension to .CSV instead of properly converting it as CSV file.
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello sir,
    ya that i already do it properly before also, but format of data changes. hows that possible?
    In xlsx file in that table the cells are in date time format as yyyy-mm-dd hh:mm:ss but i converted into(I mean saved to) csv file it get automatically changes to dd-mm-yyyy hh:mm:ss am/pm can you know any method to changing .xlsx to .csv file without changing the format of my data??
    regards
    learner_01

  5. #5
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: how to convert xlsx file to csv file

    I am not see this question when i save file as "comma delimited".
    still the same format as yyyy-mm-dd hh:mm:ss.

    Hope other can help you.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    The file which I have attached in Post #3 is showing the data in yyyy-mm-dd hh:mm:ss format, did you seen it?

  7. #7
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello sir,
    i have seen that sir but sorry to say that is not in format of yyyy-mm-dd hh:mm:ss
    i have checked it.
    regards
    learner_01

  8. #8
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: how to convert xlsx file to csv file

    Please post a sample answer for A2.for clarify. Thanks

  9. #9
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello sir,
    i am so sorry i had given first csv file in attachment, i should give you you xlsx file. And in my question i have mentioned that i want to convert a xlsx file without changing the date format into csv file.
    hope you got the question now.
    regards
    learner_01
    Attached Files Attached Files

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    csv is not allowing to keep the date & time format in the way which you are having in your xlsx file

  11. #11
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello,
    yes sir exactly.
    is their any other solution to this?
    regards
    learner_01

  12. #12
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    I believe access will allow you to import xlsx file, or correct me if I am wrong

  13. #13
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello,
    but i am not using access.
    learner_01

  14. #14
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello,
    i can't use access as my database.
    i am using mysql using phpmyadmin which is by default. and phpmyadmin date time format is yyyy-mm-dd hh:mm:ss which i can't change. and phpmyadmin support .csv file only.
    please help.
    regards
    learner_01

  15. #15
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    Oh! sorry I don't know anything about phpmyadmin, at the same time csv is not allowing the desired date/time format so I can't able to suggest....

  16. #16
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    ohh... now?? what should i do??

  17. #17
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello everyone,
    can anyone know the solution??
    regards
    learner_01

  18. #18
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: how to convert xlsx file to csv file

    I believe I found it

    ControlPanel>>Regional & Language Options>>Regional Options>>Customize>>Date>>Short Date Format>>yyyy-MM-dd>>Apply>>Ok>>Apply>>Ok.

    Now open the excel file and save it as CSV.

  19. #19
    Registered User
    Join Date
    04-02-2013
    Location
    on earth
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    28

    Re: how to convert xlsx file to csv file

    hello sir,
    thanks a lot.you solved my problem.
    thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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