Excel: How to add a table into a single cell

[champ01]

I need to import CSV files into the backend of my website.
In Excel column D represents product specs (D2 is product specs of Product Y, D3 specs for product X etc etc.)
All the specs I made are in Tables.

How can I create a Table into a single cell?

 

[saotomefirst]

Weeeeeeeeeeeeeeeeeeeeellllllllllll You are asking for something impossible... Cells fit into tables, not the opposite

However, a possible workaround would be to use the HIPERLINK function. It should give you the result you want, but I'm not sure if this is supported in recent Excel versions - I work with 2003

Here is an example:

=HYPERLINK("[Y-spreadsheed.xls]sheet2!A1","Y item specs")

where
HYPERLINK -> receives text parameters (remember to use the "")
[Y-spreadsheed.xls] -> name of an external file to your desired spreadsheet
sheet2 -> the name of the sheet you want to work with inside the file
!A1 -> the cell where the cursor will be when it opens
Y item specs -> what the user will read in the cell (make sure it makes sense XD)

Hope this helps

 

[champ01]

I'm a real noob when it comes to Excel (i'm using Excel for Mac)

Here is an example of what needs to be happening.

 

[James_C]

In any version of Excel is it not possible to build a table into a single excel cell, normally when creating a csv file you match the fields that the application expects to the columns in an Excel spreadsheet. What you need to do is look at the output you need and then work backwards to build the worksheet. See the attached Excel screenshot with the associated CSV output. If this is not what you need, please can you post the an example of the CSV output then we may be able to help you better.