Anyone here know anything about Excel??

Gravitas

I'm asking on behalf of a friend.

He needs to be able to convert one Excel format
to another online spreadsheet format.

It involves transferring 3600 Excel cells
to an online spreadsheet format
including grabbing 300+ web links,
frame grabbing thumbnail images
and inserting them into Excel.

Is there an easy way to do this?

Thank you in advance.

mulletsaison

What’s the other spreadsheet? Might be easiest to save as CSV then import; most spreadsheet applications will handle CSV seamlessly. Though the images might be harder. Consider https://Airtable.com... might be useful.

Gravitas

@mulletsaison said:
What’s the other spreadsheet? Might be easiest to save as CSV then import; most spreadsheet applications will handle CSV seamlessly.

Yup, that was one suggestion and apparently he said it wasn't possible.

Let me see if I can find out the online spreadsheet format.

Thank you for answering.

fprintf

@mulletsaison said:
What’s the other spreadsheet? Might be easiest to save as CSV then import; most spreadsheet applications will handle CSV seamlessly.

This is exactly the way I'd do it also. But I'm not sure a comma delimited file or CSV can handle the import of the images - these aren't usually native to spreadsheet applications. the web links themselves should be easily handled however.

wim

@Gravitas said:
I'm asking on behalf of a friend.

He needs to be able to convert one Excel format
to another online spreadsheet format.

It involves transferring 3600 Excel cells
to an online spreadsheet format
including grabbing 300+ web links,
frame grabbing thumbnail images
and inserting them into Excel.

Is there an easy way to do this?

Thank you in advance.

What types of files can the online spreadsheet import? Excel can export as a web page. Maybe the other spreadsheet can import from a web page? That seems like it might pick up the images OK.

Gravitas

@mulletsaison

I'll pass on the link...

and @fprintf

Thank you for replying as well.

I'm currently waiting for further info.

mrufino1

This may sound silly, but can you just copy and paste the cells between the two formats? I’m very glad to not use spreadsheets anymore in my life.

Gravitas

@wim said:

What types of files can the online spreadsheet import? Excel can export as a web page. Maybe the other spreadsheet can import from a web page? That seems like it might pick up the images OK.

I have no idea of the end format.
It's the one piece of information I'm missing otherwise
I would've included that in the original request.

As I've mentioned I'm waiting for a reply.

Gravitas

@mrufino1 said:
This may sound silly, but can you just copy and paste the cells between the two formats? I’m very glad to not use spreadsheets anymore in my life.

Yeah, that was one of the questions as well.
Apparently not.

I have no idea about spreadsheets.

The last time I looked at Excel was in the 90's.

Gravitas

Okay, I'm waiting until he gets back
to me with further information.

Thank you all.

espiegel123

@Gravitas said:
I'm asking on behalf of a friend.

He needs to be able to convert one Excel format
to another online spreadsheet format.

It involves transferring 3600 Excel cells
to an online spreadsheet format
including grabbing 300+ web links,
frame grabbing thumbnail images
and inserting them into Excel.

Is there an easy way to do this?

Thank you in advance.

Has your friend checked to see if the other spreadsheet supports importing Excel -- even Google Sheets will import Excel spreadsheets directly without needing to export to CSV. Some excel features aren't imported (like PivotTables).

Gravitas

Update.

They've got it sorted now.

Thank you very much your assistance.

Much appreciated.

mulletsaison

@Gravitas said:
Update.

They've got it sorted now.

Thank you very much your assistance.

Much appreciated.

Great to hear...