Solved

excel save as csv missing rows columns

Posted on 2011-03-17
4
260 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 45

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
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.

729 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