Apr 16, 2019

exporting google sheets to excel, formula problem

hi, (sorry for bad english)

i tried to export one google sheet to excel. but some formula contain cells incorrect on excel.

google sheets values: https://snag.gy/JrsnT6.jpg

exported on excel: https://snag.gy/zolFg1.jpg

this is first formula in cell:

=query(importrange("****sheeturl****";"'page'!a1:y");"select sum (Col15) where (Col1) contains '"&B902&"' label sum (Col15) ''")

exported file first formula: =IFERROR(__xludf.DUMMYFUNCTION("query(importrange(""****FILEURL****"",""'PAGE'!a1:y""),""select sum (Col15) where (Col1) contains '""&B901&""' label sum (Col15) ''"")");176,611001964636)

edit: i know excel doesn't support some formulas. i want just values.

Details

Sheets,Microsoft Windows,Personal use

Locked

Informational notification.

This question is locked and replying has been disabled.

Community content may not be verified or up-to-date. Learn more.

Last edited Apr 16, 2019

All Replies (12)

mchall

Apr 16, 2019

if you just wants values

copy & pastes the whole query datas as values before export?

Gill S

Platinum Product Expert

Apr 16, 2019

Might I ask why you need to export to Excel?

Yunus Laçin

Original Poster

Apr 16, 2019

Gill S

i will send as e-mail attachment for someone not using google sheets.

Marco Cet

May 24, 2019

I have the same problem. Did you manage to solve it?

Lance.NYC

Product Expert Alumni

May 24, 2019

Export the Sheet to .csv - it's data only and universally compatible.

anthony hollis

Aug 20, 2019

exporting to .cvs did not work, file- download- and open file excel did not work, the formulas do not carry over? trying to use google finance price change updates for daily stock prices and formulas for average daily change. These do not convert over to excel? Is there an add on to download in excel or someway to switch over to excel?

In case anyone wants to know why I need excel is because all other templates are on excel and my office likes using excel....thats only reason

KarlS

Diamond Product Expert

Forum volunteer, not Google employee

Aug 20, 2019

@Anthony hollis,

The GOOGLEFINANCE() function is specific to Google Sheets and will not be correctly converted to an Excel function. I do believe there are tools within Excel to do this but I don't know how to use them.

As I mentioned in the other post (which I was typing while you were posting here it looks like), we are good at helping people convert from Excel to Sheets but generally have a hard time helping people convert from Sheets to Excel. Many of us don't have access to Excel at all and very few of us use it daily. You will probably get the best results if you try asking for help in an Excel forum since their experts will have much more familiarity with Excel and the methods needed to accomplish what you need in Excel than we do.

Debbie Pantenburg

Oct 3, 2019

Since I do business with people who have Excel, it's frustrating to work in Sheets (preferred) and then not have a compatible download experience. The formulas, conditional formatting, and spacing doesn't convert correctly.

Frédéric Burdet

Nov 12, 2019

Hey! Same problem here. Very annoying. We need to share our google spreadsheet with people whose workplaces are not allowed to access google.

So I need to export as excel.

Can't you make an "export values only to excel" function? They actually don't need the formulas.

We have several worksheets so copying them one by one and pasting values only is horrible.

Thanks in advance

Lance.NYC

Product Expert Alumni

Nov 12, 2019

Export to CSV is export values only

Stop TxDotI45

Feb 17, 2020

so I can select which columns to sort 1st, 2nd, etc and format a column for phone numbers. can't do this in sheets.

Google user

Feb 26, 2020

I also need this functionality -- need a way to export values to Excel