dev3lopcom, llc, official logo 12/8/2022

Connect Now

Quickly Visualize your latitude and longitude in Tableau Desktop.

Can you copy and paste? You’re hired! Copy and Paste Latitude and Longitude in Tableau Desktop, any data will do.

We are using our data from a previous tutorial – where we learned to Split

Did you know you can copy and paste data in Tableau Desktop?

One of my favorite pro tips was this beautiful under the hood feature. If you have anything stored in your clipboard, you can paste it in Tableau to generate a Table. It keeps it in the product, and not approachable with SQL currently.

Copy and Paste Latitude and Longitude in Tableau Desktop Tutorial by Dev3lop

Copy and Paste Latitude and Longitude in Tableau Desktop in 8 steps!

  1. Highlight all of your data in Google Sheets.
  2. Copy everything you want to use in Tableau Desktop.

    Copy and Paste Latitude and Longitude in Tableau Desktop sreen shots of copy

    Right-click after highlighting everything you want to map in Tableau Desktop. Include headers and name them correctly before bringing them over.

  3. Swap toTableau Desktop.
  4. Shortcut Key Paste Ctrl+V or Command+V

    Copy and Paste Latitude and Longitude in Tableau Desktop

    This is what it will look like after pasting the data. A table of data in Tableau Desktop!

  5. Tableau Desktop natively generates a Tableau Data source and names it for you quickly.
    • ‘Clipboard_YEAR/MONTH/DAY/’T’/HR/MIN/SEC’
  6. Clear the dashboard.

    Copy and Paste Latitude and Longitude in Tableau Desktop clear button

    Clear button to remove all content on the visualization.

  7. Double click Latitude and then double-click Longitude
  8. Drag Key to detail in the marks card. (below color – which will also work)

    Copy and Paste Latitude and Longitude in Tableau Desktop

    Here we go. Although this data has some errors in it. I will save that for another blog. Here’s a map of my client touches in the past couple of years.

You think you like buttons?
Austin SEOTableauBI