<div>
Why don't just edit the .csv on a text editor (like notepad) and remove these lines?<br />
Then you can import the .csv as a text file, selecting the comma as the separator character.<br />
<br />
Hope it helps.
</div>


Why don't just edit the .csv on a text editor (like notepad) and remove these lines?
Then you can import the .csv as a text file, selecting the comma as the separator character.

Hope it helps.

<div>
The data would go into the spreadsheet in two continuous columns then?<br />
<br />
I would like 4 columns<br />
<br />
date, item1, date, item2
</div>


The data would go into the spreadsheet in two continuous columns then?

I would like 4 columns

date, item1, date, item2

<div>
No, data will go on different rows.<br />
<br />
However, once you have the pairs on different rows, you can manipulate the worksheet to combine two rows in one row.
</div>


No, data will go on different rows.

However, once you have the pairs on different rows, you can manipulate the worksheet to combine two rows in one row.

<div>
Just import the whole file into one sheet and just extract the data you want into another using standard Excel cross sheet referencing.
</div>


Just import the whole file into one sheet and just extract the data you want into another using standard Excel cross sheet referencing.

<div>
excel didn't get me the result i wanted
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a csv file that has been exported from a storage controller and the format is like this. &nbsp;<br />
<br />
line1<br />
line2<br />
line3<br />
line4<br />
line5<br />
date, item1<br />
value, value<br />
value, value<br />
line7<br />
line8<br />
line9<br />
line10<br />
line11<br />
date, item2<br />
value, value<br />
value, value<br />
value, value<br />
value, value<br />
<br />
I would like to read the data after line 5 and 11 into a excel spreadsheet. &nbsp;Can it be done using a macro ? <br />
<br />
so the fields i would have would be<br />
<br />
date, item1, date, item2
</div>
</div>


Hi,

I have a csv file that has been exported from a storage controller and the format is like this.  

line1
line2
line3
line4
line5
date, item1
value, value
value, value
line7
line8
line9
line10
line11
date, item2
value, value
value, value
value, value
value, value

I would like to read the data after line 5 and 11 into a excel spreadsheet.  Can it be done using a macro ? 

so the fields i would have would be

date, item1, date, item2

import csv to excel macro

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.