Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

excel save as csv missing rows columns

Posted on 2011-03-17
4
Medium Priority
?
262 Views
Last Modified: 2012-05-11
I starting working in a brand new excel sheet

I saved the sheet as a csv > closed > re-opened

after re-openining in excel noticed some of the columns and rows were missing?

when you open the file in excel and hit ctrl + end takes you to row 3171 but there is only 22 rows with data values

when opening in notepad noticed there are heaps or rows like this:
anyway to retrieve the missing rows?

,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
0
Comment
Question by:JCTDD
[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
  • 2
4 Comments
 
LVL 46

Expert Comment

by:aikimark
ID: 35164934
please post the workbook

Excel might think there are non-empty cells, which it tries to export.  This EE article describes a procedure to tighten up the used range:
http://www.experts-exchange.com/A_2415.html

This EE article details CSV/Excel interaction:
http://www.experts-exchange.com/A_3509.html
0
 
LVL 20

Expert Comment

by:Ardhendu Sarangi
ID: 35165003
can you post the csv file here please?

In excel, "" is deemed as empty space therefore you are seeing the blank rows. one way to view all the rows from CSV in excel is to

1. open the csv file in notepad,
2. do a replace "" with "--" or any other symbol you feel is appropriate. don't use comma's here :)
3. save the csv file.
4. re-open in excel.


see if that helps, or else you can always post the csv file here too,

thanks,
ardhendu
 
0
 

Accepted Solution

by:
JCTDD earned 0 total points
ID: 35176849
This was a user error I have advised the user to save as xls if the sheet contains any formatting. The "" that appear are missing cells and cannot be recovered. Cannot paste the csv because it contains work sensitive data.

Thanks for all your responses.
0
 

Author Closing Comment

by:JCTDD
ID: 35213321
This was a user error I have advised the user to save as xls if the sheet contains any formatting.
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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

610 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