2

I'm trying to create a Google My Map based on addresses in a Google Sheet "file". This seems to work OK following the standard instructions, except that I can't seem to extract data on anything except the first sheet within that file; it doesn't allow me to select columns from another sheet. The steps I am following are:

  • Within my Google Map, select Add layer.

  • Select Import.

  • Select my Google Sheet file from My Drive.

  • I now only see column titles from my first sheet.

Am I doing something wrong? Is this not supported?

Improve this question
2
  • I doubt this is your problem, but it is worth investigating to be sure: the import function will only recognize the first 2000 rows. If your first page happens to have greater than 2000 rows, then it may be that the other pages's columns will not appear as options. See support.google.com/mymaps/answer/3024937
    – hunterhogan
    Jan 9, 2015 at 22:20
  • 1
    @HunterHogan, thanks for the thought, but no, that's not my problem. All my sheets are much shorter than that.
    – Andrew Ferrier
    Jan 10, 2015 at 12:25

1 Answer 1

Reset to default
1

Google My Maps will only import data from the first, or leftmost, worksheet in a sheets file.

You can still import multiple worksheets. First, import one worksheet and create a map layer. Then reposition the worksheets so the next one is in the leftmost position and import to the next map layer.

Rinse and repeat.

reposition sheet tab position

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.