Extra/empty records in CSV file

[Guest]

I have an Excel file that I convert into a CSV file. The information in this
file is usually no more than 400 records. If I view the CSV file in Notepad,
sometimes the file contains 65,000+ records, which has my 400 records and
empty lines that contain commas only. But sometimes it only contains my 400
records. I need to figure out how to eliminate the extra records because I
have to import this into my payroll software.

 

[Guest]

Hi Jessica,

Sometimes there are cells that look empty to you, but which Excel thinks are
relevant to your extract due to formatting or unintended edits to cells
outside the range of data you want. To check this press Ctrl^End to see what
Excel thinks is the bottom right of the used spreadsheet range. In the sheets
that are creating 65,000+ row csv files I expect that Ctrl^End takes you to
somewhere on row 65,536 which is the bottom row that Excel supports.

To fix this, before saving the csv file select and delete all the rows below
the data range that you want. (use Shift^Ctrl^Down from the first row below
your active data range, and then select Edit / Delete / Entire Row from the
menu bar)

Note: You may also want to delete unused columns tot ht right of the active
data range.

Hope that helps,

TK

 

[Dave Peterson]

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused