Ask Your Question
0

Convert from Google docs to LibreOffice

asked 2014-03-23 12:19:40 +0200

mbnoimi gravatar image

updated 2014-03-23 12:24:09 +0200

Hi,

I use LO but recently I forced to use Google docs just for collaborating causes. Now after ton of modifications on my Google doc spreadsheet I want to revert back to LO.

Does anyone know how can I convert Google docs spreadsheet to LibreOffice Calc?

P.S.

  • Download as .ods doesn't work because it generates plain Calc file!
  • I tired to use OOo2GD but it doesn't fix plain Calc file (ex. it didn't bring Validations)
edit retag flag offensive close merge delete

Comments

What elements of the google doc are missing? Values? Formulas? Downloading as both ODS and XSLX preserve Formulas for me. Perhaps try downloading as XSLX and opening in Excel or LibreOffice. Some functions may not be directly translatable between formats.

黄智壯 gravatar image黄智壯 ( 2014-03-24 04:56:43 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2015-10-08 16:23:14 +0200

LKeithJordan gravatar image

Download the spreadsheet from Google Sheets. This will convert the file to an Excel file format. Open the file with LO Calc and save in ods file format. Scrutinize your spreadsheet to correct for any file conversion issues.

(Please click the check next to my post if you believe mine is the best answer to your question.)

edit flag offensive delete link more
0

answered 2015-10-08 18:14:26 +0200

Google Drive supports OpenDocument 1.2 Extended strictly, and is the only OpenDocument it supports. Use that.

Alternative way is CTRL+A to select everything, then CTRL+V into Calc.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2014-03-23 12:19:40 +0200

Seen: 3,383 times

Last updated: Oct 08 '15