{"id":81471,"date":"2018-01-11T12:30:14","date_gmt":"2018-01-11T12:30:14","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/create-a-story-map-tour-using-a-spreadsheet\/"},"modified":"2024-04-08T18:19:19","modified_gmt":"2024-04-09T01:19:19","slug":"create-a-story-map-tour-using-a-spreadsheet","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/story-maps\/mapping\/create-a-story-map-tour-using-a-spreadsheet","title":{"rendered":"Create a Story Map Tour using a spreadsheet"},"author":7641,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941],"tags":[29641,25261,24871],"industry":[],"product":[36571,36551,36611],"class_list":["post-81471","blog","type-blog","status-publish","format-standard","hentry","category-mapping","tag-csv","tag-story-map-tour","tag-story-map-tutorial","product-arcgis-enterprise","product-arcgis-online","product-story-maps"],"acf":{"short_description":"A popular story map is Story Map Tour, used for Palm Springs Map Tour, San Diego Mission Bay Reserve, and many other interesting stories....","flexible_content":[{"acf_fc_layout":"content","content":"

Note<\/strong>: This blog article covers the classic Esri Story Maps which are in mature support and scheduled to be retired in late 2025<\/strong>. Story authors are strongly encouraged to use the new ArcGIS StoryMaps<\/a> to create stories.<\/p>\n

For more information about transitioning to the new StoryMaps, see ArcGIS StoryMaps resources<\/a>. For more information about the transition from classic Esri Story Maps to the new ArcGIS StoryMaps, see Esri Story Maps: Now in mature support<\/a>.<\/p>\n

\"\"<\/p>\n"},{"acf_fc_layout":"content","content":"

A popular story map is Story Map Tour, used for Palm Springs Map Tour<\/a>, San Diego Mission Bay Reserve<\/a>, and many other<\/a> interesting stories. This app\u00a0is ideal when you want to present a linear, place-based narrative featuring images or videos. Each stop in the narrative is geo-located. Viewers have the option of clicking sequentially through the narrative, or they can browse by interacting with the map or using the thumbnail carousel.<\/p>\n

One of the ways you can build a Map Tour is by using a spreadsheet (CSV file) with the locations of the photos you want to use, the title and description of each tour stop, and more. Using a spreadsheet is ideal when you want to collaborate with others, check spelling, and make modifications. Here’s an example of using a CSV file to build a Story Map Tour.<\/p>\n

*<\/span>
\nThe project<\/span><\/h2>\n

For this project we wanted to create an interactive Story Map version of a printed map included in a visitors guide published by the local newspaper, the Redlands Daily Facts<\/em>. You might find copies of the guide in the visitor’s lounge in Esri’s reception area, and elsewhere around town. Here’s the printed map:<\/p>\n

\"\"<\/a><\/p>\n

Here is the Map Tour:<\/p>\n

\"\"<\/a><\/p>\n

*<\/span>
\nThe steps<\/span><\/h2>\n

To create the map tour using a CSV file, we followed a few simple steps outlined below. To successfully publish your own Story Map Tour you’ll need to login to your ArcGIS Online account, and must have hosted the the photos you will use on a publicly accessible server, social media site, or in your ArcGIS account.<\/p>\n

Step 1 – Open the Story Map Tour builder<\/strong><\/p>\n

Go to the Story Maps website, sign in to your account, and click the Apps tab to view the App List<\/a>.<\/p>\n

\"\"<\/p>\n

Locate Story Map Tour, and launch the Map Tour builder by clicking Build.<\/p>\n

\"\"<\/p>\n

Step 2 – Download the CSV file template<\/strong><\/p>\n

Click Advanced options (the gears graphic):<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Then click Download the CSV template:<\/p>\n

\"\"<\/p>\n

Once you’ve downloaded the CSV template, you can quit the Map Tour builder without saving. We’ll edit the CSV file and import it later.<\/p>\n

Step 3<\/strong> – Prepare and host your photos<\/strong><\/p>\n

For each location on your map, you’ll need two versions of the same photograph or image. One is a thumbnail that is displayed in the thumbnail gallery, and the other is a larger version that displays in the frame for the selected location.<\/p>\n

\"\"<\/p>\n

The size of the photos will have an impact on the performance of the application, so keep these to a minimum. For best results we recommend a size of roughly 1000 x 750 pixels for the larger version of each photo, and size of 120 x 90 pixels for the thumbnails (both at 72 DPI). Your photos don’t need to have these exact dimensions; photos and thumbnails that are different in size or aspect ratio will be fit into the application.<\/p>\n

Once you’ve edited your photo pairs, upload them to your public web location so they can be referenced in the application via their URL. For example, below are the URLs for one of the photos and its corresponding thumbnail used in our application:<\/p>\n

http:\/\/downloads2.esri.com\/agol\/pub\/redlandsguide\/graphics\/barton.jpg<\/a><\/p>\n

http:\/\/downloads2.esri.com\/agol\/pub\/redlandsguide\/graphics\/barton-thumb.jpg<\/a><\/p>\n

Step 4 – Edit the downloaded CSV template<\/strong><\/p>\n

Edit the CSV file downloaded in Step 2 (it is named Locations.csv) and replace it with your data. You can use Notepad or any other text editor to make the necessary changes. The field names must remain the same, though they are not case-sensitive. Order is not important, and you can have additional fields.<\/p>\n

Field names and contents are:<\/p>\n