Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Hi i was requested to convert a file by one of my client.I need to convert a .tar file to a ms excel. I gave the below steps to them but some of the fields in the content are missing. Please suggest any?

  1. Select the desired GZ file to convert.
  2. Double click the file
  3. Extract the file (Right click and extract to the specified folder and select the destination to be stored).
  4. Open a new excel file
  5. Click the FILE tab and click OPEN in it.
  6. Select the desired file which is extracted at step 3.
  7. After selecting the extracted file, a pop up will appear like below just click NEXT tab in that pop up.
  8. Again it will ask for how to separate the fields in that excel. Just click NEXT tab again.
  9. Click Finish tab and a pop up will appear like below, just click OK in it. At last you will see the file in excel.
share|improve this question

closed as not a real question by Spiff, RedGrittyBrick, Nifle, Gnoupi, Tom Wijsman Apr 20 '12 at 17:04

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
What is the need for a tar.gz file? Isn't a zip file enough?: step 1: doubleclick the zip file, step 2: double click the excel file in it. That's all. –  mouviciel Apr 18 '12 at 7:37
    
It looks like, you are trying to extract the .tar file. –  Siva Charan Apr 18 '12 at 8:05
    
Yes it is a .tar file zipped in 7zip.... i need the .tar file content converted into a excel. –  Arun Kumar Apr 18 '12 at 8:34
1  
tar is an archive format, not a spreadsheet format. This question should be broken up into concrete pieces like "How can I extract a tarball on Windows?" or "How can I convert a file stored in format foo into something Excel understands?" –  CodeGnome Apr 19 '12 at 21:54
add comment

1 Answer

  • convert the gz file to a tar file (usually gzip -d file.gz but 7zip may have an option).
  • extract the csv file from the tar file (usually tar xvf file.tar).
  • use notepad or a text editor to visually confirm the content and format of the csv file.
  • import the csv file into excel.
    • ensure that excel's import dialogue identifies the columns correctly.
    • adjust separator etc as needed.
share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.