Share via

Excel export file without changing file type of original document?

Anonymous
2014-12-27T17:33:14+00:00

Hi

Is there a way to export a file without changing the file format type of original document?

So say I am working in myfile.xlsx and I want to export it to a csv file. Currently I can do a SAVE AS and choose CSV, but when after it is done exporting, the document has changed to myfile.csv and I am no longer working in myfile.xlsx. I have to re-save-as and choose xlsx now to get back to original document.

How can I export myfile.xlsx as a .csv instead of using Save As so that the original document I am working in stays as an xlsx?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2014-12-27T22:34:59+00:00

    Two key points :-)

    1. Export is just another name for Save As - the process is the same regardless of name, &
    2. File management on OS X is [pretty much] dictated by Apple

    If you're using a newer version of OS X (10.8 or Later) you might see if the Duplicate command is available from the File menu. It may be an acceptable alternative.

    Another option similar to what Bob G suggested;

    1. Right-click the sheet tab
    2. Choose Move or Copy
    3. Select (new book) from the To book dropdown
    4. Check Create a copy
    5. Click Close
    6. Enter a name for the new file
    7. Choose the preferred Format
    8. Click Save

    You'll be left working in the original file.

    2 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-27T21:41:43+00:00

    With all the years Excel has been around, I can't believe they have never created a simple EXPORT option.

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2014-12-27T22:07:28+00:00

    They have! Both Bob and I told you how to do it.

    0 comments
  3. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2014-12-27T20:10:14+00:00

    When you use Save As to generate a new file, the original file closes  & leaves open the newly created one. Simply close the CSV, choose Do NOT Save when prompted to save again, then select the original from File> Open Recent... it should be 2nd in the list.

    0 comments
  4. Anonymous
    2014-12-27T18:52:54+00:00

    Copy the worksheet to a new document and save that one as cvs. You can do this by right clicking on the sheet tab.

    0 comments