Import data csv file - tab delimited - and sort to column

[Jackanorry]

Hi,

I'm attempting to import data from a csv file and sort it to it's column

I.E. data
[date] 1 2 3 4 5 6 7

column(s) to import too equal data imported

1 2 3 4 5 6 7 .... 49

Thanks

 

[JR Hester]

Your header refers to csv file tab delimited which is somewhat confusing.
Eitehr teh file is a (C)omma (S)eparated (V)alue file which Excel wil open
and parse automatically or it is a tab delimited file. If you have the
latter,and it does have a >csv extension change the extension to something
like .txt. Then click on teh file and choose open with Excel.
Excel will then attempt to open and offer you dialog boxes to select the
type of delimiter used. answer based on contents of yoru file and data will
display in Excel format. When saving be sure to save as an Excel file.

I have experieced some "csv" files which were not in true CSV format-- the
developer put quotes around all data including the commas. This caused
everything to import into one cell for each row of data. If this is what you
are facing, try a basic text editor, like Notepad-- replace all quote
characters (") with nothing (), then try the open process.

HTH

 

[Jackanorry]

JR,

Thanks for you reply.

Here's what the data looks like when imported as txt file and looks the same
when imported as csv.

Date 1 2 3 4 5 6 7 8
Sep-25 05 17 19 25 31 38 46 04
Oct-30 09 10 14 17 18 19 46 06
Oct-23 07 10 12 23 25 36 18 04
Oct-16 10 18 20 31 35 44 29 04
Oct-09 15 25 38 42 46 47 26 05
Oct-02 27 28 29 31 32 35 11 08
Nov-27 11 15 24 26 37 38 43 17
Nov-20 02 08 28 30 36 39 42 24
Nov-13 08 18 27 28 38 41 48 36
Nov-06 07 08 11 16 17 18 12 02
Dec-25 08 09 12 13 29 30 31 47
Dec-18 08 10 15 17 33 34 35 13
Dec-11 01 04 05 07 22 29 48 13
Dec-04 06 13 19 32 35 40 07 01

What I'd like to accomplish is to have the data filtered to appropriate column
i.e. 5 should import to column with 5 at the top of column.

The eighth number would be filtered to bonus.

Your header refers to csv file tab delimited which is somewhat confusing.
Eitehr teh file is a (C)omma (S)eparated (V)alue file which Excel wil open
and parse automatically or it is a tab delimited file. If you have the
latter,and it does have a >csv extension change the extension to something
like .txt. Then click on teh file and choose open with Excel.
Excel will then attempt to open and offer you dialog boxes to select the
type of delimiter used. answer based on contents of yoru file and data will
display in Excel format. When saving be sure to save as an Excel file.

I have experieced some "csv" files which were not in true CSV format-- the
developer put quotes around all data including the commas. This caused
everything to import into one cell for each row of data. If this is what you
are facing, try a basic text editor, like Notepad-- replace all quote
characters (") with nothing (), then try the open process.

HTH

Hi,

I'm attempting to import data from a csv file and sort it to it's column

I.E. data
[date] 1 2 3 4 5 6 7

column(s) to import too equal data imported

1 2 3 4 5 6 7 .... 49

Thanks

 

[Jackanorry]

Hi all - happy New Year,

I've updated how I hope to draw the data into the tracking sheet.

I have managed to get this < IF(data!$B$2=5,5,"x"> formula to return a
result, but it would mean manually entering and updating each individual cell
reference.

I've attempted to use this < =IF(data!$B$2:data!$H$2=B1:AX1," ","x") > which
returns x up to cell h2 and error # value! in any cell after.

Any insight / help would be appreciated.

TIA,
John

JR,

Thanks for you reply.

Here's what the data looks like when imported as txt file and looks the same
when imported as csv.

Date 1 2 3 4 5 6 7 8
Sep-25 05 17 19 25 31 38 46 04
Oct-30 09 10 14 17 18 19 46 06
Oct-23 07 10 12 23 25 36 18 04
Oct-16 10 18 20 31 35 44 29 04
Oct-09 15 25 38 42 46 47 26 05
Oct-02 27 28 29 31 32 35 11 08
Nov-27 11 15 24 26 37 38 43 17
Nov-20 02 08 28 30 36 39 42 24
Nov-13 08 18 27 28 38 41 48 36
Nov-06 07 08 11 16 17 18 12 02
Dec-25 08 09 12 13 29 30 31 47
Dec-18 08 10 15 17 33 34 35 13
Dec-11 01 04 05 07 22 29 48 13
Dec-04 06 13 19 32 35 40 07 01

What I'd like to accomplish is to have the data filtered to appropriate column
i.e. 5 should import to column with 5 at the top of column.

The eighth number would be filtered to bonus.

Your header refers to csv file tab delimited which is somewhat confusing.
Eitehr teh file is a (C)omma (S)eparated (V)alue file which Excel wil open
and parse automatically or it is a tab delimited file. If you have the
latter,and it does have a >csv extension change the extension to something
like .txt. Then click on teh file and choose open with Excel.
Excel will then attempt to open and offer you dialog boxes to select the
type of delimiter used. answer based on contents of yoru file and data will
display in Excel format. When saving be sure to save as an Excel file.

I have experieced some "csv" files which were not in true CSV format-- the
developer put quotes around all data including the commas. This caused
everything to import into one cell for each row of data. If this is what you
are facing, try a basic text editor, like Notepad-- replace all quote
characters (") with nothing (), then try the open process.

HTH

Hi,

I'm attempting to import data from a csv file and sort it to it's column

I.E. data
[date] 1 2 3 4 5 6 7

column(s) to import too equal data imported

1 2 3 4 5 6 7 .... 49

Thanks