Fermé

Google Sheet to Excel and Vice Versa

Right, here we go, so to explain this as clearly as possible. I work in a company that uses excel sheets that I have coded to simply reference other sheets and documents to produce certain calculations etc. Where we are attempting to move to is a google sheet which has its problems. This is because excel uses reference codes for certain results, and google uses other references obviously from a copyright point of view.

What I am looking for is to see if a google document can read an excel via a code which in turn communicates between both programs when you import it to a google doc.

I am not sure if this can be done and also the level of complexity may be far and beyond what is currently available out there in the market, purely from a google and Microsoft issue to allow the programs to do this.

Firstly I want to establish communication of how and if this can be done, then potentially after I have been satisfied with the response, move forward with an action plan if is can be done. I have sheets that I uploaded that I want to merge through to a google sheet, as you will see, if drops the references, I will also have to share you into my document that sits live in google drive. I have passwords locked on my excel that I can provide, yet as we all know it is easy enough to crack them.

Thanks

Heath

Hi there, I am going to have to move my google drive files to another location due to it being in my corporate section where I cannot share it out to anyone. So I will change the setting and attempt to delete the current files and upload new ones tonight.

Thanks
Heath, essentially the process of the excel into a google sheet doesn't change really. If you grab one of these excel sheets and convert it, it will show you the issue which happens of formulas and reference cells dropping out.

Compétences : Excel, Google Chrome

Voir plus : what is google code, google documents, excel macros google sheet, number results google search keyword search excel sheet, google send emails addresses excel sheet, google excel sheet, retrieve longitude latitude excel sheet google, data excel sheet macro, excel sheet marketing research survey data entry, excel sheet indian states cities, find entry excel sheet, excel sheet cities world

Concernant l'employeur :
( 5 commentaires ) Browns Plains, Australia

N° du projet : #8483108

28 freelance ont fait une offre moyenne de 140 $ pour ce travail

srinichal

I am an expert in delivering custom software and scripts willing to discuss further abut the project details

231 $ USD en 5 jours
(14 Commentaires)
5.2
AlexandrK1

A proposal has not yet been provided

250 $ USD en 7 jours
(13 Commentaires)
4.5
someka

What about to create all referencing excels in google sheets? You dont need to recruit me now. Drop me a message and i can make a trial study for you. If you get happy, we can proceed. (as i want some good reference Plus

94 $ USD en 2 jours
(37 Commentaires)
4.7
TonmoyRoy111

A proposal has not yet been provided

138 $ USD en 3 jours
(29 Commentaires)
3.9
citijayamala

i am an expert in Excel and can work on google spreadsheets as well. i have sound knowledge in Google docs and Excel and well. Jayamala from India Hire Me

98 $ USD en 3 jours
(17 Commentaires)
4.0
barkatmulani

I've been working in developing Google Spreadsheet Apps. since last few years after having extensive experience working with Excel. I started working in Excel since the start of my career in 1998. MS Office used to Plus

90 $ USD en 3 jours
(6 Commentaires)
2.9
kapekape

I AM AN EXPERT IN AUTOMATION, EXCEL, VB AND MACROS SKYPE = kapekmonho ph. 0836705645 My solution to this problem is to use to use VBA in excel create text file to record all reference’s in a formulae in a (row colu Plus

277 $ USD en 10 jours
(6 Commentaires)
3.4
Tanveer2u

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
subrata4

A proposal has not yet been provided

244 $ USD en 3 jours
(0 Commentaires)
0.0
akousor

I have been working in excel for the last 10 years. My speed of typing is excellent. Some are the skills that I have acquired in excel are: Pivot, If formulas, Calculations, Charts, V look up, Validation, Conversion et Plus

122 $ USD en 3 jours
(0 Commentaires)
0.0
joniter

I was pleased to learn of your need of a data entry person. I am a degree holder in Business Management. Since intermediate year in school to my current job , I' ve been exposed to computer application such as MS Word Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
kdoffice365

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
amitchaule78

I already worked like this project before. and I have vast industry standard experience as well. I have to deliver the project on time.

166 $ USD en 4 jours
(0 Commentaires)
0.0
riyadi80

I have a good excel skill and attention to detail which may help to finished the task according to the timeline

111 $ USD en 3 jours
(0 Commentaires)
0.0
thevijaysingh

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
jatinpatel05

I found your problem statement interesting I have tried to do same thing using csv.. I found our that we can write code on Google drive and can load code to Google sheets which helps us to do additional operation which Plus

56 $ USD en 15 jours
(0 Commentaires)
0.0
sagarssj

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
vishvant07

An evaluation of the device cannot be performed as the device was not returned to the manufacturer. Additional information (including x-rays and medical records) has been requested. Should additional information become Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
kumdin80

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
Sevaram1986

A proposal has not yet been provided

111 $ USD en 2 jours
(0 Commentaires)
0.0