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

  • Thread starter Thread starter Jackanorry
  • Start date Start date
J

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
 
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
 
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.




JR Hester said:
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 said:
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
Click to expand...
Click to expand...
 
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


Jackanorry said:
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.




JR Hester said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top