How to Edit PDF in Google Drive?

Many of us store and manage PDF files in Google Drive. It is an excellent tool if we want to share the files with someone or access them remotely. However, when it comes to editing, that is a bit more difficult because PDF is hard to modify, and there are still no inbuilt editing features that come with the tool. Of course, it is still possible to alter a PDF document, regardless of whether it is a table, presentation or text.
All you need to do is convert it to one of the formats Google Drive is able to work with. These formats are:

1) Google Docs

To transform a PDF into textual format, right click on it and choose Open with – Google Docs. Even the contents from scanned files will be accurately extracted.

open with google docs

2) Google Sheets

Getting tables from PDF into editable format is possible as well. All you need to do is install the Cometdocs PDF converter app.

cometdocs pdf converter app

Right click the file, choose Open with – Cometdocs and choose Excel as the conversion format.

convert to google sheets pdf

After that you need to wait a couple of minutes before the new file is downloaded to the same folder where the original is located. As you’ll see, the row and column recognition in sheets is the same as in the PDF table. The file is all ready to start analyzing.

google tables

3) Google Slides

Presentations can also be converted. Right click the file, choose Open with – Cometdocs  and then choose PowerPoint.

pdf to powerpoint

After the document is converted, simply choose Open with – Google Slides and the document will be ready for further modification.

pdf to presentation google drive

How to Split PDF into Separate Files with Google Chrome?

Some PDF files are huge, and there are situations when we only need a small part of a PDF for our purposes. For example, we might need to extract only one table from a document which contains more than 300 pages. Instead of converting the whole document into an editable format, we can first extract a specific page that contains the table we need, and then continue with the conversion.

There are a lot of PDF splitters around that help users extract parts of PDF. Today we’ll introduce one which is not completely safe, but you probably already have it installed on your computer. That is the Google Chrome browser.

The first step requires you to open your PDF in Chrome. You can do it simply by dragging the PDF to any spot on a new tab in Chrome.

drag to open pdf in google chrome

When the file opens, choose Print (or press CTRL + P).

google chrome print
In the list of Printers choose Chrome’s internal PDF printer (Save as PDF).

save as pdf chrome

Below enter all pages you want the new PDF to contain. It can be a single page, a range of pages or both.
Click Save and that would be it. The new document is right and ready for use.

How to Convert a PDF Presentation to Google Slides?

Presentations often come in PDF format. It is much better to format them that way because we don’t have to worry whether the images, graphs and sentences will lose their formatting and layout on somebody else’s computer (especially if we’ll be using our professor’s or boss’s computer when we hold the presentation).

However, we might need to convert the presentation back to editable format, for example PowerPoint or Google Slides. Google Slides as part of the Google Drive interface is a powerful way to edit our presentations on the go and completely free.

While there is a way to convert PDF to Docs format, it is not possible to convert it to Slides, at least not directly. But in this situation the Cometdocs PDF converter Google Drive extension can really be of use.

All you have to do is install it from your Chrome browser.

After that simply go to your Google Drive, right-click the presentation locked in PDF format and choose Open with Cometdocs PDF converter.

convert to google drive
Select PowerPoint as your desired format.

convert to powerpoint

You might need to wait a couple of minutes depending on the file size, but not much longer than that.

converting pdf inside google drive

The newly created presentation in pptx format will open immediately. To continue editing it, choose Open with – Google slides once more.

google slides

And that will be enough. You can continue to work on the presentation, making all the necessary revisions.

As you can see, inside your Drive you will have the presentation in three file formats, PDF, PowerPoint and Google Slides.

converted files original

As we previously explained, the same is possible for tables in Google Sheets.

Tips for Using Google Sheets on Android and iOS

We have already shown you how you can convert PDF tables to Google Sheets, and now we can talk about what happens when you have a spreadsheet ready for further editing. On mobile phones the Google Sheets interface is different than on the web, which is why some things are done differently. The following tips for using Google Sheets on mobile phones are valid both for Android and iOS systems.

1.  Freeze rows

To freeze a row or column, first select it. Tap anywhere on the selected section and new options will appear.

more options in google sheets

Tap on them and choose Freeze.

freeze column or a row

Sometimes the Freeze option is immediately visible and sometimes you need to continue tapping.

2. Resize rows and columns

To resize a row or column, select it and tap on the upper part near the column letter or number. Then drag the row or column to increase or decrease it. While dragging one line, it will turn into a double line.

increase column row size

On smaller screens this might not be easy to do, but you just have to tap very precisely on a particular spot.

3. Insert function

To insert a function, simply tap on the cell and then on the field below. Enter the equal sign followed by a function name, and enter all the necessary arguments.

entering formula in google sheets

Sometimes the autocorrect might interfere with entering functions, so be prepared for that.

4. Change cell format

This one might seem tricky. If your cell is formatted as a number but you want it to be formatted as text or date, here is what you can do. Tap on the A letter in the upper menu and choose Cell.

format cells google sheets

In the field Number format choose the appropriate number.

number format

On the other side in the Text tab you can change the cell’s look, font, size, color and more.

5. Save as Excel

If you want to save the spreadsheet in Excel format, which you may want to send by email to someone, simply tap the More settings.

settings google sheets more options

Choose Share & Export and then Save as Excel.

share and export google sheets file

save google sheets as excel

6. Use Autofill

The Autofill function is an extreme time saver. It exists in mobile version as well. To use it, simply enter a couple of the first elements in a sequence (for example: 1, 2, 3 in a row or column), select a portion of the row or column that needs to be filled till the end as started, tap on the selection and choose Autofill when it appears.

autofil data in google sheets

The selection will be filled with appropriate elements that logically follow what you entered (for example: 4, 5, 6…).

What to Do When a CSV File Can’t Fit into Excel?

Microsoft Excel has a limit on the number of rows it supports.  The limit is 1,048,576 rows or 16,384 columns. If you are trying to open a csv file that contains an exceeding number of rows or columns in Excel, the software will send a notification that the file is not loaded completely. Understandingly, that is not what we need; we need to open the whole file.

What to do in such cases?

file not loaded completely

The solution for the file in csv format is to split it into multiple parts. Simply download the Free Huge CSV Splitter software which is compatible with all platforms.

The tool is pretty simple to use. Open it and enter a desired line count in your CSV file. You can enter up to 1 000 000 lines. Choose the desired file and click OK.

csv file

The splitting will take only a couple of minutes, after which you can open all parts without a problem.